bb.donnay-software.com

Posted: **Mon Nov 30, 2015 5:32 pm**

I have read everything about making a remote connection to a MySQL database but it just doesn't work.

I wrote a small Xbase++ program that uses the ODBCDBE to connect to the BULLETINBOARD database which runs this forum. It works fine if I run it on the server but not from a computer on the same subnet.

I used the GRANT PRIVILEGES command to give myself privileges but it will not connect from my workstation.

Code: Select all

mysql> grant all privileges on *.* TO 'rdonnay'@'%' identified by '<password>';
mysql> flush privileges;

Also, why can't I connect using my "root" user?

Any ideas?

Posted: **Tue Dec 01, 2015 12:54 am**

Hi Roger,

Have you tried it with the MySQL Workbench? This way you can check if it is working on your server. So you can determine where the problem exist.

Posted: **Tue Dec 01, 2015 2:12 am**

Hello Roger,
did you check port 3306 ? must be open for MySQL
regards
Rudolf

Posted: **Tue Dec 01, 2015 2:42 am**

does

Code: Select all

telnet your_host_name tcp_ip_port_number.

work ?

Posted: **Tue Dec 01, 2015 5:20 am**

Have you tried it with the MySQL Workbench?

Yes, I have the same problem with MySQL Workbench.

Posted: **Tue Dec 01, 2015 5:35 am**

did you check port 3306 ? must be open for MySQL

I thought I had done that. When I went back and checked, it wasn't opened.

Thanks for that. Everything's working good now.

bb.donnay-software.com

MySQL remote connection problem

MySQL remote connection problem

Re: MySQL remote connection problem

Re: MySQL remote connection problem

Re: MySQL remote connection problem

Re: MySQL remote connection problem

Re: MySQL remote connection problem