johnny_martins00 Posted June 2, 2014 Share Posted June 2, 2014 Hi, I'm having a issue connecting remotely to MySql and nay help will be appreciated. I've created my DB, and enabled remote connections with %, but every time that i try to connect to my DB remotely, using a Java custom program, it gives me an error, that i haven't enough privileges to read the tables. The steps that I've made, after creating the domain were: 1 - Create a DB, for example TEST_A;2 - Created a table, ZZZZ, on TEST_A DB;3 - Created 1 user, XPTO with all privileges, and added to the created DB;4 - Enabled all the remote connections, just for a test, with the %; Running my custom program gives me the error that "SELECT command denied to user 'XPTO'@'XX.XXX.XX.XXXX' for table 'ZZZZ..." I'm certain that im using the correct Pwd, but can't fix this issue... Another doubt that i have is that connecting to PHPMyAdmin i see my created DB, TEST_A, but on my information_schema i don't see the created user XPTO, Can anyone help me on this subject? ThanksRegardsJM Quote Link to comment Share on other sites More sharing options...
johnny_martins00 Posted June 7, 2014 Author Share Posted June 7, 2014 Can anyone help me on this? thanks Quote Link to comment Share on other sites More sharing options...
yashrs Posted June 7, 2014 Share Posted June 7, 2014 Try giving permissions again to the user you made. Remote SQL is working fine for me. Quote Link to comment Share on other sites More sharing options...
johnny_martins00 Posted June 9, 2014 Author Share Posted June 9, 2014 Yashrs tanks for the tip , but unfortunately it didn't work.. I still don't see my created user on the information schema .. What is strange i that i can actually use the GetCatalogs methods, thru remote, and it work fine, but ir the same user if i try to select from an custom table it gives me the Command denied to the user error.. Any clues? ThanksRegards Quote Link to comment Share on other sites More sharing options...
wolstech Posted June 9, 2014 Share Posted June 9, 2014 Does it work if you use your cpanel username and password instead? I've had issues with users I create not working remotely. Also, the name of a user you create will take the form cpusername_sqlusername. Quote Link to comment Share on other sites More sharing options...
azmender22 Posted June 13, 2014 Share Posted June 13, 2014 My favorite troubleshooting tool for MySQL : http://dev.mysql.com/downloads/workbench/ may help you see the problem. I sometimes forget too,when i define a table that a prefix may be added to the name, depending on how you created the DB. Anyway this is what I use to isolate problems with server vs problems with query code. 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.