Mysql Setup on a dedicated CentOS

Hey so I have setup a database called MineCraft, I have also created a user called Guvnors with a password. But when trying to connect it wont seem to work.
I have bought a dedicated server with CentOS installed and using putty to access it.


Database: Type: 'MySql' # H2 or MySQL Settings: Name: 'MineCraft' Table: 'iConomy' MySQL: Username: 'Guvnors' Password: 'mypass' Hostname: 'localhost' Port: 3306

Why dont this work?

I would appreciate your help as once I have mysql sorted, my server will be complete. Many thanks.

 

Why do you think it doesn't work? is there a log message?

 

Code:

17:39:01 [INFO] [iConomy] Could not create connection: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
17:39:01 [INFO] [iConomy] Database initialization failed: java.lang.NullPointerException
17:39:01 [INFO] [iConomy] Plugin disabled.

 

Try this:

Database: Type: 'MySQL'

 

Same error.

Looks like this

Code:

    Database:
        Type: 'MySQL'                                 # H2 or MySQL
        Settings:
          Name: 'MineCraft'
          Table: 'iConomy'
          MySQL:
              Username: 'Guvnors'
              Password: 'pass'
              Hostname: 'localhost'
              Port: 3306

 

I am getting this error as well....running under MacOS 10.5.8