asked on

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

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 'Successfuly connected to MySQL.';
 mysql_close();
 } else {
 print 'Could not connect to MySQL.';
 }

 if (@mysql_query ('CREATE DATABASE myblog')) {
 print 'The Database has been created!';
 } else {
 die ('Could not create the database because: ' . mysql_error() . '');
 }
?>

</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

Roonaan

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-

DIDD0

ASKER

nope same error

minichicken

<?
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 'Successfuly connected to MySQL.';
mysql_close();
} else {
print 'Could not connect to MySQL.';
}

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

?>

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

DIDD0

ASKER

Successfuly connected to MySQL.

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

ASKER CERTIFIED SOLUTION

minichicken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

DIDD0

ASKER

thats wierd... let me check

DIDD0

ASKER

Yes it is working now... but i didnt change anything?!?!?! all i did was install phpmyadmin...

anyways i will grant you points...

minichicken

thanks DIDD0 :) greatly appreciated ^_^

minichicken

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.