Recent posts

Remote access to MariaD

First install the LEMP stack on the server like so (to make sure we are prepared for what comes later when I will also use the database to serve a website).

To make the database accessible I first downloaded it from my hosting provider’s through myphpadmin. And then used this tutorial to load it.

I set up the local environment on the client (windows laptop) from which we will access the database. On the Windows laptop I use Conda as environment manager.

conda create -n db-test
conda activate db-test
pip install mariadb

Make sure you run these with root permissions (or as administrator on Windows 10).

We need to allow access to the database on the server through the firewall. Of course we restrict to local IP addresses only.

sudo ufw allow proto tcp from to any port 3306

From there we follow the steps here, using this version:

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

In that last file change the bind address tobind-address =

Set up a user with access from your specific client IP address in Madiadb on your server.

CREATE USER 'user'@'you.rcl.ien.t' IDENTIFIED BY 'password';
SELECT User, Host, Password FROM mysql.user;
GRANT SELECT, INSERT, UPDATE, DELETE, DROP  ON your_db.* TO 'test'@'you.rcl.ien.t';

For connecting I use the python connector.

With this script:

#!/usr/bin/env python

import mariadb
import sys

# Define mariadb connection configuration
config = {
  'user': 'user',
  'password': 'password',
  'host': 'you.rse.rve.r',
  'database': 'your_db',
  'port': 3306
# Instantiate Connection
    conn = mariadb.connect(**config)
    print(f'Yup! {conn}')
except mariadb.Error as e:
    print(f"Error connecting to MariaDB Platform: {e}")

Python and LEMP stack

Get pip, venv, and git:

sudo apt install python3-pip
apt-get install python3-virtualenv
sudo apt install python-is-python3
sudo apt install git

Set up LEMP stack following this tutorial.

New install

Switching to the NVIDIA proprietary graphics driver led to a crash. I did not have a live disk, so I had to do a full re-install.

Couple of tweaks. First of all, there is a more rigorous fix for the NVIDIA driver boot issue here. At least there is now a Grub menu so that debugging is possible.

I have not yet dared to use the NVIDIA driver again. But in the start-up logs there is still an error related to the open source driver which seems to slow down the boot process.

To see boot errors:

journalctl -b | grep error

One of the things I try is this to solve the NXDOMAIN error that I saw in the boot log:

sudo rm -r /etc/resolv.conf
sudo ln -s /run/systemd/resolve/resolv.conf /etc/resolv.conf

Also followed this tip and re-installed Gnome:

sudo apt-get install --reinstall systemd gnome-settings-daemon gnome-settings-daemon-common

And enabled canonical-livepatch with a new token, as described here.

sudo snap install canonical-livepatch
sudo canonical-livepatch enable [#yourverylongtoken#]