Brew install MariaDB This will start a whole series of cool lines in your Terminal which makes you look like hackerman! Once it is done, we have successfully installed MariaDB. We can now start/stop the service using Homebrew.
Mariadb@10.2: 324: Installs on Request (30 days) mariadb@10.2: 324: Build Errors (30 days) mariadb@10.2: 22: Installs (90 days) mariadb@10.2: 759: Installs on Request (90 days) mariadb@10.2: 757: Installs (365 days) mariadb@10.2: 2,725: Installs on Request (365 days) mariadb@10.2: 2,720. The gist of it is, if you’ve installed Mac OS X and you use Homebrew, you’ll be pleased to note that you’re just a brew install away for getting a working MariaDB. Yes, that’s right, simply do: brew install mariadb and that’s it — you’ll have MariaDB (currently 5.2.6) installed in no time. The gist of it is, if you’ve installed Mac OS X and you use Homebrew, you’ll be pleased to note that you’re just a brew install away for getting a working MariaDB. Yes, that’s right, simply do: brew install mariadb and that’s it — you’ll have MariaDB (currently 5.2.6) installed in no time.
MariaDB is an alternative to MySQL database which is more performant with a full open license, you can install it easily on macOS via Homebrew.
The first step is to install Homebrew on your computer and possibly to remove any older MySQL database server versions.
Once Homebrew is installed, on the command line:
Then start the server:
To automatically start the MariaDB Server every time on restart (also known as a background service):
Mariadb Brew Root Password
Brew Mariadb Logs
To login as root (no password is initially set): Install java 8 for mac.
or just:
When MariaDB starts on the command line you are entered into an interactive session, you will also see the database version, to exit the session use keys control+c to exit.
For more info on the MariaDB install you can also run:
To update MariaDB
To remove MariaDB
phpMyAdmin Authentication
If you are using phpMyAdmin locally, you will need to create a database user and password as MariaDB uses ‘sudo’ to login as root on the command line – but if you use root & no password in phpMyadmin it will not authenticate.
Login to mysql via command line:
sudo mysql -uroot
Create a user for phpmyadmin, change username and password to suit:
Use that for phpMyadmin access.