How to create a database in navicat 8 for mysql

How to create a database in navicat 8 for mysql

When developing a website, you often need to use a database to save data. How do we create a database and create data tables? The method is actually very simple. Let me teach you how to use Navicat for MySql to create a database.

Step 1: Create a database locally. First, start the database operating environment. If both Apache and MySQL are displayed in green, it means that the environment is started successfully. Otherwise, the database cannot be operated if the environment fails to start.

sql21.png

Step 2: Open the database management tool Navicat for MySql, which is used to manage the creation and management of our database, as shown in the following figure:

sql22.png

Step 3: After opening Navicat for MySql, right-click on the left and select Create a new database

sql23.png

Step 4: Enter the page for creating a database, name the database myxiaoze; fill in utf8 -- UTF-8 Unicode for the character set; fill in utf8_general_ci for the sorting rule, and click OK after filling in:

sql24.png

Step 5: Right-click on the left to refresh, and you can see the database you just created, as shown below:

sql25.png

The above is the detailed content of how to build a database in navicat 8 for mysql. For more information, please pay attention to other related articles on 123WORDPRESS.COM!

You may also be interested in:
  • Solve the problem of Navicat for MySQL reporting 2005 error when connecting to MySQL
  • Navicat for MySQL 15 Registration and Activation Detailed Tutorial
  • Navicat for MySQL 11 Registration Code\Activation Code Summary
  • Tutorial on installing MySQL database and using Navicat for MySQL
  • Detailed explanation of the idea of ​​installing mysql8.0.11 and changing the root password and connecting navicat for mysql
  • Navicat for MySQL scheduled database backup and data recovery details
  • A simple method to export table structure script using Navicat for MySQL
  • Understand the basics of Navicat for MySQL in one article

<<:  Vue realizes the card flip effect

>>:  Vue component to realize carousel animation

Recommend

The first step in getting started with MySQL database is to create a table

Create a database Right click - Create a new data...

Some CSS questions you may be asked during an interview

This article is just to commemorate those CSS que...

HTML Tutorial: Unordered List

<br />Original text: http://andymao.com/andy...

Detailed steps for installing and debugging MySQL database on CentOS7 [Example]

This example requires downloading and installing ...

Use tomcat to deploy SpringBoot war package in centos environment

Prepare war package 1. Prepare the existing Sprin...

10 Underused or Misunderstood HTML Tags

Here are 10 HTML tags that are underused or misun...

JavaScript implements asynchronous acquisition of form data

This article example shares the specific code for...

JavaScript implements circular carousel

This article shares the specific code of JavaScri...

How to configure MGR single master and multiple slaves in MySQL 8.0.15

1. Introduction MySQL Group Replication (MGR for ...

Introduction to the use of CSS3 filter attribute

1. Introduction When writing animation effects fo...

Detailed explanation of querying JSON format fields in MySQL

During the work development process, a requiremen...