I can't connect to MySQL from the WEB page

Support
1

Hello.
I installed AlmaLinux 9. all good.
I installed LAMP as a WEB server stack with MySQL using this guide

and

Also, all good, until…
I whant to connect from a web page to a MySQL database as user with all rights on database.
That didn’t work anymore!
I can connect by localhost, but NOT by the static IP set for the server.
I opened the port and the service on TCP in Firewal-cmd, I put bind-address for the server that IP, I even set all the rights for ‘user’ @ ‘%’ although I would have wanted only for a certain IP, but still no go.
I am stuck!
Has anyone had this problem before?
Or can someone help with a new idea?
PS. I run AlmaLinux in a VirtualBox vm under a Windows server. (if it matters)

2

mysql only listens on localhost by default. You have to enable all interfaces to allow remote connections.

3

I don’t remember the details of my MySQL days, but you need to make the server respond to localhost or 127.0.0.1 or the LAN IP of your box. I’m assuming it’s the same machine. Read up on those files.

4

Hi. Thanks for the reference. Very explicit.
Unfortunately, I did all these steps and I get the same result.
Look result of the connection:

Connect to DB as dbuser from localhost (<- good from local)
Connect Successfully. Host info: Localhost via UNIX socket

Connect to DB as dbuser from xxx.xxx.xxx.16 (<- this is the static MySQL server IP)
ERROR: Could not connect. Permission denied

The last is when i try to connect with external server IP, which I need when I connect remotely.
So, still unresolved.

5

Make sure the user is defined. In your example, dbuser@xxx.xxx.xxx.16 or dbuser@% needs to be defined.

Login to localhost and run the "select user,host from mysql.user; " command.

image

6

users
look ok to me.

7

Last thing I would check is the firewall settings and the log in /var/log/. Make sure port 3306 is allowed if your firewall is enabled.

I’m running mariadb, so my logs are in /var/log/mariadb. mysql may have logs in /var/log/mysql.

image

8

First:
ports-services
3306 allowed
Second:
In mysql log I find this after a coonect try:
2022-07-02T11:44:09.780416Z 39 [Warning] [MY-010055] [Server] IP address ‘172.22.224.2’ could not be resolved: Name or service not known
No ideea whay!!! the IP is allowed in firewall as source “sources: 194.105.7.16 172.22.224.2 95.76.0.137”, user exist on host.
:frowning:
Stuck and stuck.
Everything seems ok but it doesn’t connect.

9

“Resolved” sounds like mysql attempts to find a (DNS) name for the IP address.

10

mysql is doing a reverse lookup for 172.22.224.2. Add an entry to the /etc/hosts file.

172.22.224.2 RemoteHostname

11

It’s something very strange. I followed all the steps, the checks give correct results, except for connecting to databases on the LAN.
I think I will try another version of linux.
Anyway, thanks for your help.
Good luck! (To me, It seems necessary when I do some administrator work :slight_smile: )