help required with access privileges to localhost using phpmyadmin

[mike08]

Below is the error i get when trying to add a new user called
mike@localhost with password - i want to give full privileges to a database.

please can someone help me?

Server localhost
Error

SQL-query :

GRANT ALL PRIVILEGES ON . TO "mike"@ "localhost"IDENTIFIED BY "********"WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;

MySQL said:

#1045 - Access denied for user: '@' (Using password: NO)

[Simon_Hartley]

I know the server name is localhost but are you running a server locally (ie on your computer) to try things out on? If so what operating system are you using?

[mike08]

windows xp im using

[Simon_Hartley]

Ok.

Running MySQL on windows you shouldn't need to grant these privileges. They are set as default when you install MySQL. If your running PHP MySQL & Apache to test out scripts locally you shouldn't need to add a new user.

Connect to MySQL using the following the details below - note that there are NO arguments in the mysql_connect function.

<?php
$link = mysql_connect();
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
?>

I had to work this out the hardway although it is mentioned in the MySQL manual(but doesn't state what goes in mysql_connect last time I looked--their site is very slow for me today will check again later ).

Make sure MySQL Admin is running and the traffic light is green in your system tray :0)

Let me know you how you get on and mark this thread as resolved if thats the case.