添加mysql 用户

[xiaojiit]

如何添加一个mysql数据库的用户呢？并让他只能访问特定的数据库？谢谢高手了。

[feillex]

grant all privileges on dbname.* to 'dbuser'@'%' identified by 'dbpass';

[ydage]

#建立用户u1(密码u1)
create user u1 identified by u1;

#授予用户u1在test库上的所有权限
grant all on test.* to u1;

[kxy4341]

5.0.22版的
connect mysql;
insert into user (Host,User,Password,Select_priv,Insert_priv,Update_priv,Delete_priv,
Create_priv,Drop_priv,Reload_priv,Shutdown_priv,Process_priv,File_priv,
Grant_priv,References_priv,Index_priv,Alter_priv,Show_db_priv,Super_priv,
Create_tmp_table_priv,Lock_tables_priv,Execute_priv,Repl_slave_priv,
Repl_client_priv,Create_view_priv,Show_view_priv,Create_routine_priv,
Alter_routine_priv,Create_user_priv) values ('192.168.1.100','auditor',password('123456'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y',
'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
flush privileges;

[xqh2168]

[Quote=引用 2 楼 ydage 的回复:]
#建立用户u1(密码u1)
create user u1 identified by u1;

#授予用户u1在test库上的所有权限
grant all on test.* to u1;
[/Quote]
right

[yifuzhiming]

通过可视化工具也能很方便的做到啊