MySQL Learning Note (ii)

Installation configuration and uninstallation of MySQL:

Installation:
(1) Put the green version of MySQL free install package on the D drive, the command line into the MySQL green version of the bin directory after decompression:
CD D:\mysql-5.6.35-win32\bin

--Green version available here:

Link: Http://pan.baidu.com/s/1jISkrPG Password: a6gy

(2) Installing the MySQL service
Mysqld install, the MySQL installation succeeds after running the command.

(3) Start the MySQL service.
net start MySQL will start the MySQL service. It is worth noting that MySQL is installed with the command under the default service name MySQL under Windows system, the default password is empty.

(4) Configuring environment variables
1) Create a new mysql_home system variable with the configuration value: D:\mysql-5.6.35-win32

(You can see if the setting is successful with the SET command)

2) Edit the path system variable and add%mysql_home%\bin to the PATH variable. Configure the PATH environment variable, or do not create a new mysql_home variable, but directly configure the bin under the MySQL installation directory under the PATH variable,
Path:%mysql_home%\bin

(5) Enter MySQL
Mysql-u root-p, the password defaults to empty. displaying "mysql>" means entering MySQL and can perform various operations on the database with T-SQL statements. Database can also be managed with graphical management tools

Unloading:

Completely uninstall MySQL (stop service, uninstall related programs, delete registry
1. Stop service MySQL

2. Uninstall MySQL-related programs

3. Delete the registry (run->regedit),machine->system->controlset001/controlset002/currentcontrolset->services-> Eventlog->applications->mysql related files

4. Delete the MySQL installation directory and the directory where the database data is saved (C:\Documents and Settings\All Users.windows\application data or C:/documentsand Settings/all Users/application Data), note that these directories may be hidden and need to set folder options to show hidden directories

5. Restart the computer, uninstall complete

Completely uninstall MySQL (stop service, uninstall related programs, delete the registry can be consulted: completely uninstall MySQL

MySQL Learning Note (ii)