Mysql Change Password

[Fevzi]

Hi,

Today we will share with you the Navicat MySQL password change process via Putty.

First of all, connect to Putty SSH, after logging in, just follow the commands below.

Kod:

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

Kod:

mysqld_safe --skip-grant-tables &

Kod:

mysql -u root

Kod:

use mysql;

Kod:

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

Kod:

flush privileges;

Kod:

quit

Kod:

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

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

Kod:

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

After executing all the commands above, your new password will be active.

At the end of the process, you do not need to reboot your server.

Your new password; It became 'metin2core'. (Only in quotation marks.)

Hope to see you in another article...

​