linux登陆mysql服务器并修改密码

第一步：登陆mysql服务器
语法如下： mysql -u用户名 -p用户密码

root@b7581a8cd6a5:/# mysql -uroot -p
Enter password:

第二步：查看数据库，并进入mysql数据库

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| gen                |
| mysql              |
| performance_schema |
| sys                |
| test               |
+--------------------+
6 rows in set (0.00 sec)

mysql>  use mysql;
Database changed

第三步，查看user表的用户名

mysql> SELECT user, host, authentication_string FROM user;
+---------------+-----------+-------------------------------------------+
| user          | host      | authentication_string                     |
+---------------+-----------+-------------------------------------------+
| root          | localhost | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| mysql.session | localhost | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| mysql.sys     | localhost | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| root          | %         | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
+---------------+-----------+-------------------------------------------+

第四步，修改用户密码，语法如下：
SET PASSWORD FOR ‘用户名’@‘主机’ = PASSWORD(‘新密码’);
然后执行刷新命令flush privileges;

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123456');
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.03 sec)

Host is not allowed to connect to this MySQL server解决方法：

GRANT ALL PRIVILEGES ON *.* TO '用户名'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Aa123456' WITH GRANT OPTION;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

授权查询增加修改删除给特定用户语法：

grant select,insert,update,delete on *.* to ‘用户名’@‘主机’ Identified by "密码";