hello69 Posted November 16, 2017 Share Posted November 16, 2017 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.1The 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 Quote Link to comment Share on other sites More sharing options...
Luigi123 Posted November 16, 2017 Share Posted November 16, 2017 Moved to Customer Service. Quote Link to comment Share on other sites More sharing options...
Krydos Posted November 16, 2017 Share Posted November 16, 2017 Did you grant access for the mysql user to the database? Quote Link to comment Share on other sites More sharing options...
hello69 Posted November 16, 2017 Author Share Posted November 16, 2017 Did you grant access for the mysql user to the database? can you tell me where this is possible to do? Quote Link to comment Share on other sites More sharing options...
hello69 Posted November 16, 2017 Author Share Posted November 16, 2017 Did you grant access for the mysql user to the database?Solved. Thanks. Quote Link to comment Share on other sites More sharing options...
Krydos Posted November 16, 2017 Share Posted November 16, 2017 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. 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.