MySQL connection problem

Xbase++ 2.0 Build 554 or later
Message
Author
User avatar
rdonnay
Site Admin
Posts: 4722
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

MySQL connection problem

#1 Post by rdonnay »

This forum has been using MySQL with PhpBB3 for 9 years on my server.

I am now wanting to make an ODBC connection to MySQL from a Windows 10 workstation and cannot get it to open the connection.

I have opened port 3306 on both the server and workstation firewalls.
I also verified that port 3306 is listening on the server.
I tried turning off both firewalls.

I tried to TELNET to port 3306 on the server.
Nothing is allowing me to make that connection.

Does anyone have experience doing this?
Can you help me with this?
The eXpress train is coming - and it has more cars.

patito
Posts: 121
Joined: Tue Aug 31, 2010 9:01 pm

Re: MySQL connection problem

#2 Post by patito »

Hi Roger

In the directory of exp19/samples/xbasemysql
run infomysql (compile with infomysql.pjx )
enter name server, user name and password
and then click on connect server button (there are two computers)

and see if it is possible to access your server
My project is not a wonder but it works

I hope it solves your connection, in this directory are all the
library, does not use obdc , is with a native mysql.dll

Best regard
Héctor

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

Re: MySQL connection problem

#3 Post by rdonnay »

Hector -

Interestingly, I get the same error number (10060) as I do from the ODBC connection.

After some more googling, I'm finding that this is pointing me in the right direction:

https://forums.mysql.com/read.php?34,49742,239961

They refer me to cpanel and I don't even know what that is.

I was hoping that it would be a simple entry in My.ini to allow remote connections.

I have followed every instruction I could find on the internet and have made no progress.
The eXpress train is coming - and it has more cars.

patito
Posts: 121
Joined: Tue Aug 31, 2010 9:01 pm

Re: MySQL connection problem

#4 Post by patito »

Hi Roger

"network," but someone or something changed it to "public network." ?????

Try the following

in Windows go to network center and shared resources
locate network in use
then go to properties
then disable Internet Protocol (Tcp/ipv6)
then accept

I wish you success

Héctor Pezoa

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

Re: MySQL connection problem

#5 Post by rdonnay »

disable Internet Protocol (Tcp/ipv6)
That didn't help. I found this on a Google search:

Will disabling ipv6 cause problems?
Typically, IPv6 enabled systems will prefer IPv6 connections over IPv4, so a misconfigured or malfunctioning IPv6 network will cause connectivity problems. ... When you have a network problem that is “solved” by disabling IPv6, you have masked the symptom of a bigger problem that warrants further investigation.
The eXpress train is coming - and it has more cars.

patito
Posts: 121
Joined: Tue Aug 31, 2010 9:01 pm

Re: MySQL connection problem

#6 Post by patito »

Hi Roger

Some ideas, maybe you checked them out.

I guess your mysql server is running on Windows ... therefore open a DOS window and type:
netstat -an
You should find a line like this:
TCP 0.0.0.0:3306 0.0.0.0:0 LISTENING
This tells you that the mysql server is running and listening on TCP port 3306.
Another test you can do is telnet (from another PC) to your mysql server:
telnet ip_mysql_server 3306

1) my.conf
[mysqld] port = 3306 bind-address = 0.0.0.0

2) mysql
GRANT ALL PRIVILEGES ON *.* TO 'user_name'@'%'; FLUSH PRIVILEGES;
3. Use the % wildcard for the host part of the user count to allow the connection from any host

Check the mysql configuration: /etc/my.cnf

mysql> GREAT ALL PRIVILEGES ON *.* TO 'rafa'@'%'
-> IDENTIFIED BY '123456789' WITH GRANT OPTION;
put the sign % that's it. the problem was solved.

Best Regard
Héctor

patito
Posts: 121
Joined: Tue Aug 31, 2010 9:01 pm

Re: MySQL connection problem

#7 Post by patito »

Hi Roger

you can use this tool, to configure MySQL
winmysqladmin, will show your connection, which you can modify.

When you run it, a traffic light will appear at the bottom of your screen , place show me
With this tool I have solved connection errors

best regard
Héctor
Attachments
winadm.rar
winmysqladmin
(1.46 MiB) Downloaded 774 times

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

Re: MySQL connection problem

#8 Post by rdonnay »

netstat -an
I had already done that. Result:
TCP 0.0.0.0:3306 0.0.0.0:0 LISTENING
telnet ip_mysql_server 3306
Result:
Connecting To 192.168.0.60...Could not open connection to the host, on port 3306: Connect failed.
I had already done that too.
1) my.conf
[mysqld] port = 3306 bind-address = 0.0.0.0
There is NO my.conf file.
There is a my.ini file.
I added bind-address=0.0.0.0 and restarted server.
Still no connection with Telnet.
GRANT ALL PRIVILEGES ON *.* TO 'user_name'@'%'; FLUSH PRIVILEGES;
No good.
#1146 - Table 'mysql.servers' doesn't exist
Check the mysql configuration: /etc/my.cnf
There is no my.cnf file on the entire drive

I am guessing that my problems are associated with the fact that I am using WampServer.
It comes with a special services:
wampapache64
wampmysqld64

I GIVE UP!!!
The eXpress train is coming - and it has more cars.

patito
Posts: 121
Joined: Tue Aug 31, 2010 9:01 pm

Re: MySQL connection problem

#9 Post by patito »

Hi Roger

Try the file I attached for the last time.
mysqladmin.....
you can make a copy of the data directory, and make a backup of it
I was able to recover all the databases, that way, and then I did a clean installation.
You can copy that backup to another pc, and prove that you have your data current

luck

best regard
Héctor

patito
Posts: 121
Joined: Tue Aug 31, 2010 9:01 pm

Re: MySQL connection problem

#10 Post by patito »


Post Reply