Search the Community

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