Install MariaDB on macOS 11+

 

Install MariaDB on macOS 11+

MariaDB is a DBMS (database management system) that is similar to MySQL. In recent years, MariaDB has surpassed MySQL in its ability and speed, making it an optimal replacement for users familiar with SQL databases.

MariaDB is a drop-in replacement for MySQL, meaning that mysql commands are symbolically linked. In other documentation, any reference to MySQL would be directed to your installation of MariaDB.

Step 1. Install Homebrew on your machine.

Step 2. Open the Terminal application.

Type in the terminal
brew install mariadb
Then press enter. This process will install mariadb on your system. Follow Mariadb’s instructions to install.

For the most recent instructions, go to MariaDB’s website.

Start your server by using the command:

mysql.server start

To have your server auto-start when the machine boots up, use the command:

brew services start mariadb

After MariaDB has been started, just use the command: mysql or mariadb

The MariaDB monitor should appear in your terminal:

MariaDB [(none)]>

Once you see the interface, use this command to create your new IT user. Use the command:

SET PASSWORD FOR ‘root’@’localhost’ =PASSWORD(new_password);

In this case, root is the IT username and new_password would be your IT password. Only modify the password portion to create your own.

Now you have a new MariaDB installation!