aws linux服务器,ubuntu,远程连接MySQL,ERROR 2003 (HY000): Can't connect to MySQL server on
来源:互联网 发布:中国万网域名申请流程 编辑:程序博客网 时间:2024/06/05 15:30
1.如果使用aws服务器,进入aws控制台,找到运行实例的安全组,编辑入站安全组,添加规则。选择规则MYSQL/Aurora,端口设置为3306,保存
2.取消绑定地址,允许来自外网的访问。编辑/etc/mysql/mysql.conf.d/mysqld.cnf 找到bind-address = 127.0.0.1,在其前面添加#,注释该行。
3.登录数据库,执行以下代码
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;FLUSH PRIVILEGES;
第一行代码作用为创建用户username,设置密码为password,并且允许来自所有域名的访问,第二行代码为更新权限。
如果更改已有的用户允许远程访问可以修改mysql数据库下user表,将默认字段Host内容‘localhost’更改为‘%’。
将root设置为可使用外网访问;
USE mysql;UPDATE user SET Host='%' where User='root';FLUSH PRIVILEGES;
如果还是没有生效,请留言
阅读全文
1 0
- aws linux服务器,ubuntu,远程连接MySQL,ERROR 2003 (HY000): Can't connect to MySQL server on
- MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'的问题
- MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'的问题
- MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'的问题
- MySQL远程连接ERROR 2003 (HY000):Can\'t connect to MySQL server on\'XXXXX\'的问题
- MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'的问题
- 【linux错误解决】MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'的问题
- ERROR 2003 (HY000): Can't connect to MySQL server on
- MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'(111) 的问题
- MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'(111) 的问题
- MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'(111) 的问题
- MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'(111) 的问题
- 【错误处理】mysql远程连接ERROR 2003 (HY000): Can't connect to MySQL server on '10.211.55.6' (113)
- MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'(111) 的问题
- (笔记)远程连接MySQL出现ERROR 2003 (HY000): Can't connect to MySQL server on ip (111)
- Ubuntu ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)
- MySQL远程访问报错ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'(111)
- 连接mysql报错:error 2003 (hy000):can't connect to mysql server on 'localhost' (10061)
- Cubic Eight-Puzzle UVA
- IK和pinyin分词器
- 倒计时
- ES6-rest参数和扩展运算符
- 访问TensorFlow官网的问题
- aws linux服务器,ubuntu,远程连接MySQL,ERROR 2003 (HY000): Can't connect to MySQL server on
- 【备忘】中移动大型分布式redis,solr,Linux,nginx,springmvc,mybatis电商项目
- angular上传文件和ajax上传文件
- ubuntu 16.04 -- docker建立 private registry2
- 读取txt文件然后录入数据库(批处理)
- js页面上的excel导出
- 修改easyui window的title属性
- 欢迎使用CSDN-markdown编辑器
- 最全的常用正则表达式大全——包括校验数字、字符、一些特殊的需求等等