New setup of Ubuntu 20.04 and MariaDB. MariaDB works fine locally, but I cannot access it remotely. I've searched online and think I've done what's suggested so there may be a step I've missed.
Here's what I've done thus far:
GRANT ALL ON 'admin'@'%' IDENTIFIED BY 'THEPASSWORD'; FLUSH PRIVILEGES;
I then changed the bind address to:
bind-address = 0.0.0.0
in file /etc/mysql/mariadb.conf.d/50-server.cnf
(Note that the file /etc/mysql/my.cnf doesn't have any bind-address information in it.)
In AWS firewall, I added port 3306 to the incoming ports for all locations.
The error I get trying to connect remotely is is:
2002 - Can't connect to server on '(Ip address here)' (36)
I've tried using both the IP of the server and the DNS name. Both approaches give same error.
What could I be missing?