MySQL modify password and settings allow Telnet _mysql

The modified user is in the column root.

First, the original myql of the root of the password;

Method One:

Outside the MySQL system, use the Mysqladmin

# mysqladmin-u root-p Password "test123" Enter
Password: "Enter the original password"

Method Two:
By logging in to the MySQL system,

# mysql-uroot-p
Enter Password: "Enter the original password"
mysql>use MySQL;
mysql> Update user Set Password=password ("test") where user= ' root ';
mysql> flush Privileges;
Mysql> exit;

Second, forget the original myql of the root password;

First, you have to have the operating system root permissions. If you don't have root access to the system, consider the root system and then follow the steps below.
Similar to the Safe Mode login system, it is suggested that Pkill MySQL, but I do not recommend Kazakhstan. Because when you execute this command, it can lead to a situation like this:

 
/etc/init.d/mysqld status
mysqld dead but Subsys locked

So even if you are in Safe mode to start MySQL may not be useful, so generally it is so/etc/init.d/mysqld stop, if you unfortunately first used Pkill, then start to stop again.

# Mysqld_safe--skip-grant-tables &

The above mentioned is the entire content of this article, I hope you can enjoy.