Setup and startup of MySQLWindowsZIP without Installation

Setup and startup of MySQLWindowsZIP without Installation

MySQL Windows ZIP is free of installation, and the setup and startup process is actually quite troublesome. The following describes the procedure:

1. Download Windows (x86, 64-bit), ZIP Archive:
2. decompress the zip file
3. Copy the my-default.ini under mysql and create my. ini in the same directory. Simple Configuration:
Basedir = D:/mysql-5.6.22-winx64
Datadir = D:/mysql-5.6.22-winx64/data
Character-set-server = utf8

4. Set the environment variable PATH. Add D: \ mysql-5.6.22-winx64 \ bin to path.
5. Start and display the log:
Command Line> mysqld-console as Administrator
6. Register mysql as a windows Service:
Command Line> mysqld install as Administrator

Log on to the Service Manager and check whether the service has been successfully registered:> services. msc

Remove MySQL service command:> mysqld remove

Note: If windows service installation fails, run the "SC delete MySQL" command to delete the service and try again.

7. start the MySQL service:> net start mysql

Note: If the first startup fails, Run "mysqladmin-uroot-p shutdown" and try again.

Command for stopping MySQL service:> net stop mysql

8. log on to MySQL: mysql-u root-p

9. Change the user password:
Mysql> GRANT ALL ON.TO 'root' @ 'localhost' identified by '123'

10. other test commands:
D: \ mysql-5.6.22-winx64 \ bin> mysqlshow
D: \ mysql-5.6.22-winx64 \ bin> mysqlshow-uroot-p123456 mysql
D: \ mysql-5.6.22-winx64 \ bin> mysql test