Grant remote access of MySQL database If you try to connect to a remote MySQL database from your client system, you will get “ERROR 1130: Host is not allowed to connect to this MySQL server” message as shown below. $ mysql -h 192.168.1.8 -u root -p Enter password: ERROR 1130: Host ‘192.168.1.4’ is not allowed […]
See MoreTag: MySQL database
How to add remote MySQL database server in Vesta Control Panel
Add remote MySQL database server in Vesta Control Panel 1. It is assumed you already have your second server up and running. 2. On the first server run following command v-add-database-host mysql new-server.com root password 3. To make sure eveyrhing is in order, check database host list v-list-database-hosts
See More