navicat远程连接mysql,2003 can't connect to mysql server on 10038
来源:互联网 发布:centos下安装jdk1.8 编辑:程序博客网 时间:2024/06/06 16:53
连接远程服务器的mysql,如果出现问题,很大问题会出在服务器的端口和授权问题。
首先我们通过
①:netstat -an | grep 3306
来查看mysql默认的端口3306是否开启,允许哪个ip使用,如果你发现,前面有127.0.0.1,就说明,3306端口只能本机ip使用所以,我们需要
②:打开mysql配置文件 sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf将bind-address = 127.0.0.1注销
或改为bind-address = 0.0.0.0
③:进入mysql,mysql -u root -p
输入密码
对远程用户进行授权,
grant all privileges on *.* to 'root'@'%' identified by 'xxxxxx';
这里的root 是你远程登录的用户,xxxxxx是你登录使用的密码,然后可以在mysql数据 表中查看到你这个用户已经被添加到user表中。
④:修改生效,mysql>FLUSH PRIVILEGES;
⑤:退出,mysql>EXIT
⑥:重启MySQL服务,service mysqld restart
阅读全文
0 0
- 转:navicat远程连接mysql,2003 can't connect to mysql server on 10038
- navicat远程连接mysql,2003 can't connect to mysql server on 10038
- Navicat连接远程mysql数据库error报错2003 can't connect to mysql server on 10038解决办法
- win10连接navicat 连接mysql server时遇到2003-Can't connect to MySQL server on 'localhost'(10038)错误
- Navicat连接MySQL数据库错误2003 - Can't connect to MySQL server on 'localhost'(6)
- Navicat连接mysql出现2003——can't connect to mysql server on localhost(10061)
- navicat for Mysql:2003 can't connect to mysql server on 'localhost'(10038)问题的解决方法
- 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'的问题
- Navicat for Mysql连接mysql数据库时出现 2003-Can't connect to MySql server on 'localhost'(10061)
- navicat for mysql 远程连接数据库时出现2003-Can't connect to Mysql on '主机名'(10061)解决方法
- navicat for mysql 远程连接数据库时出现2003-Can't connect to Mysql on '主机名'(10061)解决方法
- navicat for mysql 远程连接数据库时出现2003-Can't connect to Mysql on '主机名'(10061)解决方法
- Navicat 2003-can't connect to MYSQL server on 'localhost'(10038)
- windows7 wampserver下,远程连接OperationalError: (2003, "Can't connect to MySQL server on '****' (10060)")
- DNS与TCP、UDP协议
- [LibreOJ β Round #4]子集
- JavaScript 书写方式与注释
- MySQL 5.7 (3复制)
- Unity 3D项目问题笔记 //02_制作 2D UI相关问题
- navicat远程连接mysql,2003 can't connect to mysql server on 10038
- Linux(二):巧用分号在命令行执行逻辑判断语句
- LeetCode-8-String-to-Integer (atoi) 细节题
- Coming Back
- JS变量与命名规范
- 1.计算机组成原理笔记一计算机系统概论
- Cannot load underlying module for 'SnapKit' 通过Cocoapods导入SnapKit(大坑!!!)
- js 导出 excel 身份证号等长数字变成科学计数法
- VIM自动补全神器 — YouCompleteMe 安装全教程