Content provider: Jinniu District Wudi Software Development Studio

Navicat for MySQL should be downloaded and installed first, it is recommended to support the legal version, also can be downloaded on Baidu cracked version can also be used. Also make sure you have your MySQL running. (PS: MySQL default port number is 3306. Do not change it.)

Navicat for MySQL

  1. Open your Navicat and you will see the screen shown below

If it is the first time to use it, you need to create a connection first.

2. Create a local database, go to localhost and right-click to create a new database PS:

  • The recommended character set is UTF-8. If you do not have Chinese characters in your database, you can choose other options
  • The collation will select the first UTF8_general_CI
  1. Now let’s create the tables and fields in the database

For an idea of designing tables and fields, seeBlog.csdn.net/weixin_4360…See the official documentation for the data types of fields:www.runoob.com/mysql/mysql…

MySQL > select * from Navicat; select * from Navicat; select * from MySQL;

Add bowdlerize:

Check:

This is the end of Navicat for MySQL. Feel free to leave a comment below.