One. MySQL Service installation
1. Download:
Address: http://dev.mysql.com/downloads/mysql/
2. Installation:
The entire directory after extracting the downloaded mysql-5.7.16-winx64 compressed package is placed in your favorite location, I put it in the E:\softwareDevelop disk directory
3. Initialize the operation
After decompression into the current folder Bin directory, you can see a lot of executable files, in this directory to perform initialization operations:
CD E:\softwareDevelop\mysql-5.7. -winx64\bin\mysqld--initialize-insecureps: Initialize operation, the current operation will be in MySQL-5.7. Create a Data folder under the-winx64 directory
4. Connect to the server
E:\softwareDevelop\mysql-5.7. -winx64\bin\mysqld
5. Start the MySQL client and connect to the MySQL service
# Enter the executable directory CD C:\mysql-5.7. +-u root-P # Prompt Please enter your password and go directly
Enter the entry to see that the installation was successful:
6. Optimized Operation
To this end, the MySQL server has been successfully installed and the client is ready to connect, and in the future to operate MySQL, it is only necessary to repeat the 4, 5 steps. However, in the 4, 5 steps of repeated access to the executable directory is cumbersome, if you want to be easy to operate later, you can do the following operations.
A. Adding environment variables
Add the MySQL executable to the environment variable to execute the command
"Right-click Computer"-"Properties"-"Advanced system Settings"-"Advanced"-"Environment variable"-"in the second content box to find the variable named path of a row, double-click"- "the MySQL Bin directory path appended to the variable value, with; such as: C:\Program Files (x86) \parallels\parallels tools\applications; %systemroot%\system32;%systemroot%;%systemroot%\system32\wbem;%systemroot%\system32\windowspowershell\v1. 0\; C:\Python27; C:\Python35; C:\mysql-5.7. -winx64\bin
This way, when you start the service and connect later, you only need to:
# to start the MySQL service, enter Mysqld # on the terminal to connect the MySQL service in terminal input: Mysql-u root-p
B. Making a MySQL service into a Windows service
The previous step solves some problems, but is not exhaustive, because the current terminal will be stuck while executing "MYSQD" to start the MySQL server, then do the setup to resolve the problem:
# make MySQL Windows service, execute this command at Terminal: "C:\mysql-5.7.16-winx64\bin\mysqld"--install # Remove the MySQL Windows service and execute this command at the terminal: "C \ Mysql-5.7.16-winx64\bin\mysqld "--remove
After registering as a service, you only need to execute the following command when you start and close the MySQL service later:
# Start MySQL service net start MySQL # close MySQL service net stop MySQL
After MySQL is installed, we can install the visualizer (client) in order to operate the database conveniently.
Two. Navicat for MySQL
First, Introduction
The "1" Navicat is a powerful Visual database management tool for developing and managing databases such as Mysql,oracle,sql Server,sqlite
"2" Navicat premium is a database management tool that connects this tool to a database and can see the details of various databases
"3" official website: https://www.navicat.com
Two: Install Navicat for MySQL
Run → next → Click "I agree" → Select the installation path → leave the default, next → choose whether to create desktop icons, suggest to leave the default values, click "Next" → install → complete.
Installation of the decompression mode of MySQL environment construction