Mysql8修改数据库权限
2020-05-24 本文已影响0人
Swye
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;//刷新权限