How to set up the remote connection of mariadb?

I added the mainframe in LINODE, and set up ubuntu 18.04 ephemeral apache.p7.3 phpmyadmin

but I can"t remotely connect to the mariadb of this host on the local 127.0.0.1?

my phpmyadmin can connect to the database normally

phpmyadmin

127.0.0.1
:

Php ubuntu mariadb mysql mysqli

May.11,2022

the problem with understanding the landlord is that the remote database cannot be connected locally. I don't know if there is an error.
in view of this problem, the description of the landlord may have misunderstood the IP of 127.0.0.1. This IP is the local access local IP address, that is, only your computer will recognize this IP.

when accessing a remote MySQL server, the request IP received by the server should be your gateway egress IP (you can query Baidu ip directly, and the ip that appears is the egress ip).

so there is a situation where you give 127.0.0.1 permission to the ip, but you still can't connect locally.

it is recommended that the landlord can query the local egress IP, and then set permissions for the egress IP.

Previous: In website statistics, you visit an address for a long time, which should not be a normal visit.

Next: WeChat Mini Programs production: different view, sharing an array, resulting in repeated data output traversal, what should I do?

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e81817-46927.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e81817-46927.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?