Prepare MariaDB for Upgrade To prepare MariaDB for Upgrade, logon to the database server as root with the root password and run the commands below sudo mysql -u root -p Then run the commands below to set innodb_fast_shutdown to 0 mysql> SET GLOBAL innodb_fast_shutdown = 0; Backup Your Databases It’s always important to backup your databases before attempting to upgrade To back up, run the commands below against each database you wish...
Read More
Login to mysql $ mysql -u root -p Show users mysql> SELECT User FROM mysql.user;...
Read More
Before you can install MariaDB 10.3, you may need to uninstall the current version of MariaDB server. You can ignore this if upgrading. On Ubuntu, run: sudo apt-get remove mariadb-server For CentOS 7, run: sudo yum remove mariadb-server Install MariaDB 10.3 on Ubuntu 18.04 To install MariaDB 10.3 on Ubuntu 18.04, you need to add MariaDB repository on to the system. Step 1: Install software-properties-common if missing: sudo apt-get install software-properties-common Step 2: Import MariaDB gpg key: Run...
Read More