MySQL remote connection problem

[rdonnay]

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?

[skiman]

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.

[c-tec]

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

[Auge_Ohr]

does

Code: Select all

telnet your_host_name tcp_ip_port_number.

work ?

[rdonnay]

Have you tried it with the MySQL Workbench?

Yes, I have the same problem with MySQL Workbench.

[rdonnay]

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.