MySQL (a)

I. Overview

1. What is a database?

A: Data warehouses, such as: In an instance of ATM we created a DB directory called the database

2. What is MySQL, Oracle, SQLite, Access, MS SQL Server, etc.?

A: They are all software and have two main functions:

• A. Saving data to a file or memory
• B. Receive the pending command, and then perform the appropriate action on the file

PS: If you have the above software, do not need to create files and folders yourself, but instead of directly passing commands to the above software, let them for file operations, they are collectively referred to as the database management system (Dbms,database Management Systems)

3. What is SQL?

A: The above mentioned MySQL and other software can accept the command, and make the appropriate action, because the command can contain delete files, get the contents of the file and many other operations, for the written command is the SQL statement. SQL is the abbreviation for structured language (structured Query Language), which is a language specifically designed to communicate with a database.

Second, download the installation

MySQL is a relational database management system developed by the Swedish MySQL AB company, currently owned by the Oracle company. MySQL's most popular relational database management system, MySQL is one of the best RDBMS (relational database Management system, relational databases management systems) application software in WEB applications.

To use MySQL to store and manipulate data, you need to do a few things:

A. Installing the MySQL server
B. Installing the MySQL Client
B. "Client" Connection "server Side"
C. "Client" sends a command to the "server-side MySQL" Service to accept the command and perform the appropriate operation (increase and deletion of the search, etc.)

Download        http://dev.mysql.com/downloads/mysql/Install        windows:            dot dot        Linux:            yum install Mysql-server        MAC:            Dot Dot

Window version

1. Download

MySQL Community Server 5.7.16 http://dev.mysql.com/downloads/mysql/

2. Decompression

If you want MySQL to be installed in the specified directory, then move the extracted folder to the specified directory, such as: C:\mysql-5.7.16-winx64

3. Initialization

MySQL after the extracted bin directory has a bunch of executables, execute the following command to initialize the data:

CD C:\mysql-5.7.16-winx64\bin mysqld--initialize-insecure

4. Start the MySQL service

Execute the command to start the MySQL service

# Go to executable directory CD C:\mysql-5.7.16-winx64\bin # start MySQL service mysqld

5. Start the MySQL client and connect

MySQL (a)