# 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

```
USE mysql;

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