My posts

Upgrading mariadb 5.5 to mariadb 10.6 to support moodle 3.11

First you need to stop the running 5.5. version: Make a backup of your mariadb datafolder: Then remove the 5.5

Posted in Uncategorized | 1 Comment

Machform error: Cardinality violation: 1242 Subquery returns more than 1 row

We have a multiuser Machform PHP application running on a Redhat 7 Linux server with Apache webserver and MariaDB database.

Posted in Mysql, PHP | Leave a comment

Couldn’t connect remotely with mysql client (command line and phpMyAdmin) to the MariaDB server

I had a MariaDB server running on port 3306. I created a local MariaDB account ‘tommy’ with: CREATE USER ‘tommy’@’localhost’

Posted in Uncategorized | Leave a comment