MySQL: 2003 can't connect to mysql service on 'xxx' (10060)
来源:互联网 发布:别墅网络布线解决方案 编辑:程序博客网 时间:2024/05/16 05:08
在远程虚拟机上安装mariadb数据库之后,通过tomcat访问数据库,并实现页面展示和控制,却显示不了数据库的数据,通过tail -f catalina.out点击打开链接,查看tomcat的logs输出;发现在数据库访问的数据为null,但是在命令行使用命令进行访问数据库是没问题的,mysql -uroot -p,试了百度上的很多办法,也没有完美的解决,依然是2003 can't connect to mysql service on 'xxx' (10060),一种想死的心都有了,只好抱着电脑到大牛的办公位前,求抱大腿,还好大牛没有被我问烦(今天问人家四五次了,可不是不动脑子的问题哦~),帮我检查配置,Linux的设置,防火墙,端口设置,还有mariaDB的一些安装细节,大牛就是大牛,666!!!
但是依然无法解决这个问题,无奈之下,大牛说,我先把你tomcat中db-config.properties的这个改一下。。。
把箭头处的ip,改成127.0.0.1,应该就可以啦,你去看一下tomcat的logs,我刚坐到座位上,见tomcat运行完毕,打开浏览器访问,果然如大牛所料,一切OK,哇哦~~~崇拜~~~
大牛说,以后遇到这样的问题,可能就是这样简单的原因,各个系统的ip的配置有所不同,对于我们部署在和数据库同一台服务器的时候,尽可能使用它自己的127.0.0.1这个ip,使用它的随机IP,有可能造成错误和麻烦。
哎呀呀,受教了~
0 0
- MySQL: 2003 can't connect to mysql service on 'xxx' (10060)
- ERROR 2003 (HY000): Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (111)
- Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (10061),错误代码2003
- ERROR 2003 (HY000): Can't connect to MySQL server on 'xxx.xxx.xx.xxx' (111)
- Can't connect to MySQL server on 'xxx' (13)
- Can't connect to MySQL server on 'XXX' (13)
- Can't connect to Mysql server on xxx (10038)
- Mysql error number 2003 can't connect to mysql server on XXX(10061)
- Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (3)
- SQLSTATE[HY000] [2003] Can't connect to MySQL server on 'XXX' (13)
- SQLSTATE[HY000] [2003] Can't connect to MySQL server on 'XXX'
- SQLSTATE[HY000] [2003] Can\'t connect to MySQL server on \'XXX\' (13)
- Mysql 报错:ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.xxx.xxx' (111)
- Can't connect to MySQL server on
- php程序mysql Can't connect to MySQL server on 'XXX' (13)错误解决办法
- 远程连接CentOS的MySQL报错:Can't connect to MySQL server on 'XXX' (13)
- Can't connect to MySQL server on '' (10060)
- Can't connect to MySQL server on IP(10060)
- 申请Root权限
- c++函数学习-关于c++函数的林林总总
- Android笔记之系统软键盘布局
- 悬浮div设置回到顶部按钮
- css中实现垂直居中
- MySQL: 2003 can't connect to mysql service on 'xxx' (10060)
- 理解HTTPS为什么安全前,先看看这些东西
- 1082. Read Number in Chinese (25)
- SpringMVC单图片上传
- 【vue2.0】解决使用vue-cli生成项目后项目地址自动添加#号的问题
- tcpdump
- RMAN-06214: Datafile Copy .
- 这里讲一下编码,涵盖内容包括:gbk、utf8编码,汉字,数据库,为什么会出现乱码
- 04.JUC 锁- AQS