1. Install MariaDB
MariaDB Server can be easily installed using Homebrew:
brew install mariadb
2. Start the server
mysql.server start
You can also configure auto-start using Homebrew's services functionality:
brew services start mariadb
3. Log in to the server
After starting the server, you can log in as the mysql
user or as root
(using sudo mysql -u root
)
4. Configure a database
Create a database
After logging into the server with the command above, execute
mysql> CREATE DATABASE your_database_name;
Note that the semicolon (;
) is mandatory!
Create a user
First, create the user for localhost:
mysql> CREATE USER 'app_user'@'localhost' IDENTIFIED BY 'Password123!';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'app_user'@'localhost'
-> WITH GRANT OPTION;
Next, create the user for an arbitrary server:
mysql> CREATE USER 'app_user'@'%' IDENTIFIED BY 'Password123!';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'app_user'@'%'
-> WITH GRANT OPTION;
Good to know
If any of the specified accounts, or any permissions for the specified accounts, already exist, then the server returns ERROR 1396 (HY000). If an error occurs, CREATE USER will still create the accounts that do not result in an error. Only one error is produced for all users which have not been created:ERROR 1396 (HY000): Operation CREATE USER failed for 'u1'@'%','u2'@'%'
After completing those steps, the database is ready and should also be manageable using tools like DataGrip.
Related links: https://mariadb.com/kb/en/installing-mariadb-on-macos-using-homebrew/
Top comments (1)
➜ ~ mysql.server start
Starting MariaDB
/opt/homebrew/Cellar/mariadb/11.5.2/bin/mysqld_safe: Deprecated program name. It will be removed in a future release, use 'mariadbd-safe' instead
240924 09:43:25 mysqld_safe Logging to '/opt/homebrew/var/mysql/firman-mac-m1pro.local.err'.
240924 09:43:25 mysqld_safe Starting mariadbd daemon with databases from /opt/homebrew/var/mysql
./opt/homebrew/bin/mysql.server: line 264: kill: (46220) - No such process
ERROR!