登录服务器 进入mysql:
mysql -u root -p
输入密码: xxx
查询使用的database
SHOW DATABASES;
选中database:
use hlt_creative;
授权
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mypwd' WITH GRANT OPTION;
刷新
flush privileges;
mysql -u root -p
输入密码: xxx
SHOW DATABASES;
use hlt_creative;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mypwd' WITH GRANT OPTION;
flush privileges;