Intro to XAMPP - part 1

[DonkeyZone]

Error

MySQL said: Documentation

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

[dtguchi]

Try using a blank password. I noticed that your error said (using password: NO).

You can access MySQL from the command line to test your access. Try opening a command line terminal and change directory to your mysql program.  (e.g. > cd c:\xampp\mysql\bin )

Enter MySQL:

>mysql -u root -p

(You will be prompted for a password)

Exit MySQL:

mysql> quit

(note: "mysql>" is the prompt when you are already logged in.)

Hope this helps!

[DonkeyZone]

I made a mistake entering my password and hopefully you can point me in the right direction on how to fix it?

On the Privileges page I kept the user as "root" and on localhost.

The radial button for "Password Hashing: MySQL 4.1+ Database" was checked on and I clicked "Generate Password":

Then clicked "Go"

SET PASSWORD FOR 'root'@'localhost' =

I have the password saved, but now I am blocked from phpMyAdmin with an error message and it doesn't prompt me to enter a password.

Any ideas?

thnx

[SamCrawshaw]

Great video, really helpful.

Thanx.