Setting up Interfacing Tool on a client Ubuntu Machine

On the Client Ubuntu Machine :

sudo apt-get update && sudo apt-get upgrade -y;

sudo apt-get install mysql-client;

---

**On the Server Ubuntu Machine : **

sudo gedit /etc/mysql/mysql.conf.d/mysqld.cnf

In this file change the bind-address and mysqlx-bind-address to 0.0.0.0

bind-address		= 0.0.0.0
mysqlx-bind-address	 = 0.0.0.0

and allow 3306 port via firefall and restart mysql

sudo ufw allow 3306/tcp
sudo service mysql restart

Open phpMyAdmin on the server machine and run these SQL Queries

CREATE USER 'interfaceadmin'@'%' IDENTIFIED BY 'interface@12345';

ALTER USER 'interfaceadmin'@'%' IDENTIFIED WITH mysql_native_password BY 'interface@12345';

GRANT ALL PRIVILEGES ON interfacing.* TO 'interfaceadmin'@'%';

FLUSH PRIVILEGES;

---

Now you can use this new user in the interface tool