MYSQL中已存在用户变更权限 我在安装论坛的时候,新建了一个MYSQL用户,权限是ALL(grant all ……),现在论坛安装好了,我想让这个用户只能操作特定数据库(访问和修改,包括创建删除表,最好不能删除数据库,但做不到就算了),例如test数据库,其他数据库一概不能修改,最好也不能访问,请问改怎么做?我的mysql装在server版的linux上,一般就用mysql -u root -p 来执行管理,没有使用图形化工具(server没有图形界面) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 呵呵呵,地方错了,可以先revoke all privileges on *.* from ....然后再重新grant all privileges on schema1.* to ....给你转到mysql revoke all on *.* from '用户名'@'登陆机器ip';grant select,insert,update,delete table on test.* to '用户名'@'登陆的机器ip' 楼上讲得已经很清楚了。先收加权限 revoke ... (你可以用 show grant username 来看授了哪些权限,然后revoke)revoke ALL on *.* from username;然后再 grant ALL on databasename.* to username 你可以参考 mysql数据库的db表mysql> desc db;+-----------------------+---------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+-----------------------+---------------+------+-----+---------+-------+| Host | char(60) | NO | PRI | | || Db | char(64) | NO | PRI | | || User | char(16) | NO | PRI | | || Select_priv | enum('N','Y') | NO | | N | || Insert_priv | enum('N','Y') | NO | | N | || Update_priv | enum('N','Y') | NO | | N | || Delete_priv | enum('N','Y') | NO | | N | || Create_priv | enum('N','Y') | NO | | N | || Drop_priv | enum('N','Y') | NO | | N | || Grant_priv | enum('N','Y') | NO | | N | || References_priv | enum('N','Y') | NO | | N | || Index_priv | enum('N','Y') | NO | | N | || Alter_priv | enum('N','Y') | NO | | N | || Create_tmp_table_priv | enum('N','Y') | NO | | N | || Lock_tables_priv | enum('N','Y') | NO | | N | || Create_view_priv | enum('N','Y') | NO | | N | || Show_view_priv | enum('N','Y') | NO | | N | || Create_routine_priv | enum('N','Y') | NO | | N | || Alter_routine_priv | enum('N','Y') | NO | | N | || Execute_priv | enum('N','Y') | NO | | N | || Event_priv | enum('N','Y') | NO | | N | || Trigger_priv | enum('N','Y') | NO | | N | |+-----------------------+---------------+------+-----+---------+-------+22 rows in set (0.02 sec) mysql 我用phpmyadmin 修改密码后,为什么无法登录了 如何快速插入大量数据比如几千万上亿的带索引的数据 Mysql 1000千w级表优化 有没有什么办法找回drbd被full sync以前的数据 求MySQL早期源代码 [求助]新手,MYSQL语句执行出错,在线等答案,这是MYSQL的BUG? mysql字符集和校对引发的问题... 使用PD,MSSQL转换mysql数据库的问题 mysql数据库客户端和mysql数据库服务器区别 在phpmyadmin中存入下面的ip地址,最后几位不见了。怎么办 关于MySQL跨服务器查询的问题 增加数据库密码?
revoke ALL on *.* from username;然后再 grant ALL on databasename.* to username
mysql> desc db;
+-----------------------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------+---------------+------+-----+---------+-------+
| Host | char(60) | NO | PRI | | |
| Db | char(64) | NO | PRI | | |
| User | char(16) | NO | PRI | | |
| Select_priv | enum('N','Y') | NO | | N | |
| Insert_priv | enum('N','Y') | NO | | N | |
| Update_priv | enum('N','Y') | NO | | N | |
| Delete_priv | enum('N','Y') | NO | | N | |
| Create_priv | enum('N','Y') | NO | | N | |
| Drop_priv | enum('N','Y') | NO | | N | |
| Grant_priv | enum('N','Y') | NO | | N | |
| References_priv | enum('N','Y') | NO | | N | |
| Index_priv | enum('N','Y') | NO | | N | |
| Alter_priv | enum('N','Y') | NO | | N | |
| Create_tmp_table_priv | enum('N','Y') | NO | | N | |
| Lock_tables_priv | enum('N','Y') | NO | | N | |
| Create_view_priv | enum('N','Y') | NO | | N | |
| Show_view_priv | enum('N','Y') | NO | | N | |
| Create_routine_priv | enum('N','Y') | NO | | N | |
| Alter_routine_priv | enum('N','Y') | NO | | N | |
| Execute_priv | enum('N','Y') | NO | | N | |
| Event_priv | enum('N','Y') | NO | | N | |
| Trigger_priv | enum('N','Y') | NO | | N | |
+-----------------------+---------------+------+-----+---------+-------+
22 rows in set (0.02 sec)