Tag: MariaDB

For Ubuntu 16.04 LTS and 17.10 users running MariaDB 10.0 or 10.1, an upgrade to MariaDB 10.2 is recommended before updating to Ubuntu 18.04. The upgrade offers new features and ensures full support as it’s the default database version in Ubuntu 18.04. The process involves preparing MariaDB for upgrade, backing up databases, uninstalling the prior…

MariaDB, an open-source server and fork of MySQL, is quickly becoming a preferred choice on Linux systems. This post provides instructions for installing MariaDB 10.2 or 10.3 on Ubuntu 16.04 LTS. As Ubuntu’s default repository only supports MariaDB 10.1, the article guides users through the process of adding a specific MariaDB repository. Installation, including setting…

The MariaDB database server now installs on Ubuntu without requiring a root user password for server access, a departure from its MySQL origins. This could cause issues with dependent applications like phpMyAdmin and MySQL Workbench. However, it’s possible to re-enable password authentication by updating the user plugin settings, restarting and securing the MariaDB server, and…

The post discusses a common error faced by users after upgrading MariaDB database server on an Ubuntu platform – the ‘unix_socket’ is not loaded error. This prevents root user login. The post provides a tutorial to overcome this error by making changes in the MariaDB configuration file, enabling Unix socket authentication, and subsequent modifications to…