Question by tony: Having trouble with mysql administrator.?
“Access denied for user ”@’localhost’ to database mysql”
I done a google search, and it i came across the following solution:
“In this case, you must restart the server with the –skip-grant-tables option and edit your /etc/hosts file or \windows\hosts file to add an entry for your host.”
This happens despite me using the root account and entering the correct password.
I have no idea how to do this…I am very bad at coding, a real rookie so Id appreciate a very dumbed down explanation
Thanks guys! Really eager to supplement my PHP with SQL, so any help much appreciated.
Best answer:
Answer by runFunning
Access denied for user @ localhost to database mysql….
tells me you are trying to login as “user” and not root… to a database name mysql…
Make sure “user” has been given authority to access mysql and/or login as root
Good luck… getting it all setup is the huge pain in the butt… try to find a friend to walk you through it… I spent an entire weekend once trying to figure this stuff out and now can show someone how to get it all setup properly in about 15 minutes…. yeah… it’s easy once you get it.
Do additional searches for tutorials on the net… there an many.
good luck.
What do you think? Answer below!