Simple MySQL commands

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 -- Console

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