How to install MySQL on Mac?

Oracle's MySQL is a popular open source relational database management system based on Structured Query Language (SQL). It is often used with PHP to enhance the functionality of websites. PHP comes pre-installed on Mac computers, but MySQL does not.

Having MySQL installed on your computer is very convenient when you create and test software or websites that require a MySQL database. Installing MySQL on a Mac is easier than you might expect, especially if you use a native installation package rather than a TAR package, which requires accessing and changing the command line in Terminal mode. (Recommended: "MySQL Tutorial")

Use the native installation package to install MySQL

The free download for Mac is the MySQL Community Server Edition.

1. Go to MySQL website to download the latest version of Mac for MacOS. Choose the native package DMG archive version instead of the compressed TAR version.

2. Click the "Download" button next to the version you selected.

3. You are prompted to register an Oracle Web account, but unless you need it, click No thanks to start my download.

4. In the download folder, find and double-click the file icon to load the .dmg archive file, which contains the installer.

5. Double-click the icon of the MySQL software package installer.

6. Read the dialog screen that opens, and then click Continue to start the installation.

7. Read the license terms. Click Continue and agree to proceed.

8. Click Install.

9. Record the temporary password displayed during the installation process. This password cannot be recovered. You have to save it. After logging into MySQL, you will be prompted to create a new password.

10. Press Close on the Summary screen to complete the installation.

The MySQL web page contains documentation, instructions, and change history for the software.

How to start SQL on Mac?

MySQL server is installed on the Mac but is not loaded by default. Start MySQL by clicking Start using the MySQL preference pane, which is installed during the default installation. You can use the MySQL preference pane to configure MySQL to start automatically when you turn on your computer.

The above is the detailed content of How to install MySQL on Mac?. For more information, please follow other related articles on the PHP Chinese website!