＋设为首页 ＋添加到收藏夹
如题
该如何设置用户名和密码呢?
呵呵,
WIN32下新安装MySQL，用户权限如下：
假设mysql安装在D:\mysql目录下，
本机IP为 192.168.0.2
d:\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"用户名登录本机的MySQL
mysql>UPDATE user SET Password = PASSWORD("123456");
->将所有用户的密码更换为 123456
mysql>FLUSH PRIVILEGES;
->刷新用户授权表
到如下地址下载一个MySQLAdmin v1.0.6，这些问题都可以迎刃而解的
http://www.freewebs.com/friendlysoft/MySQLAdmin_v1.0.6.rar
