Mysql5.6.16win732-bit installation-free Configuration

1. decompress the package to the custom directory. Mine is E: \ MySQL.

2. environment variable configuration

MYSQL_HOME E: \ MySQL (your extract directory)

% MYSQL_HOME % \ bin is added to path;

3. Find C: \ Windows \ System32 \ cmd.exe, right-click it, and run it as an administrator. (It is very important. Otherwise, an error will be reported: Install/Remove of the Service Denied !),

4. Go to the bin subdirectory of the mysql decompression directory and enter mysqld install

Tip: Servicesuccessfully installed. The installation is successful. MySql is found in the windows service.

5. start, stop, and remove the MYSQL Service

It can be performed in the service manager or in the command line by the following methods.

Start MYSQL service: net start mysql

Stop MYSQL service: net stopmysql

Remove mysql service: mysqld-nt -- remove

6. Modify the root password:

Run cmd and jump to the installation directory/bin,

D: \ ProgramFiles \ mysql5614win32 \ bin> mysql-uroot

D: \ ProgramFiles \ mysql5614win32 \ bin> showdatabases;

D: \ ProgramFiles \ mysql5614win32 \ bin> usemysql;

D: \ ProgramFiles \ mysql5614win32 \ bin> UPDATEuser SET password = PASSWORD ("root") WHERE user = 'root ';

D: \ ProgramFiles \ mysql5614win32 \ bin> FLUSHPRIVILEGES;

D: \ ProgramFiles \ mysql5614win32 \ bin> QUIT

Flush privileges: Force MySQL to reload permissions, which takes effect immediately

How to delete a windows Service

Find C: \ Windows \ System32 \ cmd.exe, right-click it, and run it as an administrator.

C: \ windows \ system32> scdelete <service name>

Example: C: \ windows \ system32> scdelete MySQL