Can't get computer on local network to connect to MySQL server
lazarus / 38-Networking and Web Programming

----------------------------------------------------------------------
oldcoder · 2016-10-02 15:05

Environment
Lazarus 1.4.2 i386-win32-win32/win64
FPC Version 2.6.4
SVN Revision 49524
Server running under Win 7 Home Premium 64 bit
using TMySQL55Connection
MySQL running under XAMPP Control Panel v3.2.1

Can anyone help with this please?

I've got my application running well on localhost using XAMPP, on the
above hardware, so next I wanted to access the MySQL database from a
PC on my Windows Workgroup.

The other PC is running the same version of Lazarus under Windows 10
Pro 64 bit.

Both computers can be seen and accessed over the Workgroup network in
Windows Network
The Win 7 computer (server) is connected to the router via Ethernet
cable.
The Win 10 computer is connected wirelessly.

I have no experience of networks so everything I have tried has been
trial and error based on what I have read in internet posts on the
subject.

Here's what I have tried so far:

Host Computer IP = 192.168.1.67

Created a user in PHPMyAdmin with GRANT PRIVILEGES with Host set to
192.168.1.*
followed by FLUSH PRIVILEGES

Edited the following files as shown:


APACHE
httpd.conf
===================================
Was previously set to

#Listen 12.34.56.78:80
Listen 80


I changed it to

#Listen 192.168.1.67:80
Listen 80

================================
A post suggested the # in front of the first Listen statement was
important. I tried with and without. Server connect failed either way.



httpd-xampp.conf
==================================
was previously set to

#
# New XAMPP security concept
#
<LocationMatch
"^/(?i:(?:xampp|security|licenses|phpmyadmin|webalizer|server-
status|server-info))">
   Order deny,allow
   Deny from all
   Allow from ::1 127.0.0.0/8 \
      fc00::/7 10.0.0.0/8 172.16.0.0/12 192.168.0.0/16 \
      fe80::/10 169.254.0.0/16


   ErrorDocument 403 /error/XAMPP_FORBIDDEN.html.var
</LocationMatch>


I changed it to

#
# New XAMPP security concept
#
<LocationMatch
"^/(?i:(?:xampp|security|licenses|phpmyadmin|webalizer|server-
status|server-info))">
   Order deny,allow
#   Deny from all
    Allow from localhost
    Allow from 192.168.1.*
   Allow from ::1 127.0.0.0/8 \
      fc00::/7 10.0.0.0/8 172.16.0.0/12 192.168.0.0/16 \
      fe80::/10 169.254.0.0/16


   ErrorDocument 403 /error/XAMPP_FORBIDDEN.html.var
</LocationMatch>

======================================
I tried 'Deny from all' with and without the #, and various different
Allow lines. Server connect failed in all cases.



MYSQL
my.ini
=========================================
was set to

# Change here for bind listening
  bind-address="127.0.0.1"
# bind-address = ::1          # for ipv6


I changed it to

# Change here for bind listening
  bind-address="127.0.0.1"
  bind-address="192.168.1.67"
# bind-address = ::1          # for ipv6


Then, reading another post, I tried commenting out ALL bind-address
settings

# Change here for bind listening
# bind-address="127.0.0.1"
# bind-address = ::1          # for ipv6

Reading another post I also tried adding
bind-address=0.0.0.0
=========================================

I have also tried disabling Windows firewall on both computers for
private network locations.

Nothing I have tried has worked. I have tried all the variations of
the above I can think of and nothing lets me connect the Win 10
computer to the MySQL server on the Win 7 computer.

I realise a lot of this is about server settings and not specific to
Lazarus, but if anyone has got a Lazarus program with MySQL server and
clients communicating I would really appreciate any tips you can give
me.

Thank you.

----------------------------------------------------------------------
Pascal · 2016-10-12 19:17

What errors did you get?

Have you tried the commandline tool (mysql.exe) to connect to the
server?