Communication failure during handshake. Is there a server running on localhost:3306?
来源:互联网 发布:黑马程序员深圳校区 编辑:程序博客网 时间:2024/05/28 19:25
今天重新部署我的工作环境,是一个Apache+PHP+Tomcat+Mysql的集成环境。
我有个追新的毛病,看到Mysql的新的stable版本释放出来我就下了一个,安装上了。其它的几个服务都调试通过了,但是Tomcat和 Mysql却连结不上,提示错误Communication failure during handshake. Is there a server running on localhost:3306?,当时以为是mm.mysql的驱动的问题,去网上察看了一下,这个2.0.4的驱动居然是2001年的,新的版本叫做作Connector/J 3.x了,。以为是这个驱动的问题,但询问了朋友,说他们那个工作正常。
Google一下吧。
先是国内有个地方说是因为root将默认的空密码设置了密码造成这个问题,我重新建立了一个用户,但是还是抱这个错误。
继续,结果在Mysql.com的官方网站上看到这个解释,是因为新的Mysql的认证机制发生了一些变化造成的,解决方法如下:
I'd to change the authentication method at the mysql server:
set password for <username>@<servername> = old_password('<password>');
将红色那部分敲进去就解决了,呵呵,特此记录一下。
- Communication failure during handshake. Is there a server running on localhost:3306?
- java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306?
- Communication failure during handshake. Is there a server running on localhost:3306
- java web连接mysql异常Communication failure during handshake. Is there a server running on localhost
- java.sql.SQLException: Communication failure during handshake. Is there a server running on localhos
- Communication failure during handshake.JDBC连接MySql数据库问题
- FRM-92101: There was a failure in the Forms Server during startup.
- Server already running on localhost
- Is the server running on host “localhost” (::1) and accepting TCP/IP connections on port 5432?
- Jboss提示:Server already running on localhost
- A server is already running.
- Jboss Server Error:Server already running on localhost
- postgresql数据库无法连接,提示 Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP conn
- Error running Tomcat8: Address localhost:1099 is a
- Error running Tomcat8: Address localhost:1099 is a
- There is a chart instance already initialized on the dom
- MySQL 连接问题java.sql.SQLException: Communication failure during handshak.
- there is a reason
- (转贴)在Asp.net中为图像加入版权信息
- DirectShow流媒体信息获取及图象转换
- 关于软件文档 这些你知道吗?
- HTML Help Workshop制作帮助文件,图片显示不了的解决方法
- GNU Compile Tools, 可执行文件, 静态链接库, 动态链接库
- Communication failure during handshake. Is there a server running on localhost:3306?
- 用Visual C#做DLL文件
- Picture Control装载图像
- Windows系统命令
- 缓存技术详谈
- 用POST方式获取Radio Button是否被选中的信息
- 敏捷设计的五个原则
- 彻底明白Java的IO系统
- [howto] General 5.10 - HowTo: Speed up ubuntu boot process - the way you can feel it. - updated