MySQL Forums :: Newbie :: Setting up root password


Advanced Search

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:

C:\xampp\mysql\bin\mysql

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


Subject Written By Posted
Setting up root password Jeff Bollettino 12/29/2011 05:57PM
Re: Setting up root password Peter Brawley 12/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.