MySQL Installation and configuration

First, download MySQL

MySQL download page

I'm using 5.6, click Next to "Looking for previous GA versions?" button to see version 5.6

Mysql-5.6.30-winx64.zip (Thunderbolt) 351.1M

It's green, unzip it to the appropriate directory.

Second, configure environment variables

1, add "mysql_home", content is the path of MYSQL (I Am "D:\Java\mysql")

2. Edit "Path" and add "%mysql_home%\bin" after the original content. (separated by semicolons)

Iii. Registering Windows System services

1, open the console (to run as an administrator), enter "cd/d d:\java\bin", enter the MySQL bin directory

2, enter the Service installation command "Mysqld install MySQL--defaults-file=" D:\java\mysql\my-default.ini "" (You can right-click on the console to paste), press Enter will prompt installation success

3. The removal service command is "mysqld remove"

Four, start MySQL

Open the Windows service and locate the MySQL boot (the command to start the service is "net start MySQL" and can also be started)

V. Installation management tools (Navicat Premium)

1, Navicat_premium (jb51.net). RAR (cracked version) 30.49M

After installation, put the cracked files in the installed path to run

2, establish the connection of MySQL, password not to lose the default is empty

3, modify the user name password

It's usually 123456.

MySQL Installation and configuration