论坛 › MySQL运维 › mysql新建用户

zhk2369 发表于 2018-9-28 11:26:31

mysql新建用户

方法二:　　mysql>use mysql
　　mysql>INSERT INTO user VALUES('localhost', 'jerry', PASSWORD('password'),
　　'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'Y',);
　　mysql>INSERT INTO user (Host, User, Password)
　　VALUES('%', 'jim', PASSWORD('password'));
　　mysql>INSERT INTO db (Host, db, User,

　　Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv,>　　VALUES('%','jim','Y' ,'Y' ,'Y' ,'Y' ,'Y' ,'Y' ,'Y');
　　mysql>INSERT INTO user VALUES('server.domain', 'leon', PASSWORD('password')
　　'N','N', 'N', 'N', 'N', 'N', 'N', 'N' ,'Y' ,'Y' ,'Y','N', 'N', 'N');
　　mysql>FLUSH PRIVILEGES;

查看完整版本: mysql新建用户