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.
If the above command gives an error, please try the below command.
After executing all the commands above, your new password will be active.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.
Code:
/usr/local/etc/rc.d/mysql-server stop
Code:
mysqld_safe --skip-grant-tables &
Code:
mysql -u root
Code:
use mysql;
Code:
update user set password=PASSWORD("metin2hub") where User='root';
Code:
flush privileges;
Code:
quit
Code:
/usr/local/etc/rc.d/mysql-server start
If the above command gives an error, please try the below command.
Code:
/usr/local/etc/rc.d/mysql-server restart
At the end of the process, you do not need to reboot your server.
Your new password; It became 'metin2hub'. (Only in quotation marks.)
Hope to see you in another article...