- 论坛徽章:
- 0
|
回复 #59 ruochen 的帖子
增加一个用户test1密码为abc,让他可以在任何主机上登录,并对所有数据库有查询、插入、修改、删除的权限。首先用以root用户连入MYSQL,然后键入以下命令:
grant select,insert,update,delete on *.* to test1@"%" Identified by "abc";
---------------------------------------------------------------------------------------------------
mysql> grant select, insert, update on *.* to test1@"%" Identified by "abc";
ERROR 1045 (28000): Access denied for user ''@'localhost' (using password: NO)
mysql> use mysql
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
mysql>
-----------------------------------------------------------------------------------------------------
这样,我就真的,“不能在本地登录”了。。。怎么办????
想添加用户也不行了。。。。
[ 本帖最后由 TOADLover 于 2009-9-24 11:22 编辑 ] |
|