[root@localhost Anylinux]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 3.23.56
Type ‘help;‘ or ‘\h‘ for help. Type ‘\c‘ to clear the
buffer.
mysql> USE mysql ;
Reading table information for completion of table and column
names
You can turn off this feature to get a quicker startup with
-A
Database changed
mysql> UPDATE user SET Password = password (
‘anylinux‘ ) WHERE User = ‘root‘ ;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 2 Changed: 0 Warnings: 0
mysql> flush privileges ;
Query OK, 0 rows affected (0.01 sec)
mysql> quit
Bye
重启mysql服务
mysql -u root -p登录mysql
OK 成功登录了。
