C:\xampp\mysql\bin\my.ini (MySQL config file)
Find the line
[mysqld] and right below it add
# The MySQL server [mysqld] skip-grant-tables port= 3306 socket = "C:/xampp/mysql/mysql.sock" basedir = "C:/xampp/mysql" tmpdir = "C:/xampp/tmp" [...etc...]
This should allow you to access MySQL if you don't know your password.
Stop and start MySQL from XAMPP to make this change take effect.
Next, in command line, connect to MySQL:
Once in MySQL command line "select" the
Then, the following command will list all your MySQL users:
SELECT * FROM user \G;
You can scan through the rows to see what the
root user's password is set to. There will be a few
root users listed, with different hosts.
To set all
root user's to have a blank password, run this command:
UPDATE user SET password = '' WHERE user = 'root';
When you're done, run
exit; to exit the MySQL command line.
Next, re-enable password checking by removing
Save changes, restart MySQL from XAMPP.
Finally, test you can connect to the database using username
root and password
'' (blank) via one of the following methods: