Mysql中root用户是可以手工添加的,也可以通过grant赋权添加
1、
mysql> select host,user from user;
+-----------------------+----------------+
| host | user |
+-----------------------+----------------+
| % | market |
| % | marketuser |
| % | orderuser |
| % | qryorders_user |
| % | yhd_mobile |
| % | yhd_user |
| 10.1.0.99 | monitor |
| 127.0.0.1 | root |
| localhost | root |
| localhost.localdomain | root |
+-----------------------+----------------+
10 rows in set (0.00 sec)
mysql> insert into user(host,user,password) values('%','root',password('my_passsword'));
Query OK, 1 row affected, 3 warnings (0.00 sec)
mysql> select host,user from user;
+-----------------------+----------------+
| host | user |
+-----------------------+----------------+
| % | market |
| % | marketuser |
| % | orderuser |
| % | qryorders_user |
| % | root |
| % | yhd_mobile |
| % | yhd_user |
| 10.1.0.99 | monitor |
| 127.0.0.1 | root |
| localhost | root |
| localhost.localdomain | root |
+-----------------------+----------------+
2、
mysql> select host,user from user;
+-----------------------+----------------+
| host | user |
+-----------------------+----------------+
| % | market |
| % | marketuser |
| % | orderuser |
| % | qryorders_user |
| % | yhd_mobile |
| % | yhd_user |
| 10.1.0.99 | monitor |
| 127.0.0.1 | root |
| localhost | root |
| localhost.localdomain | root |
+-----------------------+----------------+
10 rows in set (0.00 sec)
mysql> grant all privileges on *.* to root@"%";
Query OK, 0 rows affected (0.00 sec)
mysql> select host,user from user;
+-----------------------+----------------+
| host | user |
+-----------------------+----------------+
| % | market |
| % | marketuser |
| % | orderuser |
| % | qryorders_user |
| % | root |
| % | yhd_mobile |
| % | yhd_user |
| 10.1.0.99 | monitor |
| 127.0.0.1 | root |
| localhost | root |
| localhost.localdomain | root |
+-----------------------+----------------+
11 rows in set (0.00 sec)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15480802/viewspace-687057/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15480802/viewspace-687057/