How to Setup Apache, PHP 8.0, MariaDB and Apache Virtual Host using Homebrew Part 3 - Installation of MariaDB

Install MariaDB using Homebrew

Watch the video at https://youtu.be/uwvh3ojSin4

1. Install MariaDB
% brew install mariadb

2. Start the MariaDB server
% brew services start mariadb

3. Change password
% sudo /usr/local/bin/mysql_secure_installation OR % sudo mysql_secure_installation

4. Install TablePlus, Sequel Pro or DBeaver

***
If you have ERROR 1698 (28000): Access denied for user 'root'@'localhost'
% sudo mysql -u root
Password: your pc password

# mysql > ALTER USER 'user'@'localhost' IDENTIFIED BY 'new_password'; 

—leave empty for password if you want empty password