mysql默认用户名_MYSQL默认用户名ROOT修改方法

感兴趣的小伙伴，下面一起跟随编程之家 jb51.cc的小编两巴掌来看看吧！

用root身份登入 进入mysql库 修改user表即可。

操作如下：

G:\phpStudy\MySQL\bin>mysql -uroot -proot

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 391

Server version: 5.0.51b-community-nt-log MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use mysql;

Database changed

mysql> update user set user='xly' where user='root';

Query OK,2 rows affected (0.00 sec)

Rows matched: 2 Changed: 2 Warnings: 0

mysql> flush privileges;

mysql> select user,host,password from mysql.user;

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

| user | host | password |

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