6 solved
source | link

solution: just like @oxfn suggested i put host as % and I also put bind address to 0.0.0.0. This allowed me to connect to the server. What I believe the problem was is that the previous version of mysql verified my by IP and this version verified me by any given URL which you can see below the IP on this page https://myip.is/ . In my case, my ISP gave my router for some reason a URL.

Thank you guys for your suggestions I would not have done it otherwise!

solution: just like @oxfn suggested i put host as % and I also put bind address to 0.0.0.0. This allowed me to connect to the server. What I believe the problem was is that the previous version of mysql verified my by IP and this version verified me by any given URL which you can see below the IP on this page https://myip.is/ . In my case, my ISP gave my router for some reason a URL.

Thank you guys for your suggestions I would not have done it otherwise!

5 edited tags; there's no SQL Server here
source | link

Connect External SQL server MySQLto MariaDB server fails although port seems to be open

Hello I am trying to connect to an external SQLMariaDB server. The configurations files on this installations are in a different place but I managed to find my way around. The installation im using is:

Connect External SQL server MySQL MariaDB

Hello I am trying to connect to an external SQL server. The configurations files on this installations are in a different place but I managed to find my way around. The installation im using is:

Connect to MariaDB server fails although port seems to be open

Hello I am trying to connect to an external MariaDB server. The configurations files on this installations are in a different place but I managed to find my way around. The installation im using is:

4 UFW status
source | link

It shouldnt by UFW filtering my ports:

$ sudo ufw status
Status: active

To                         Action      From
--                         ------      ----
3306/tcp                   ALLOW       Anywhere                  
3306                       ALLOW       my-ip            
3306/tcp (v6)              ALLOW       Anywhere (v6)   

It shouldnt by UFW filtering my ports:

$ sudo ufw status
Status: active

To                         Action      From
--                         ------      ----
3306/tcp                   ALLOW       Anywhere                  
3306                       ALLOW       my-ip            
3306/tcp (v6)              ALLOW       Anywhere (v6)   
3 tcpdump
source | link
2 added external nmap scan
source | link
1
source | link