MySQL Database basics

MySQL Database basics

All the operation of this article is based on the CMD command line operation mode, and can properly refer to the "access to MySQL operation Rights" in the content, this article is to provide a more comprehensive solution for the pre-environmental configuration problem, and this article is a phase (Yao) (Xiang) (HU) into (Ying) The relationship.

First, connection related

1. Start MySQL server: net start MySQL

2. Connect MySQL database: Mysql-uroot-h127.0.0.1-ppassword

3. Disconnect the MySQL database: After connecting to the MySQL server, you can enter exit at the MySQL prompt, or quit; disconnect the MySQL connection.

4. Stop the MySQL server, a total of three basic ways.

Way One:

Way two:

Way three:

MySQL Database basics