Raspberry Pi MariaDB LibreOffice Connection

Steps on how to connect mariaDB instance to Libre Office over the network. Using my setup of Raspberry Pi’s, I install and connect a MariaDB (MYSQL) database on one pi, and use a different Pi to connect to it from Libre Office Base.

Links to to referenced documents:
– [How to Install MariaDB on Raspberry Pi? (MySQL Server)](https://raspberrytips.com/install-mariadb-raspberry-pi/)
– [Granting User Connections From Remote Hosts](https://mariadb.com/kb/en/configuring-mariadb-for-remote-client-access/#granting-user-connections-from-remote-hosts)
– [YouTube Vid: LibreOffice Base using MySQL Backend.](https://www.youtube.com/watch?v=U1J8V9cE6QI)

Commands used (in order of appearance)

sudo apt update
sudo apt upgrade
sudo raspi-config

sudo apt install mariadb-server
sudo mysql_secure_installation
sudo mysql -u dbUsername -p

While in mariaDB
SHOW DATABASES;
CREATE DATABASE `name Of Table`;
SHOW DATABASES;
exit

#### Locate where the configuration file should be [Finding the Defaults File](https://mariadb.com/kb/en/configuring-mariadb-for-remote-client-access/#finding-the-defaults-file)
sudo nano pathWhereConfigurationFileLocated

#### while in config file, add the following
[mysqld]
skip-networking=0
skip-bind-address
###### exit and save changes

sudo service mysql restart

sudo mysql -u dbUsername -p
SELECT User, Host FROM mysql.user WHERE Host [LeftAngleBracket][RightAngleBracket] ‘localhost’;
GRANT ALL PRIVILEGES ON *. TO ‘remoteUserName’@’###.###.###.%’ IDENTIFIED BY ‘newPasswordForRemoteUser’ WITH GRANT OPTION;
SELECT User, Host FROM mysql.user WHERE Host [LeftAngleBracket][RightAngleBracket] ‘localhost’;
exit

sudo service mysql restart

##### Switch over to other machine #######

sudo apt-get install libreoffice-mysql-connector