Advertisements
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.