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