How to install mysql on mac (tutorial)

MySQL is a commonly used relational database management system, and its installation is a very necessary task for developers. This article will introduce you to the installation tutorial of MySQL on Mac, hoping to help you complete the installation of MySQL quickly and simply.

1. Prerequisites

Before starting the installation of MySQL, we need to ensure that the system has the following two software installed:

1. Homebrew: Homebrew is a Package manager, which can provide the system with the management capabilities of many software packages.

2. Xcode command line tool: Xcode command line tool is a development tool software package that can provide the system with some command tools required for development tools.

If your system has already installed the above two software, you can install MySQL directly.

2. Install MySQL

Using Homebrew can install MySQL very conveniently. The specific installation steps are as follows:

1. Open the Terminal and enter the following command to install MySQL:

brew install mysql

2. After the installation is complete, enter the following command to start MySQL:

mysql.server start

Next, you can check whether MySQL has been successfully installed by using the following command:

mysql --version

If you can see version information similar to the following, it means that MySQL has been successfully installed on the system:

mysql  Ver 8.0.21 for osx10.15 on x86_64 (Homebrew)

3. Configure MySQL

The default configuration of MySQL is unsafe, so we need to configure it to use it normally. The following are some common MySQL configurations:

1. Modify the MySQL root user password

By default, the MySQL root user does not have a password set. Therefore, we need to modify it through the following command:

mysqladmin -u root password "your_new_password"

The "your_new_password" here is the new password you set, which can be customized as needed.

2. Create other users

If you need to create other MySQL users, you can create them through the following command:

mysql -u root -p

> CREATE USER 'username'@'localhost' IDENTIFIED BY 'your_password';

Among them, 'username' is the new user is the username, your_password is the password for that user. Please note that the username and password should be set to strong passwords.

3. Create a database

If you need to create a new database, you can create it through the following command:

mysql -u root -p

> CREATE DATABASE your_database_name;

Among them, your_database_name is the name of the database you created. . Please note that the newly created database name should be set to a meaningful name.

4. Using MySQL

After completing the installation and configuration of MySQL, you can use MySQL for development work.

Enter the following command in the Terminal to enter the MySQL command line interface:

mysql -u root -p

In the command line interface, you can execute SQL statements to perform database operations, for example:

CREATE TABLE your_table_name ( id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, name VARCHAR(30) NOT NULL, age INT NOT NULL );

Where, your_table_name is the name of the database table you created.

5. Summary

In this article, we introduce the installation tutorial of MySQL on Mac, as well as the configuration and usage methods after installation. MySQL is a powerful and flexible database management system that can be widely used in various software development. I hope this article can help you understand and use MySQL.

The above is the detailed content of How to install mysql on mac (tutorial). For more information, please follow other related articles on the PHP Chinese website!