Change MySql Password

Post author: GoldenaArcher
Post link: <a href="https://goldenaarcher.com/2019/06/14/Change-MySql-Password-with-XAMPP/" title="Change MySql Password">https://goldenaarcher.com/2019/06/14/Change-MySql-Password-with-XAMPP/
Copyright Notice: All articles in this blog are licensed under <a href="https://creativecommons.org/licenses/by-nc-sa/4.0/" rel="noopener" target="_blank"> BY-NC-SA unless stating additionally.

Posted on 2019-06-14 | In XAMPP , MySql | Comments: | Views:

Symbols count in article: 702 | Reading time ≈ 1 mins.

Somehow I ended up having MySql installed by XAMPP with super long password, and I want just to change it back to root.

I have searched a lot on the StackOverflow and Google, none of them work, until I saw reset root password with wrong mysql config. The first comment works!

I’d suggest to forget the bat file and do it manually:

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)

andrekr