sqrt(-1) Posted June 21, 2016 Share Posted June 21, 2016 Hi,I'm developing a Windows application that should exhange data with a remote mySQL database (hosted by heliohost).Hereafter, my operations are reported:- I've created a new mySQL database from the cPanel: DBxyz- I've created a new mySQL account for the created database: USERxyz- I've enabled remote connections from any IP address (I've used the wildcard %)- I've configure the mySQL ODBC driver on my PC (I've used he MYSQL COnnector/ODBC Data source) I've found issues on this last point. Connection with the server is established successfully but the only available database is information_schema. The datbaase DBxyz I've created is not present (see attachment). Can anyone help me? Quote Link to comment Share on other sites More sharing options...
wolstech Posted June 21, 2016 Share Posted June 21, 2016 Did you assign that user to the database you created? Also, try using your cpanel account as the database user to see if it works. Quote Link to comment Share on other sites More sharing options...
sqrt(-1) Posted June 21, 2016 Author Share Posted June 21, 2016 Did you assign that user to the database you created? Also, try using your cpanel account as the database user to see if it works. I've just tried to access using the cPanel account and it works. Sorry, I was created the user without assigning it to the database. The procedure wasn't clear for me. Now it works fine even with the created user. Thanks Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.