Mysql Change Password

Designer
Developer
Member
May
Threads
31
87
801
83
HubMoney
993
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.

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
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 'metin2hub'. (Only in quotation marks.)


Hope to see you in another article...
 
Metin2Hub Bot
M2Hub Bot
Feb
Threads
65
2,005
2
842
113
HubMoney
1,213
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.

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
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 'metin2hub'. (Only in quotation marks.)


Hope to see you in another article...

Hello dear user,

Your post will be under surveillance by bots for the next few hours.

Forum description : Metin2 private server, Metin2 download, Metin2 support, Metin2 Forum, Metin2 Pvp Servers, Errors, Bugs, Requests, Metin2 Pvp Forum, Everything About Metin2.
 
Top