MariaDB ERROR 1524 Plugin unix_socket is not loaded

After upgrading MariaDB on Ubuntu server, i got following error

Users created worked fine. Only root user had this error. To fix, you need to enable auth_socket.so plugin. Edit file

Find

Add below

Resatrt MariaDB

See MySQL […]

Read More…

MySQL server has gone away

When restoring a MySQL database, i get error “MySQL server has gone away”.

To fix this, edit MySQL configuration file. Add following line under [mysqld] section.

Restart MySQL

If you use MariaDB

Related Posts MySQL […]

Read More…

Ubuntu 18.04 MariaDB 10.2 Too many open files

MariaDB

On my computer running Ubuntu 18.04, MriaDB stopped working. PHP application i run on my computer failed with error

Application can’t find the table. So i tried to login to MySQL and see if table is there or not. But i get error

Next i checked if this is due to any MySQL […]

Read More…

Install MariaDB 10.3 on CentOS 7

MariaDB

MariaDB is an Open Source MySQL drop in replacement. MariaDB provides repository for various operating systems at http://downloads.mariadb.org/mariadb/repositories/ To install MariaDB 10.3 on CentOS 7, create file

Add

Install MariaDB server and client with

Enable MariaDB start on boot

Start MariaDB

[…]

Read More…

MariaDB DEFAULT NULL ERROR 1064 (42000)

When trying to restore a MySQL databse bakcup taken on MySQL 5.7 server to MairaDB 10.1 server i get following error.

Source server

Destination server

I opend the SQL file in editor and checked line 287, i run the SQL in mysql, that resulted in error

I run the command on […]

Read More…

MariaDB Repository Setup Script

This script configure MariaDB repository on your server. You can find more details on offical page https://mariadb.com/kb/en/library/mariadb-package-repository-setup-and-usage/ To setup mariadb repo, run

I was expecting it ask me what version of MariaDB i like to setup. But it just setup MariaDB 10.4. I wanted to upgrade MariaDB to version 10.2, anyway i did upgrade […]

Read More…