Unable To Read Tables From Mysql, With Remote Connection "%"

[johnny_martins00]

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?

 

Thanks

Regards

JM

[johnny_martins00]

Can anyone help me on this?

 

thanks

[yashrs]

Try giving permissions again to the user you made. Remote SQL is working fine for me.

[johnny_martins00]

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?

 

Thanks

Regards

[wolstech]

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.

[azmender22]

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.