Creating remote user for MySQL

I am using Cpanel and PHPMyAdmin. Currently, I can connect to my MySQL db when using a PHP page placed on my host.

However, I am using a Microsoft Access database on my desktop PC and would like to connect to the MySQL db at my host using ODBC. So, I installed an ODBC driver on my Win XP desktop and entered my usual Server, User and Password.

I click the Test button and I get the following popup:

[MySQL][ODBC 3.51 Driver]Access denied for user:'username@dsl-IPaddress'(Using password:YES)

Why do I get this error? Do I need to create a remote user privaledge or something on Cpanel? If so, how?

I've spent hours on this!

Thanks,

Jon

 

 

 

 

Top