Mac-mac computer install MySQL server and navicat for MySQL client

1. Download link

Navicat for MySQL Client
Link: Https://pan.baidu.com/s/1dGbzgbR Password: i43g

MySQL server
Link: Https://pan.baidu.com/s/1qYE01BI Password: qz9s

2. Install MySQL and navicat

Navicat for MySQL, downloaded itself is an app, do not have to install again, directly dragged to the application can

Install MySQL, follow the installation steps to install, the installation will appear the following box, it is important to remember that the version after 5.7 default has a temporary password: such as E8AWKBIYQF) # is the temporary password

Start MySQL server: preferences, click MySQL

First click on Start MySQL Server will appear to enter the computer password, enter your own computer password can

Server Startup

To modify the temporary password:

Path to MySQL Local installation

Open Terminal, enter

/usr/local/mysql/bin/mysqladmin -u root -p password

• 1

bogon:~ chenchen$ /usr/local/mysql/bin/mysqladmin -u root -p passwordEnter password: 输入刚才弹出的临时密码New password: 新密码Confirm new password: 确认新密码Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.bogon:~ chenchen$ 

• 1
• 2
• 3
• 4
• 5
• 6

Password modified successfully

3.navicat for MySQL and MySQL associations

Open Navicat for MySQL
Click the link:

Fill in the information about MySQL

Open the database you just linked, there are several databases that have been created, this is the system automatically help you create, do not care about him.

4. Create a Database

Next, create the database you want. Right-click New database:

The default character set selects UTF8.
The default collation selects Utf8_bin.

This option avoids Chinese garbled occurrences.

5. Create a database table

Adding primary keys and other fields

Click Save

In this table, I set up three domains, userid,name.
In this interface you can choose the type, length, length after the decimal point, whether it is empty, and set the function as the primary key.

After you select a field, you can also set other properties at the bottom of the interface, with default values, Comment,column format, and so on
Here I set the userid to self-growth.

6. Set the user

Input related settings and configuration

Mac-mac computer to install MySQL server and navicat for MySQL client