当前位置:  数据库>mysql

Can't connect to MySQL server的解决办法

    来源: 互联网  发布时间:2014-09-06

    本文导语:  1.查看配置文件: skip-networking #注释掉 因为它是屏蔽掉一切TCP/IP连接 bind-address = 127.0.0.1 #它和上一个选项是异曲同工,要想远程连接,也得注释掉 2.如果以上工作都做过还是出现: ERROR 2003 (HY000): Can't connect to MySQL server on '*.*.*.*'...

1.查看配置文件:

skip-networking #注释掉 因为它是屏蔽掉一切TCP/IP连接

bind-address = 127.0.0.1 #它和上一个选项是异曲同工,要想远程连接,也得注释掉

2.如果以上工作都做过还是出现:


ERROR 2003 (HY000): Can't connect to MySQL server on '*.*.*.*' (113),那就得考虑防火墙的问题了,关掉防火墙/etc/rc.d/init.d/iptables stop



修改完后需要 restart mysql (/etc/init.d/mysql restart)

    
 
 

您可能感兴趣的文章:

  • TCP/IP 连接诊断工具 Why Can't I Connect?
  • 运行 deploytool 时出现: error: can't not connect to server localhost
  • FTP传输425 Can't open passive connection: Permission denied.的错误
  • ubuntu 10 安装mysql ,ERROR 2002 (HY000): Can't connect to local MySQL server throu
  • 请教EJB抱错:Can't start a cloned connection while in manual transaction mode.是怎么意思??谢谢
  • Can't connect to window server - not enough permissions
  • 急!在线等待~~在FTP的时候怎么会出现这个问题? Can't build data connection: Address already in use.
  • FreeBSD下开发,碰到问题:connect(): Can't assign requested address
  • ftp get命令 批处理 425 Can't build data connection: Invalid argument
  • 编程语言 iis7站长之家
  • 马上给100分!谁能解决这个简单的问题:Can't start manual transaction mode because there are cloned connections.先给20分
  • Can't connect to MySQL server on 'localhost' (10048)问题解决方法
  • php运行提示Can't connect to MySQL server on 'localhost'的解决方法
  • SELinux导致PHP连接MySQL异常Can't connect to MySQL server的解决方法
  • 求助:linux mysql多实例,2002 (HY000): Can't connect to local MySQL server
  • Can't connect to MySQL server on localhost (10061)解决方法
  •  
    本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术,将尽最大努力为读者提供更好的信息聚合和浏览方式。
    本站(WWW.)站内文章除注明原创外,均为转载、整理或搜集自网络。欢迎任何形式的转载,转载请注明出处。












  • 相关文章推荐
  • reboot: can't open '/proc' too many openfiles,怎么解决?
  • 如何解决can't identify protocol的问题
  • 解决mysql ERROR 1017:Can't find file: '/xxx.frm' 错误
  • 解决MYSQL出现Can't create/write to file '#sql_5c0_0.MYD'的问题
  • 怎么解决“Can't put the boot sector on logical partition 0x308”的错误。
  • 如何解决mysqlimport: Error: 13, Can't get stat of 的问题
  • 我在JBUILDER3下做了个Applet,但在HTML下运行老出现ERROR(LOAD:UNTITLED2.APPLET2 CAN'T BE INSTANTIATED),无法运行那位仁兄知道原因并告知解决方法本人不胜感激
  • why can't i input chinese ? where? and how to do?
  • can't open display:
  • why my package can't find?
  • i can't use my chinput!!!help me!
  • Can't find library: "CbsSysClassD"
  • 无法xeyes -display:can't open display
  • 上不了网“firefox can't find the server at”(求救)
  • solaris下想用sar命令,一直提示can't open /var/adm/sa/sa26
  • 一个简单的shell,执行时总是提示"can't execute binary file"
  • 复制一个目录,出现错误can't create symbolic link
  • 我装了个fvwm,运行时确说:[FVWM][main]: <<ERROR>> can't open display
  • scp commond can't use
  • can't find most modules after compiled kernel-2.6.0
  • Can't load IA 32-bit .so on a IA 32-bit platform
  • 求助:在Linux上,当退出vi,遇到“Can't write viminfo file /root/.viminfo!”
  • What should I do to close a Applet? Use this.destroy() can't do that??????.
  • 我是初学者:请问用Javac可以编译,但用Java执行时会说can't find the class.这是怎么回事呢?谢谢。
  • I can't input chinese ...............waiting in line ...
  • applet在jbuilder环境下没问题,用ie调用出applet can't be instantiated,什么原因呢?
  • resin 装上后 想运行asp 总出现Can't contact Servlet Runner at localhost:6802 错误 (我的机子上还装有oracle)


  • 站内导航:


    特别声明:169IT网站部分信息来自互联网,如果侵犯您的权利,请及时告知,本站将立即删除!

    ©2012-2021,,E-mail:www_#163.com(请将#改为@)

    浙ICP备11055608号-3