MYSQL tutorial about the installation and connection tutorial of mysql5.7.18

This article mainly introduces in detail the first part of MySQL basic tutorial, mysql5.7.18installation and connection tutorial. It has certain reference value for those who are interested. We can refer to

Starting from this article, we will use a new series of articles to introduce and learn MySQL. Why should you learn MySQL? From a product perspective, most software database services still use relational database. The main database products include Oracle, Microsoft's MSSQL, IBM's DB2, and the MySQL we are going to introduce. . MySQL is the first choice for databases in many small and medium-sized website servers. It has a free version and a commercial version. It is currently an Oracle product. From the perspective of testers, more and more software products are related to data, such as e-commerce, and some software products that provide database services in a certain field. In addition to basic software functional testing, the company also hopes that testers can understand more business knowledge. Usually, these business data have to deal with databases most of the time. Therefore, testers must master some basic operations of the database and be able to write SQL query statements. Being able to write SQL query statements is mentioned in many job descriptions.
There are many articles and examples on the Internet for simple addition, deletion, modification and query of SQL statements. What I want to do here is install MySQL and use it simply, and then

practice

writing SQL queries, so that I can master SQL statements more systematically. Many times, you have SQL practice statements on the Internet, but you do not have a SQL Server environment, so it is difficult for you to understand and quickly master SQL statements. Therefore, our first article starts with installing the MySQL server and client, Creating the database and Connecting the database.

1. Download and installation of MySQL Server

2. Pull down the page and find the Donwload button

, according to your For the machine operating system version, choose 32 or 64-bit version. The latest version is 5.7.18

3. After downloading, it will be installed by default. We will choose to install MySQL Server and leave other components unchecked. select.

4. During the installation process, create a password for root. I set the password here to root, as shown below.

You need to click Add User to add a DAB account: test/123456, enter the user name and password, as shown below

Click Next to end the installation by default. After installing MySQL Server, database-related services will start every time you start your computer. Now that we have installed the database server, next, we need to install a visual, graphical interface client to connect to the database. Here we use MySQL Workbench.

2. Download and install MySQL Workbench

2. Find "Windows (x86, 64-bit), MSI Installer"

3. Click the Download button

4. On the new page, pull down, we don’t need to log in to the account, click No thanks, just start my download.

5. Start downloading.

6. After the download is completed, start the installation. The interface is as follows:

##3. Connect to the database on MySQL Workbench

Open MySQL Workbench, the interface is as follows

If the installation is normal, MySQL Workbench will display under MySql Connections

Local databaseYes Connect as shown below.

Click on this gray background area, and the password for root will pop up. When we installed MySQL Server above, we set the password to root. After entering the password, click Connect and it will succeed. Connect to local database. If there is no gray, you click the + button next to it, enter the user name and password according to the panel content, select the database of the local service, and you should be able to connect.

1. Create our own database db1

Click on the red box in the picture above and create a new database according to the prompts. Enter db1 for the name and utf-8 for the encoding. The created database can be seen below the left panel.

In the above picture, db1 is our newly created database, and sys is the default database after MySQL Server is installed. From now on, we will use MySQL Workbench to connect to our database, and then create tables and other related data manually or with SQL statements. The overall interface is as follows.

#The basic SQL environment is introduced here. The next article will talk about how to create tables and columns in the table under the db1 database.

The above is the detailed content of MYSQL tutorial about the installation and connection tutorial of mysql5.7.18. For more information, please follow other related articles on the PHP Chinese website!