grant 权限1,权限2,…权限n on 数据库名称.表名称 to 用户名@用户地址 identified by ‘连接口令’;
控制到库级的命令示范:
控制到库级的命令示范:
找到mysql安装目录下的路径 如:E:\Program Files\MySQL\MySQL Server 5.0\bin
运行 cmd
C:\Documents and Settings\xfinal>
C:\Documents and Settings\xfinal>E:
E:\>cd Program Files\MySQL\MySQL Server 5.0\bin
E:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -u root -p 此处的root就是以当前数据库root身份进入
Enter password: ****** 此处填写当前的数据库密码
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.22-rc-community-log MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>grant all privileges on meimei.* to meimei@localhost identified by '123456';
Query OK, 0 rows affected (0.05 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.06 sec)
mysql> exit
Bye
grant all privileges on meimei.* to meimei@localhost identified by '123456';
用户名为:meimei ----
用户名为:meimei ----
库名:meimei
密码:123456
SET PASSWORD FOR 'kuangqu'@ 'localhost' = PASSWORD( '********' )
更改mysql密码命令
密码:123456
SET PASSWORD FOR 'kuangqu'@ 'localhost' = PASSWORD( '********' )
更改mysql密码命令