This problem has had me pulling my hair out for a week.
Really stumped.
System details
Quote
Arch linux
mysql Ver 14.14 Distrib 5.5.27, for Linux (i686) using readline 5.1
Netbeans 7.2
I am trying to connect to mysql with an application in netneans.
Quote
Sep 01, 2012 12:45:38 AM sqltest.SqlTest main
SEVERE: null
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
Caused by: java.net.ConnectException: Connection refused
Now I can connect with phpmyadmin, connect to mysql on the terminal. So mysql is installed correctly. I netbeans is installed correctly also. If I try and activate mysql via the services tab I get a connection refused message.
Quote
Netbeans mysql Server properties...
Server Host Name: localhost.
Server port number: 3306
Administrator User Name: root
Administrator Password: xxxxxx
Admin Properties...
Path/url to admin tool: /usr/bin/mysqladmin (no arguments)
Path to start command: /usr/bin/mysqld (no arguments)
Path to stop command : /usr/bin/mysqladmin (arguments: -u root stop)
The java mysql driver is present and included...
#skip-networking commented in /etc/my.cnf
All mysql files seem to have the relevant permissions...mysql:mysql.
maybe someone else has come accross this error and solved it.
Quote
Error states in the Netbeans IDE when I try and start in servces tab in netbeans...
120831 23:15:05 [Warning] Can't create test file /var/lib/mysql/archvm.lower-test
120831 23:15:05 [Warning] Can't create test file /var/lib/mysql/archvm.lower-test
/usr/bin/mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 13)
120831 23:15:05 [ERROR] Aborting
120831 23:15:05 [Note] /usr/bin/mysqld: Shutdown complete
Any ideas before the PC goes out the window.