Solved

Access denied for user: '@localhost' to database 'myblog'

Posted on 2004-10-06
9
784 Views
Last Modified: 2013-12-12
I am having a problem trying to connect with MySQL with PHP.  I get this error.  Access denied for user: '@localhost' to database 'myblog'

This is my code:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
      <title>Untitled</title>
</head>

<body>
<?
      ini_set ('display_errors', 1);
      error_reporting (E_ALL & ~E_NOTICE);
      
      if ($dbc = mysql_connect('127.0.0.1', 'fizz', '************')) {          // I covered my password
            print '<P>Successfuly connected to MySQL.</P>';
            mysql_close();
      } else {
            print '<p>Could not connect to MySQL.</p>';
      }
      
      if (@mysql_query ('CREATE DATABASE myblog')) {
            print '<P>The Database has been created!</P>';
      } else {
            die ('<p>Could not create the database because: <b>' . mysql_error() . '</b></p>');
      }
?>

</body>
</html>

END CODE

And as you can see in this screen shot: http://fizzmahon.2mydns.com/error.jpg
i have all the privaledges....

after running my code in a browser i get this...
-------
Successfuly connected to MySQL.

Could not create the database because: Access denied for user: '@localhost' to database 'myblog'
-------

and you can see it for yourself here: http://fizzmahon.2mydns.com/Temp/mysql.php

THANKS IN ADVANCED!!!  IF YOU NEED ANY MORE INFO I CAN TELL YOU =D

FiZZ


0
Comment
Question by:DIDD0
  • 4
  • 4
9 Comments
 
LVL 49

Expert Comment

by:Roonaan
Comment Utility
Possibly you have to use mysql_connect('localhost',......), but that's just a hunch. Or change the localhost-domain in your user management into 127.0.0.1

Regards

-r-
0
 

Author Comment

by:DIDD0
Comment Utility
nope same error
0
 
LVL 12

Expert Comment

by:minichicken
Comment Utility
<?
     ini_set ('display_errors', 1);
     error_reporting (E_ALL & ~E_NOTICE);
     
     if ($dbc = mysql_connect('127.0.0.1', 'fizz', '************')) {          // I covered my password
          print '<P>Successfuly connected to MySQL.</P>';
          mysql_close();
     } else {
          print '<p>Could not connect to MySQL.</p>';
     }

mysql_query ("CREATE DATABASE myblog") or die (mysql_error());

?>

Can you post the error if you use this code... thanks
0
 

Author Comment

by:DIDD0
Comment Utility
Successfuly connected to MySQL.

Access denied for user: '@localhost' to database 'myblog'
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 12

Accepted Solution

by:
minichicken earned 75 total points
Comment Utility
Is it working now? I just check your link http://fizzmahon.2mydns.com/Temp/mysql.php

and got this as the result, the DB has been created....

*************************************
Successfuly connected to MySQL.

Could not create the database because: Can't create database 'myblog'. Database exists
0
 

Author Comment

by:DIDD0
Comment Utility
thats wierd...  let me check
0
 

Author Comment

by:DIDD0
Comment Utility
Yes it is working now...  but i didnt change anything?!?!?! all i did was install phpmyadmin...

anyways i will grant you points...
0
 
LVL 12

Expert Comment

by:minichicken
Comment Utility
thanks DIDD0 :) greatly appreciated ^_^
0
 
LVL 12

Expert Comment

by:minichicken
Comment Utility
Well, good that it working for you :)

However, I did try the code I posted above locally and it worked.....
but on my MySQL, I use "root" as the user with a blank password.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Introduction HTML checkboxes provide the perfect way for a web developer to receive client input when the client's options might be none, one or many.  But the PHP code for processing the checkboxes can be confusing at first.  What if a checkbox is…
Author Note: Since this E-E article was originally written, years ago, formal testing has come into common use in the world of PHP.  PHPUnit (http://en.wikipedia.org/wiki/PHPUnit) and similar technologies have enjoyed wide adoption, making it possib…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to dynamically set the form action using jQuery.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now