呵呵,
WIN32下新安装MySQL,用户权限如下:
假设mysql安装在D:\mysql目录下,
本机IP为 192.168.0.2d:\mysql\bin>mysql -u root
mysql>use mysql
mysql>select * from mysql.user;
+-----------+------+----------+------------+------------.............-+------------+
| Host | User | Password |Select_priv |Insert_priv ............. | ALter_priv |
+-----------+------+----------+------------+------------.............-+------------+
| localhost | root | |Y |Y | Y ....... | Y |
| % | root | |Y |Y | Y ....... | Y |
| localhost | | |Y |Y | Y ....... | Y |
| % | | |N |N | N ....... | N |
+-----------+------+----------+------------+------------.............-+------------+
4 rows in set (0.00 sec) mysql>DELETE FROM user WHERE Host='%' and User='';
->删除第四个用户mysql>DELETE FROM user WHERE Host='%' and User='root';
->删除第二个用户,不允许其它计算机以"root"用户名登录本机的MySQLmysql>UPDATE user SET Password = PASSWORD("123456");
->将所有用户的密码更换为 123456mysql>FLUSH PRIVILEGES;
->刷新用户授权表
WIN32下新安装MySQL,用户权限如下:
假设mysql安装在D:\mysql目录下,
本机IP为 192.168.0.2d:\mysql\bin>mysql -u root
mysql>use mysql
mysql>select * from mysql.user;
+-----------+------+----------+------------+------------.............-+------------+
| Host | User | Password |Select_priv |Insert_priv ............. | ALter_priv |
+-----------+------+----------+------------+------------.............-+------------+
| localhost | root | |Y |Y | Y ....... | Y |
| % | root | |Y |Y | Y ....... | Y |
| localhost | | |Y |Y | Y ....... | Y |
| % | | |N |N | N ....... | N |
+-----------+------+----------+------------+------------.............-+------------+
4 rows in set (0.00 sec) mysql>DELETE FROM user WHERE Host='%' and User='';
->删除第四个用户mysql>DELETE FROM user WHERE Host='%' and User='root';
->删除第二个用户,不允许其它计算机以"root"用户名登录本机的MySQLmysql>UPDATE user SET Password = PASSWORD("123456");
->将所有用户的密码更换为 123456mysql>FLUSH PRIVILEGES;
->刷新用户授权表
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货