Fatih Şahin - My Personal Website

Hello,

Today, we will share with you the Navicat MySQL password changing process via Putty.
First, connect to Putty SSH, after logging in, simply follow the commands below.

/usr/local/etc/rc.d/mysql-server stop

mysqld_safe --skip-grant-tables &

mysql -u root

use mysql;

update user set password=PASSWORD("fatihsahin") where User='root';

flush privileges;

quit

/usr/local/etc/rc.d/mysql-server start

If the above command gives an error, please try the following command.

/usr/local/etc/rc.d/mysql-server restart

After executing all the commands above, your new password will be activated.
At the end of the process, there is no need to reboot your server.
Your new password; He became "fatihsahin". (Only in quotation marks.)

Hope to see you in another article...

Putty password reset via SSH / (488)