I'm hooking up a web-based MySQL database.
I've downloaded MySQL ODBC Connector 5.1. Now am attempting to setup the DSN. But am obtaining the error:
Connection Failed : [HY000] [MySQL] [ODBC 5.1 Driver]Access Denied for user 'user123'@'myweb.com'
I've located this website with a few host company. Will i take some particulars in the provider????
I'm carrying this out > User Interface--->Administrative Tools--->Data Sources (ODBC)--->Then i selected MySQL ODBC Driver 5.1-----> i quickly go into the following within the DIALOG which jumps-up:
TCP/IP Server - www.myweb.com Port =3306
userid=user123 and password , I enter individuals userid=user123 &lifier password that we enter after i open www.myweb.com/cpanel.
Cpanel automatically doesn't allow remote connections. Go to database area inside your cPanel and add there your public Ip to ensure that it may accept connection demands out of your Ip.