MySQL Forums
Forum List  »  MySQL Workbench

my first MYSQL server
Posted by: Warwick Oldham
Date: April 02, 2018 12:51AM

Hi, I'm giving MYSQL Community Server a go for the first time and plan to migrate a MSSQL database across once I've got the basics.

I seem to have a problem with connection but I'm not sure where to troubleshoot...I'f someone can point me in the right direction would be much appreciated.

Server side:
- Have a Debian 9.4 VM
- Have installed MYSQL server 5.7.21 on the VM from repos
- Have installed Workbench 6.3.8
- Can connect to the server locally via workbench
- added a user that I wish to connect with. In the limit to hosts field have added the IP of the client (not sure if this is what I'm meant to do though).

Client side:
- Have a win 10 client
- Have installed Workbench
- Have installed a MYSQL ODBC driver 5.3 ANSI
- Have made a new connection with the Hostname as the server IP and tried the Host name of the sever
- I have not changed the default port of 3306

When I try to connect I get the message 'Cannot Connect to Database Server'. I have read I need let set the allowable clients IP on the server but not entirely sure where I should do this.

What should I start to check?
Do I need to install a ODBC driver on the Debian VM?

Options: ReplyQuote

Written By
my first MYSQL server
April 02, 2018 12:51AM
April 08, 2018 05:11AM
April 09, 2018 01:50AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.