- Go to your xampp\mysql\bin\ folder
- Edit my.ini and insert
skip-grant-tables
below[mysqld]
- Restart MySQL
- Set new password for your root user by running
UPDATE mysql.user SET Password=PASSWORD('new_password') WHERE User='root'
in phpMyAdmin in the mysql database (or just leave it like this if MySQL cannot be accessed from remote hosts)
No comments:
Post a Comment