Install and use MySQL on MAC

1. Download MySql + MySqlWorkBench and visit the MySQL official website dev. mysql. comdownloads or pan. baidu. on the homepage of coms1gdu40T1, You can see "MySQLCommunityServer" and "MySQLWorkbench". Here, "MySQLCommunityServer" is used as an example. Click the DOWNLOAD button to DOWNLOAD it.

1. DOWNLOAD MySql + MySqlWorkBench access MySQL official website http://dev.mysql.com/downloads/ or http://pan.baidu.com/s/1gdu40T1 on the home page will see "MySQL Community Server" and "MySQL Workbench" here "MySQL Community Server" as an example click DOWNLOAD button download

1. Download MySql + MySqlWorkBench
Visit the MySQL official website http://dev.mysql.com/downloads/
Or http://pan.baidu.com/s/1gdu40T1
"MySQL Community Server" and "MySQL Workbench" are displayed on the homepage"
Take MySQL Community Server as an example.

Click the DOWNLOAD button to go To the DOWNLOAD selection page. By default, "mac OS X" has been selected for the current system to list the mysql versions available for DOWNLOAD.

Select Mac OS X 10.9 (x86, 64-bit), DMG Archive (64-bit dmg file), and click DownLoad To Go To The DownLoad page.

Select "No thanks, just start my download." at the bottom to start the download.

"MySQL Workbench" is also downloaded in this way

Ii. Installation
After the download is complete, start installation. First install mysql and double-click the mysql installation package.

Double-click the installation and the installation will appear in the preference settings of the system.

Now turn on the system preference settings and find that mysql has been successfully installed.

Install MySQL Workbench now. Open the installation package and drag MySQLWorkBench to Applications.

Iii. Use
Find MySQLWorkBench in the system application and open

Then you need to connect MySQLWorkBench to mySql for unified management.

The main interface consists of three modules: MySQL Connection, Shortcuts, and Models.
There is a "+" button on the right side of MySQL Connection. After clicking it, a "Setup New Connection" dialog box is displayed. after entering the Connection Name, click OK. You can complete a connection to the local database.

After you click OK, the connection you just created will appear on the main page.

Click the new connection John and enter the secret. The account information is root/root by default. The following database operation page is displayed.

There are four modules on the left: MANAGEMENT, INSTANCE, PERFORMANCE, and SCHEMAS. The MySQL service can be started or disabled under the INSTANCE, and all databases connected to the current INSTANCE are displayed under SCHEMAS, A database named test is created by default. Here we can Create a new database, right-click the blank space at SCHEMAS, and select "Create Schema ..."

Enter the database Name at Scheme Name and click apply. Then, click apply to create a database.

Alternatively, you can use an SQL statement to CREATE a database: CREATE SCHEMA database name;

After creation, click the refresh button on the Right of SCHEMAS to refresh SCHEMAS. A new database is added under SCHEMAS.
Right-click the Database Name and select "Set as Default Schema". The SQL statements written later are all operations performed on the database by Default.