Create CF DSN to mySQL database

[jmcg]

I have a mySQL database working fine on my server but was looking to connect on my local CF to test.
I have tried to create a dsn using the database name and a user but get an error:

Connection verification failed for data source: osTickets
java.sql.SQLException: Access denied for user 'V100OST'@'host86-xxx-xxx-xxx.range86-164.btcentralplus.com' (using password: YES)
The root cause was that: java.sql.SQLException: Access denied for user
'V100OST'@'host86-xxx-xxx-xxx.range86-164.btcentralplus.com' (using password: YES)

It all works fine on the live server but I cannot create locally.
Any help much appreciated.