[Solved] Remote Db Connection Was Ok But ...

[hello69]

Hi,

I create a db, table , user db and pwd db.

In remote dp I add my IP.

I would to connect in remote way by SQL ODBC DRIVE 5.1

The connection was OK succesfully but the drive shows "information_schema"

(view image I attached).

How I can select my db?

Thank you in advance.

Giuseppe

 

[Luigi123]

Moved to Customer Service.

[Krydos]

Did you grant access for the mysql user to the database?

[hello69]

Did you grant access for the mysql user to the database?

can you tell me where this is possible to do?

[hello69]

Did you grant access for the mysql user to the database?

Solved. Thanks.

[Krydos]

For anyone who searches and finds this on the mysql database page down near the bottom you can add mysql users to mysql databases, and on the next screen you select the permissions ie: select, update, delete, etc.