Mariadb Server allow connection from workbench.

Install MySQL server

apt-get install mariadb-server

Setup SSH server

nano /etc/ssh/sshd_config

Add to file

AllowTcpForwarding yes

/etc/init.d/ssh restart

Setup SQL Server Config

nano /etc/mysql/mariadb.conf.d/50-server.cnf

Set the following.

bind-address            = 0.0.0.0

Setup new admin user with full server permissions

mysql -u root -p

CREATE USER 'finley'@'ipOFpcRUNNINGworkbench' IDENTIFIED BY 'some_pass';

GRANT ALL PRIVILEGES ON *.* TO 'finley'@'ipOFpcRUNNINGworkbench'
->     WITH GRANT OPTION;

FLUSH PRIVILEGES;

mysql_secure_installation

Was this helpful?

YesNo

0 / 0