Installation steps for MARIADB database in Mac

Objective

MARIADB, led by MySQL's founder Michael Widenius, sold his company MySQL to Sun for $1 billion earlier, and since Sun was acquired by Oracle, MySQL's ownership also fell into Oracle's hands. Mariadb name comes from Michael Widenius's daughter Maria's name. So how do you install the MARIADB database on your Mac? The following small series will give you a description of the installation of Mac Mariadb database method.

MARIADB Installation Steps

If you are a developer on a Mac, you can easily get the latest stable version of mariadb via homebrew on OS X, and then we'll step through the installation of the MARIADB database. If Xcode and homebrew are already installed on your Mac, skip to step fourth.

1. Install Xcode

Use the following command to install Xcode :

2. Installing homebrew

HomebrewCommands for installation:

Ruby-e "$ (curl-fssl https://raw.github.com/Homebrew/homebrew/go/install)"

3. Check Homebrew

4. Update Homebrew

If you check the above command for a Homebrew version that is not up to date, you can use the following command to Homebrew update to the latest:

5. Confirm the MARIADB version

Homebrewconfirm the version of MARIADB in the warehouse:

6. Installing MARIADB

Download the installation mariadb by using the following command:

7. Run the Database Setup program

Execute the following command separately to implement the installation:

8. Running MARIADB

After several commands above, the MARIADB database has been installed, but the MARIADB database service is not started and you can start the MARIADB database service with this command:

9. Complete the installation safely

By starting the MARIADB database service above, you can already connect to the MARIADB database, but it is not secure enough, the following steps can be completed more comprehensive settings, such as: Reset root the user's password, remove the anonymous user, remove the default test database and so on

The specific execution and settings are as follows:

? 10.1.14:mysql_secure_installationnote:running all PARTS of this SCRIPT are RECOMMENDED for all MariaDB SERVERS in Produ Ction use! Please READ each STEP carefully! In order to log into MariaDB to secure it, we'll need the current password for the root user. If you've just installed MariaDB, and you haven ' t set the root password yet, the password would be blank, so you should jus T press ENTER here. Enter current password to root (enter for none): ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using pas Sword:yes) Enter Current password for root (Enter for none): ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:yes) Enter current password for root (Enter for none): OK, successfully used password, moving on ... Setting The root password ensures that nobody can log into the MariaDB root user without the proper authorisation. Set root Password? [y/n] Y new Password:re-enter New Password:password updated successfully! Reloading privilege tables.. ... success! By default, a MariaDB installation had an anonymous user, allowing anyone to log into MariaDB without had to had a use R account created for them. This was intended only for testing, and the installation go a bit smoother. You should remove them before moving into a production environment. Remove anonymous users? [y/n] Y... success! Normally, Root should only is allowed to connect from ' localhost '. This ensures, someone cannot guess at the root of password from the network. Disallow Root login remotely? [y/n] n ... skipping. By default, the MariaDB comes with a database named ' test ' that anyone can access. This was also intended only for testing, and should was removed before moving into a production environment. Remove test database and access to it? [y/n] Y-dropping Test Database ... success! -Removing privileges on test database ... success! Reloading the privilege tables would ensure that all changes made so far would take effect immediately. Reload PrivilegE tables now? [y/n] Y... success! Cleaning up ... All done! If you've completed all of the above steps, your MariaDB installation should is now secure.  Thanks for using mariadb!

10. Connecting MARIADB Data

Commands to connect to the MARIADB database:

11. Verifying the MARIADB version

MariaDB [(None)]> SELECT @ @version; +-----------------+| @ @version  

MARIADB basic Commands

Here are some basic use commands for MARIADB:

Summarize

The above is all the steps to install the MARIADB database in Mac, everyone has learned it? Hope that the content of this article on everyone's learning can help, if there are questions you can message exchange.

1. Install Nginx after encountering

Dyld:library not loaded: @@[email protected]@/openssl/1.0.1h/lib/libcrypto.1.0.0.dylib

Referenced from:/usr/local/opt/openssl/lib/libssl.1.0.0.dylib

Reason:image not found

Reinstall OpenSSL

sudo brew uninstall OpenSSL

sudo brew install OpenSSL

Installation steps for MARIADB database in Mac