improve

非原创,原文转载自: http://snowolf.iteye.com/blog/1625674   要修改MySQL的root密码，有两个先决条件： •有修改MySQL配置文件的权限 •有重启MySQL服务的权限 先修改配置文件： # vim /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql...

mysql> use mysql; Database changed mysql> grant all privileges on *.* to root@'%' identified by "密码"; --%是表示所有的远程机器,如果指定单台此处写成ip Query OK, 0 rows affected (0.00 sec) mysql> flush privil...