Friday, February 15, 2013

JDBC Driver Connection Problem - ArchLinux

Hi people,

today I found a error on my squirrel-sql software when I was trying to access to my localhost database using com.jdbc.mysql.Driver.

The problem came up using the following message:

"...com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure ...."""

After a really long research, doing on other many similar software, re-setting each configuration files on my computer (ArchLinux), at the end I've figured out how that error came and how we could solve it.

To check whether your problem has the same reasons that mine was, execute the following line, when mysqld service is still running:

Input: $ sudo nmap -p 3306 localhost
output:
PORT     STATE SERVICE
3306/tcp close  mysql

If this is your case, that has a easy resolution, just you should comment the following line on your my.cnf file:

.....
# skip-networking
.....

And the the output for last command will be:


PORT     STATE SERVICE3306/tcp open  mysql


PROBLEM SOLVED !!!