release A Comprehensive Guide To Installing MariaDB 10.11.4

[Queen]

Hello everyone,

Recently, MariaDB released an update, which brought about some changes in the installation and configuration process. In this guide, I will break down the steps required to install and configure MariaDB 10.11.4.

Installation Steps

Setup

1. Start by searching for the MariaDB package:

• This is the hidden content, please

  • Sign In
  • or
  • Sign Up

   

• Next, proceed to install the MariaDB server:

• pkg install -y mariadb1011-server-10.11.4
      

• To enable the MariaDB service on startup, add the following line to your configuration:

• This is the hidden content, please

  • Sign In
  • or
  • Sign Up

   

• Now, initiate the MariaDB server:

4. This is the hidden content, please

   • Sign In
   • or
   • Sign Up

    

Change Password and Allow Remote Connections

1. Access the MariaDB shell as the root user:

• mysql -u root
      

• Select the mysql database:

• This is the hidden content, please

  • Sign In
  • or
  • Sign Up

   

• Set a new password for the root user:

• This is the hidden content, please

  • Sign In
  • or
  • Sign Up

   

• Refresh the privileges to apply changes:

• FLUSH PRIVILEGES;
      

• Exit the MariaDB shell:

• quit
      

• Restart the MariaDB server:

• service mysql-server restart
      

• Log back in using the new password:

• This is the hidden content, please

  • Sign In
  • or
  • Sign Up

   

• Grant all privileges to the root user for remote connections:

• This is the hidden content, please

  • Sign In
  • or
  • Sign Up

   

• Exit the shell again:

• quit
      

• Restart the MariaDB server once more:

• service mysql-server restart
      

• Log in to the MariaDB shell again:

• mysql -u root
      

• Select the mysql database again:

• This is the hidden content, please

  • Sign In
  • or
  • Sign Up

   

• Set the password for the root user for remote access:

• This is the hidden content, please

  • Sign In
  • or
  • Sign Up

   

• Finally, refresh the privileges one last time:

• FLUSH PRIVILEGES;
      

• Quit the shell:

• quit
      

• Restart the MariaDB server for the final time to apply all configurations:

16. service mysql-server restart
        

Configuration Comparison

You can find the configuration settings at the following path:

This is the hidden content, please

• Sign In
• or
• Sign Up

Within this file, you need to ensure that the following settings are correct:

[mysqld]
user = mysql
port = 3306 # inherited from /usr/local/etc/mysql/my.cnf
socket = /tmp/mysql.sock # inherited from /usr/local/etc/mysql/my.cnf
# bind-address = 0.0.0.0
    

Congratulations! You’ve successfully installed and configured MariaDB 10.11.4!