a13698822086 发表于 2018-10-11 10:57:42

Linux下mysql的部署和安装-RPM方式

mysql> use mysql;  

  
mysql> select host,user,password from user;+-----------------------+------+-------------------------------------------+
  

  
| host                  | user | password                                  |
  

  
+-----------------------+------+-------------------------------------------+
  

  
| localhost             | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
  

  
| localhost.localdomain | root | *1237E2CE819C427B0D8174456DD83C47480D37E8 |
  

  
| 127.0.0.1             | root | *1237E2CE819C427B0D8174456DD83C47480D37E8 |
  

  
| ::1                   | root | *1237E2CE819C427B0D8174456DD83C47480D37E8 |
  

  
+-----------------------+------+-------------------------------------------+
  

  
mysql> update user set password=password('123456') where user='root';
  

  
mysql> update user set host='%' where user='root' and host='localhost';
  

  
mysql> flush privileges;
  

  
mysql> exit


页: [1]
查看完整版本: Linux下mysql的部署和安装-RPM方式