MySQL Basic operation

Ctrl+alt+delete Open Task Manager

Login database: Enter the DOS window, enter Mysql-u root-p Enter, and then enter the password, you can.

Configure the PATH environment: D:\MYSQL\BIN;%SYSTEMROOT%\SYSTEM32;%SYSTEMROOT%;%SYSTEMROOT%\SYSTEM32\WBEM; C:\Program Files (x86) \java\jdk1.8.0_11\bin

(My computer installs the situation) enters the DOS window direct input MySQL can enter, then the configuration succeeds.

MySQL Graphics management tool:1, PhpMyAdmin(http://www.phpmyadmin.net/)

2. Navicat(http://www.navicat.com/)

　　　　　　　　　　3. MySQL GUI Tools(http://dev.mysql.com/downloads/gui-tools/)

4. SQLyog

Start service: net start MySQL

Shutdown service: net stop MySQL

MySQL Basic operation