-
MYSQL5连接拒绝的问题解决案例
发表于 2008年12月14日 没有评论使用apache dbcp连接MYSQL，配置为：
<bean id=”dataSource” class=”org.apache.commons.dbcp.BasicDataSource”
destroy-method=”close”
p:driverClassName=”com.mysql.jdbc.Driver”
p:url=”jdbc:mysql://localhost:3306/testdb”
p:username=”test”
p:password=”helloword”/>
遇到这个么错：
[java] 2008-12-14 17:48:03,253 (Thread-0) [JakartaCommonsLoggingImpl.java:19 :ERROR] Error calling Connection.prepareStatement: [java] org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Unable to connect to any hosts due to exception: java.net.ConnectException: Connection refused
[java]
[java] ** BEGIN NESTED EXCEPTION **
[java]
[java] java.net.ConnectException
[java] MESSAGE: Connection refused
[java]
[java] STACKTRACE:
[java]
[java] java.net.ConnectException: Connection refused
[java] at java.net.PlainSocketImpl.socketConnect(Native Method)
查找到原因为：my.cnf里有一行：
skip-networking
改为
#skip-networking
重启mysqld：
$bindir/mysqld_safe –datadir=$datadir –pid-file=$server_pid_file –default-file=/opt/lamp/etc/my.cnf $other_args >/dev/null 2>&1 &
确认my.cnf的路径。
最近评论