Help the stupid - connection problems

[kalbrau]

Hi guys, I'm a complete beginner to MySQL so if someone could help me out I'd be eternally grateful!

I have just signed up to hosting with MySQL. I set up a database in my website's control panel and set myself up with a username and password.

I then downloaded MySQL CC and the MySQL ODBC 3.51 Driver. I attempted to configure the DSN to the settings I took from my website's control panel but when I test the connection I get a message saying 'Access denied for user 'hereford_andy@ACBA0AB9.ipt.aol.com' (Using Password: YES)'

The config info I am using is as follows:

Host/Server Name or IP: 195.149.39.7
Database Name: hereford_nightlife
User: hereford_andy

...plus my password of course.

Where am I going wrong?

 

[sleipnir214]

MySQL's user credentials are not a 2-tuple of username and password. They are a 3-tuple of username, password and IP address of connecting client machine.

When you set up your user, did you give that user access from your machine's IP address?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[Chacalinc]

can you telnet to the host where MySQL server is running?
They must to allow you (access config in Mysql) to get in the database server.