MySql root 修改远程访问权限

两种方法

Grant privileges. As root user execute:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password';

bind to all addresses:
The easiest way is to comment out the line in your my.cnf file:
```
#bind-address = 127.0.0.1 
and restart mysql

service mysql restart
```

MySql 5.7 简单密码禁止修改的问题

create a six character password in mysql 5.7
It's possible to entirely disable the password "plugin" that seems overly strict by running the following: uninstall plugin validate_password

Should you need it again you can turn it back on via: INSTALL PLUGIN validate_password SONAME 'validate_password.so'

Optionally, you could disable it, set your password and re-enable it:


uninstall plugin validate_password;
CREATE USER 'newsier'@'localhost' IDENTIFIED BY 'special';
INSTALL PLUGIN validate_password SONAME 'validate_password.so';

Further reading:
https://dev.mysql.com/doc/refman/5.7/en/server-plugin-loading.html
https://dev.mysql.com/doc/refman/5.7/en/validate-password-plugin-installation.html

最后编辑于：2017.12.06 00:12:52

©著作权归作者所有,转载或内容合作请联系作者
【社区内容提示】社区部分内容疑似由AI辅助生成，浏览时请结合常识与多方信息审慎甄别。
平台声明：文章内容（如有图片或视频亦包括在内）由作者上传并发布，文章内容仅代表作者本人观点，简书系信息发布平台，仅提供信息存储服务。

MySql root 修改远程访问权限