Category Archives: MySQL

Percona XtraDB Cluster in Docker Swarm.

I have the next scenario where I needed to setup a MySQL Percona XtraDB Cluster on containers on 3 different servers.

Posted in Cluster, Containers, Databases, Docker, HA, Linux, Misc, MySQL, Percona, Percona XtraDB | Leave a comment

Incorrect definition of table mysql.proc

I recently upgraded my server from Debian 8 to Debian 9, I also upgraded MySQL5.5 (Percona)  to MariaDB 10, everything seemed fine until I noticed the database was down, and i just couldn’t bring it up, it just kept dying, … Continue reading

Posted in Databases, Debian, Linux, MySQL, Systemd, Unix | 4 Comments

Change Moodle admin password from the database

It’s quite straight forward to change the password from the database, although it changes a little depending on the Moodle version, version 2.5 and older use a different salting method, the salt can be found on the config.php file.

Posted in CMS/LMS, Databases, Moodle, MySQL | Tagged , , , , , , | Leave a comment

PHP Warning: mysql_connect(): client does not support authentication protocol

If you are working with a newer version of MySQL and an older version of PHP, you might encounter this error, when you try to establish the connection:

Posted in Databases, MySQL, PHP | Tagged , , | Leave a comment