Configuration of MySQL decompression version under Windows

Official website: https://dev.mysql.com/downloads/mysql/

1, the download Mysql-5.6.36-win32.zip decompression to the need to install the location, such as: d:\;

2. Configure WINDOWS environment variable settings

System variables, environment variables, advanced system settings, properties---

Select Path, after which it is added: D:\mysql-5.6.36-win32\bin;

3, modify the configuration file

MySQL Server 5.6\my-default.ini, or build a My.ini file yourself,

in which to modify

# basedir = D:\mysql-5.6.36-win32
# DataDir = D:\mysql-5.6.36-win32\data

4. Run cmd as administrator (be sure to run as administrator, or not enough permissions)

Input: cd D:\mysql-5.6.36-win32\bin into the MySQL Bin folder (regardless of whether the environment variable has been configured, also to enter the Bin folder, or after the start of the service will still report error 2)

Enter Mysqld-install (if run without administrator, there will be an error due to insufficient permissions: Install/remove of the Service denied!)

Installation Successful

5. Start the service

Continue typing in cmd: net start MySQL

Service started successfully!

6. Login

Enter Mysql-u root-p (first login without password, press ENTER directly)

Login Successful! Appears mysql>

Start, stop, and uninstall of MySQL service

Run at the Windows command prompt:

Startup: net start MySQL

STOP: net stop MySQL

Uninstall: SC Delete MySQL

MySQL exits three methods:

MySQL > exit;

MySQL > quit;

MySQL > \q;

(My Computer test quit only mysql > \q; useful)

　　

Configuration of MySQL decompression version under Windows