I programmed a windows form app that accesses phpmyadmin (xampp).
It runs wonderfully on the computer where I programmed it, only when I install the app on the laptop does this error message appear:
"Unable to connect to any of the specified MySql host"
I have set xampp so that I can also access phpmyadmin from the laptop through the browser (IP address released in httpd-xampp).
I created a new user account in phpmyadmin. (Username = my last name, hostname =%, password = my password)
Something to do with the httpd-vhosts file?
Does somebody has any idea?
If you want to access a MySQL database from outside you have to
make port 3306 in the firewall of the system on which the database is running accessible for external access
release port 3306 in MySQL for external access
have a MySQL user who is authorized for external access (sounds like you already have that)
Therefore test e.g. By telnet times whether you can reach port 3306 from outside. If not, check out the firewall and MySQL setting.
Thanks for the answer.
I have now found out with "netstat -ano" that my laptop does not receive the code 3306 (80 for Apache too).
I switched off my firewall. But it still doesn't work.
I had already created a user.
I have access to phpmyadmin from my laptop.
I only want to use the program locally.
How do I get it to release port 3306 in MySQL for external access?
Does anyone know what I'm doing wrong?
I have already given you the possible ideas above. It's not about "codes" but ports, i.e. Doors that have to be opened for this to work. Without knowing your current configuration, you can't be helped here.
