MySQL database (ii) MySQL basic introduction

MySQL Basic introduction

MySQL is a relational database management system.

1, MySQL is an open source free database products.

2. mysql support for PHP is the best (wamp or lamp)

The operation instructions used in MySQL are SQL instructions.

Start and stop the MySQL service

MySQL is a C/s structure: client and server

Server-side software: Mysqld.exe, can be found in the bin directory under the MySQL installation directory.

Command line mode

Open cmd through windows and then manage it with commands

net start service (MySQL): Open service

Error Condition: System error 5 occurred. Access Denied

Run cmd as an administrator to resolve, if you want to permanently resolve, go to C:\Windows\System32, find Cmd.exe, first create a shortcut, right-click the properties-Shortcut-advanced-run as Administrator.

net stop MySQL: shutting down services

System service Mode

Prerequisite: MySQL is added to the Windows service when you install MySQL.

Mode 1:

Access to services

Mode 2:

Enter service: Via command line: win+r– input services.msc

Managing the MySQL server through a service

Scenario 1: Right-click the service and select on or stop

Scenario 2: Double-click on the service, go to the Service Details screen, click the Open or Stop button.

Log in and exit the MySQL system

With the client (Mysql.exe) and the server for connection authentication, you can operate.

Typically: the server and client are not on the same computer.

Login

1, find Mysql.exe (through the CMD console: If the installation is specified when the Mysql.exe path is the environment variable, you can directly access, if not, then you must enter the Mysql.exe directory)

2. Enter the corresponding server address:-H [IP address/domain name]

3. Enter the port of MySQL listener in the server:-P: 3306

4. Enter User name:-u:root

5. Enter the password:-p:root

Connection authentication Basic syntax: MYSQL.EXE-H host address-P Port-u user name-p password

Precautions:

1, usually the port can be the default: MySQL listening port is usually 3306

2. mysql or Mysql.exe

3, the password input can be entered as-p, the direct line, and then enter the password in ciphertext (security)

4,-H host name, you can use this parameter to specify the hostname or IP, if not specified, the default is localhost.

Exit

Disconnect from the server: usually MySQL provides a limited number of servers, a little client runs out, it is recommended that the connection should be disconnected.

Recommended approach: Use the instructions provided by SQL

Exit Exit with semicolon

\q; \q with no semicolons

Quit;//quit with no belt.

MySQL server-side architecture

The MySQL service-side architecture consists of the following layers:

1. Database management system (outermost layer): DBMS, dedicated to manage all server-side content

2. Database (second tier): DB, a warehouse dedicated to storing data (can have many warehouses)

3. Two-dimensional data sheet (third tier): table, dedicated to storing data for specific entities

4, field (fourth level): field, specific storage of some type of data (actual storage unit)

Several common keywords in the database

Row: Line

Column: Columns (filed)

MySQL database (ii) MySQL basic introduction