Shulou(Shulou.com)06/02 Report--

This article introduces the relevant knowledge of "MySQL and visual IDE installation and configuration". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Preface

SQL is a language for accessing and processing databases, and its full name is Structured Query Language in English. The databases include MySQL, MariaDB, MongoDB, SQL Server and so on. These databases are operational and application-oriented. This paper chooses MySQL database as the operating platform of SQL. The reason is that it is open source, easy to use and mature. After the database is installed, it is best to install visual manipulation tools on the grounds that they are easy to understand and easy to operate. The tools of database visualization are DBeaver, Navicat, MySQL-Front and so on. This paper chooses Navicat premium as the visualization operation platform of MySQL.

MySQL installation

MySQL software and Navicat have been uploaded to Baidu Cloud, and you can download them on your own or from the official website.

MySQL official website address: https://dev.mysql.com/downloads/mysql/

MySQL software installation process is simple, there are no special requirements, the installation path is the default, the default / usr/local path.

After installation, under the system settings, there will be an icon for MySQL. There are two ways to start MySQL:

One: double-click the MySQL icon, follow the icon, select to open the database and close the database.

Two: open and close the database under terminal through the following two statements.

Sudo / usr/local/mysql/support-files/mysql.server startsudo / usr/local/mysql/support-files/mysql.server stop

Tip: use the alias command, set aliases, and reduce statement input.

Alias mysqlstart='sudo / usr/local/mysql/support-files/mysql.server start'alias mysqlstop='sudo / usr/local/mysql/support-files/mysql.server stop'

After the MySQL database is opened, there are two ways to connect to the database and access the data in the database:

One: run in terminal and connect to the database by the following command.

Export PATH=$ {PATH}: / usr/local/mysql/bin # set the environment variable myqsl-u root-p # connection MySQL

Tip: use vim, open bash_profile, and check to see if the addition is successful.

Vim / .bash_profilesource ~ / .bash_profile

Add: common commands for operating the database after connecting to the database

Show databases;# view the database, don't forget the semicolon use test;# uses which database show tables;# there are tables under the data select * from test_sheet;# view the contents of the table exit/quit# exit the database

Second: through the visual operation software Navicat premium, connect to the database, the following explanation.

Navicat premium installation

Navicat Premium is a fee-based software, the link in this article is the cracked version, for some reasons, the installation is not convenient to demonstrate, download and install by yourself, it is not difficult.

The second way to connect to the MySQL database is Navicat Premium. The red part of localhost represents the connection name. You name it yourself, and you can start at will. It comes with the following four libraries to store some system tables. The tables you create can be stored in test, which will be explained in detail when you talk about the SQL statement later.

Information_schema

Performance_schema

Sys

Mysql

The GIF diagram showing how to connect to the database is as follows. Make sure the database is open before connecting.

Sudo / usr/local/mysql/support-files/mysql.server start

Installation package

Link: https://pan.baidu.com/s/1BuYrqNkMMRx9NTELsedzGQ extraction code: t8q3

This is the end of the introduction of "MySQL and visual IDE installation and configuration methods". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.