mysql授权登录用户

创建用户并授权

CREATE USER 'voctrals'@'%' IDENTIFIED BY 'some_password';

 

允许远程访问

GRANT ALL PRIVILEGES ON *.* TO 'voctrals'@'%' IDENTIFIED BY 'some_password' WITH GRANT OPTION;

 

如果想要这个用户本地也能够访问的话，需要额外执行： 

GRANT ALL PRIVILEGES ON *.* TO 'voctrals'@'localhost' IDENTIFIED BY 'some_password' WITH GRANT OPTION;

 

提交特权

flush privileges;

 

=====================================================================================

 

授权了用户之后还是不能够远程登陆的话，可以去服务器的 /etc/mysql/conf.d 文件下注释掉

host_address = 127.0.0.1

或

bind-address = 127.0.0.1

 

=====================================================================================

mysql my.cnf

 

lower_case_table_names=1

 

character-set-server=utf8

 

=====================================================================================

mysql 5.7

MySQL ERROR 1698 (28000) 错误

https://blog.csdn.net/ryshiki/article/details/50459008