Notes on how to connect from an external machine to a docker database in Google Compute Engine
A) Create a firewall rule in your VPC Network
that allows you to connect to your database from outside the network: https://console.cloud.google.com/networking/firewalls/list
B) From your remote machine repair your database using mysqlcheck
.
On Fedora you can install it by installing the MariaDB
package as follows:
sudo dnf install mariadb -y;
The following command will automatically repair all databases and tables in that instance of MySQL
, where of course the user has access:
mysqlcheck --host 45.37.15.225 --port 33061 --user admin --all-databases --auto-repair --password;
C) Edit the new firewall rule and either disable it or delete it for security.