Problem connecting from MX7 on Ubuntu 10.04 to MySQL5.5

Running CFMX7 on an Ubuntu10.04 box - been good for a few years. However, I'm now having trouble connecting to an external MySQL 5.5 server.

Not sure what bits that CF is actually using. I was using mysql-connector-java-3.1.14-bin.jar and when I try to add the datasource in CFIDE ADministrator, I get:

Connection verification failed for data source: psdb

java.sql.SQLException: Access denied for user 'web120-paysys'@'xx-xx-xx-xx.dsl.in-addr.zen.co.uk' (using password: YES)

The root cause was that: java.sql.SQLException: Access denied for user 'web120-paysys'@'xx-xx-xx-xx.dsl.in-addr.zen.co.uk' (using password: YES)

I tried updating the connector to , but that just changes the error message to this:

Connection verification failed for data source: psdb

  com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.

The root cause was that: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.

Now I don't know if I need to have mysql 5.5 client libraries installed on my base Ubuntu machine or if their capability is built into the connector.