查看权限
show grants for "test"@"localhost"
添加用户
create user "test"@"localhost" IDENTIFIED by "root";
修改密码
set PASSWORD for "test"@"localhost"=PASSWORD("test");
授权
GRANT ALL ON *.* TO 'test'@'localhost'
查看权限
show grants for "test"@"localhost"
添加用户
create user "test"@"localhost" IDENTIFIED by "root";
修改密码
set PASSWORD for "test"@"localhost"=PASSWORD("test");
授权
GRANT ALL ON *.* TO 'test'@'localhost'
本文标题:mysql用户和授权
本文链接:https://www.haomeiwen.com/subject/dlsutktx.html
网友评论