MYSQL 5.7
#赋予用户对数据库dbname的全部权限
mysql>grant all privileges on dbname.* to 'user'@'%' identified by 'PASSword123.';
#使配置生效。
mysql>flush privileges;
MYSQL 8.0
#授权
mysql> grant all on dbname.* to "user"@"%" with grant option;
#使配置生效
mysql>flush privileges;