MySQL remote connection problem

This forum is for general support of Xbase++
Post Reply
Message
Author
User avatar
rdonnay
Site Admin
Posts: 4722
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

MySQL remote connection problem

#1 Post by 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?
The eXpress train is coming - and it has more cars.

skiman
Posts: 1183
Joined: Thu Jan 28, 2010 1:22 am
Location: Sijsele, Belgium
Contact:

Re: MySQL remote connection problem

#2 Post by 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.
Best regards,

Chris.
www.aboservice.be

c-tec
Posts: 379
Joined: Tue Apr 20, 2010 1:36 am
Location: SALZBURG/AUSTRIA
Contact:

Re: MySQL remote connection problem

#3 Post by c-tec »

Hello Roger,
did you check port 3306 ? must be open for MySQL
regards
Rudolf
Rudolf Reinthaler
digital pen & paper systems
http://www.formcommander.net

User avatar
Auge_Ohr
Posts: 1405
Joined: Wed Feb 24, 2010 3:44 pm

Re: MySQL remote connection problem

#4 Post by Auge_Ohr »

does

Code: Select all

telnet your_host_name tcp_ip_port_number.
work ?
greetings by OHR
Jimmy

User avatar
rdonnay
Site Admin
Posts: 4722
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: MySQL remote connection problem

#5 Post by rdonnay »

Have you tried it with the MySQL Workbench?
Yes, I have the same problem with MySQL Workbench.
The eXpress train is coming - and it has more cars.

User avatar
rdonnay
Site Admin
Posts: 4722
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: MySQL remote connection problem

#6 Post by 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. :oops:

Thanks for that. Everything's working good now.
The eXpress train is coming - and it has more cars.

Post Reply