Installation and use of MySQL

1. Download

Database: Mysql-3.23.53-win1

Visualization tool: Mysqlcc-0.9.4-win32

2. Steps:

(1) Decompression mysql-3.23.53-win1 (others can also), follow the steps to install to your local, install and find the path of the bin folder and copy it down;

(2) Configure the environment:

Computer-Properties-Advanced system settings-environment variables-Locate the variable value of path in the following system variable, copy the path above the bin to the front of the entire path, and add an English semicolon after the bin path;

(3) test whether MySQL installation is complete

cmd-enter MYSQL-V to see if the following text appears

(4) Install visualization tools

Open Mysqlcc-0.9.4-win32 Setup to install, the new user name to write their own, the password is empty, after writing, click Test, testing;

3. Note

(1) When the user is newly created in the visualizer, the test appears 2003, indicating that the current service does not start: Resolve computer-management-services and applications-services-find MySQL Boot

(2) When 2003 is still present, but MySQL is not found in the service: Resolve administrator to run cmd-find bin path-after entering Mysqld.exe-install, MySQL will appear in the service

(3) When a new user is created, the password is empty (default)

(4) Mysqlcc-0.9.4-win32 change to Chinese: options-general-language-simplified chinese-apply

Installation and use of MySQL