Problem: on the Ubuntu system, the MySQL account was added, giving the database full access and allowing the database to be linked from the outside However, the MySQL database cannot be accessed remotely.

Reason: on the Ubuntu system, the default installation of MySQL limits native access to the database

Solution: remove the native binding restriction on the MySQL database

nano etc/mysql/my cnf # edit the configuration file Find bind-address = 127.0.0.1

Instead of

#bind-address = 127.0.0.1 ctrl+o # save the configuration ctrl + x # exit / etc/init d/mysql restart # restart the database

You are now ready to connect to the MySQL database remotely