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

Introduction to the use of this in HTML tags

For example: Copy code The code is as follows: <...

Let’s talk in detail about how JavaScript affects DOM tree construction

Table of contents Document Object Model (DOM) DOM...

Steps to create a CentOS container through Docker

Table of contents Preface Create a bridge network...

Vue+echarts realizes progress bar histogram

This article shares the specific code of vue+echa...

td width problem when td cells are merged

In the following example, when the width of the td...

How to enter directory/folder in Linux without using CD command

As we all know, without the cd command, we cannot...

Detailed explanation of non-parent-child component communication in Vue3

Table of contents First method App.vue Home.vue H...

A brief talk about JavaScript variable promotion

Table of contents Preface 1. What variables are p...

Linux kernel device driver virtual file system notes

/******************** * Virtual File System VFS *...

Several ways to solve CSS style conflicts (summary)

1. Refine the selector By using combinators, the ...

Zabbix implements monitoring of multiple mysql processes

Three MySQL instance processes are started on one...

Summary of three methods of lazy loading lazyLoad using native JS

Table of contents Preface Method 1: High contrast...

Detailed explanation of making shooting games with CocosCreator

Table of contents Scene Setting Game Resources Tu...