Hello, my station PC is running Ubuntu 20.04, have all my digitalmodes and radios installed/connected to it, my home server is a Centos 7.9 running
mysqld Ver 5.7.32 for Linux on x86_64 (MySQL Community Server (GPL))
I would like to use my home server (Centos) and the database (which I use for other home made applications) from anywhere I can have internet connectivity whether it is locally in my radioshack or somewhere in Timbuktu via VPN.
After I installed CQRLOG on my Ubuntu PC and entering the server IP, port(3306), username(I assume the remote db admin username), password and hit the "Connect" button I get:
Error during connection to database: TMySQL57Connection : Server connect failed.
I did a tcpdump for port 3306 on the Centos server network interface and I can see traffic to and from my PC for that port, also the mysqld.log has:
2021-01-24T03:16:01.067266Z 2 [Note] Access denied for user 'root'@'localhost' (using password: YES)
I checked several times that the password is the correct one, so what am I missing?
Thanks in advance