MySQL Forums
Forum List  »  Newbie

Setting up root password
Posted by: Jeff Bollettino
Date: December 29, 2011 05:57PM

I've just done a fresh install of XAMPP with Apache and MySQL. The directions I'm following (from a book) say to immediately set a root password, but the directions are not working for me. Perhaps someone here can give me a clue card?

In the command window I first navigate to the mysql prompt with the following:


Then the instructions were to type in the following, with my own password for 'thepassword'

SET PASSWORD FOR 'root'@' localhost' = PASSWORD ('thepassword');

However this returns the following:

Access denied for user ''@'localhost' to database 'mysql'

Any guidance on why this isn't working?

Options: ReplyQuote

Written By
Setting up root password
December 29, 2011 05:57PM
December 29, 2011 07:20PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.