Overview of simple MySQL commands

The following articles mainly describe simple MySQL commands. In actual operations, there are still many practical applications of MySQL commands. The following articles describe simple commands, the following is a description of the specific content, hoping to bring great help in future study or work.

1. Installation: MySQL installation packages are divided into the installation version and the green decompression version. The green unzipping version does not require installation. You can decompress it directly and use it in the doscommand line. The default user is root and the password is empty.

2. Start the service: D: \ MySQL \ bin \ MySQLd -- consolec

3. Client Logon: D: \ MySQL \ bin \ MySQL-u root

4. create a database: MySQL> create database testDB;

5. Switch Database: MySQL> use testDB;

6. create a new user: MySQL> create user test;

7. install windows Services: D: \ MySQL \ bin \ MySQLd -- install

8. Delete windows Services: D: \ MySQL \ bin \ MySQLd -- remove

9. Stop the service: D: \ MySQL \ bin \ MySQLadmin-u root shutdown

The above content is an introduction to the simple MySQL commands. I hope you will get some benefits.