grant all privileges on `数据库名`.* to '用户名'@'%' identified by '密码' with grant option;
进入用户,show databases,显示analysis则表示授权成功
注意:若授权时,遇到ERROR 1819 (HY000): Your password does not satisfy the current policy requirements的问题
解决方法:
SHOW VARIABLES LIKE 'validate_password%';
set global validate_password_policy=LOW;
set global validate_password_length=6;
即可!