mysql> CREATE USER 'username'@'%' IDENTIFIED BY 'yourpassword';//创建账户
mysql> GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION; //赋予权限
mysql> flush privileges;//刷新权限
mysql> CREATE USER 'username'@'%' IDENTIFIED BY 'yourpassword';//创建账户
mysql> GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION; //赋予权限
mysql> flush privileges;//刷新权限
本文标题:Mysql8修改数据库权限
本文链接:https://www.haomeiwen.com/subject/wjxsahtx.html
网友评论