Reset XAMPP MySQL root password through SQL update phpmyadmin to work with it: Next, re-enable password checking by removing skip-grant-tables from C:\xampp\mysql\bin\my.ini. When you're done, run exit to exit the MySQL command line. UPDATE user SET password = '' WHERE user = 'root' -OR- To set all root user's to have a blank password, run this command:. ![]() UPDATE user SET password = PASSWORD('secret_pass') WHERE user = 'root'
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |