GRANT ALL ON *.* to IDENTIFIED BY 'password' WITH GRANT OPTION
Mysql_secure_installation Adjusting User Authentication and PrivilegesĬreate a new user with root privileges and password-based access. The following additional packages will be installed: Configuring MariaDB To install it, update the package index on your server with apt: apt update Then you simply have to repeat the steps that we’ve seen above./mariadb_repo_setup -mariadb-server-version="mariadb-10.5.MariaDB is a community-developed, commercially supported fork of the MySQL relational database management system, intended to remain free and open-source software under the GNU General Public License. Now, let’s see how to upgrade the version of an installed MariaDB server.įirst, you have to remove all the packages concerning MariaDB.
You can also try to connect to MariaDB server to check its version. sudo yum install mariadb-server mariadb-backupĪfter the installation, have a look if it was properly installed (by listing all the installed package) and if the mysql service is running. I used yum install as I was working on a Redhat VM. mariadb_repo_setup -mariadb-server-version="mariadb-10.5.4" You can find all the different packages available here at MariaDB repository configuration tool :
If you didn’t mention the MariaDB version when downloading the script, now is the time to change it to choose the MariaDB version you want to install. Then don’t forget to give the execution right to the script you just downloaded. Note that you can add some parameters when you pull the file, like –mariadb-server-version= that will override the default MariaDB Server version.Įxample : curl -LsS | sudo bash -s -mariadb-server-version="mariadb-10.6" The first step is to download the MariaDB script to configure access to their MariaDB Package Repositories : wget I’ll now explain how to install MariaDB server version 10.5.4. Today, I’m going to explain how to install a specific version of MariaDB and how to upgrade it to an other specific version. Before to do the upgrade on a production server, I wanted to test it on a personal VM.īut first, I had to find how to install the specific version 10.5.4 of MariaDB. Recently, we had to upgrade a MariaDB server from version 10.5.4 to 10.5.13.