it shows up something like this: ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
So I tried to use php to testify the connection between mySQL and the server. And it comes out to be fine.
<?
$connection = mysql_connect("localhost", "root", "") or
die("Sorry - unable to connect to mySQL");
echo("Congraduations - u connected to mySQL.");
?>
The output is: Congraduations - u connected to mySQL.
So what should I do?
mysql> show databases;
+----------+
| Database |
+----------+
| mysql |
| test |
+----------+
2 rows in set (0.03 sec)
mysql> use mysql
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
Thankyou for ur advice, but I actually looked up the "use" keyword from a tutoral book. Maybe I misunderstand how the code works. Please help me.