日志

Reset root password with wrong mysql config

Step1 :Go to your xampp\mysql\bin\ folder
Step2 :Edit my.ini and insert skip-grant-tables below [mysqld]
Step3 :Restart MySQL
Step4 :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)

THIS WORKED FOR ME :)