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.20-WINX64\BIN\MYSQLD--initialize-insecureps: Initialize the operation, The current operation creates a data folder under the Mysql-5.7.20-winx64 directory
4. Connect to the server
E:\softwareDevelop\mysql-5.7.20-winx64\bin\mysqld
5. Start the MySQL client and connect to the MySQL service
# Enter the executable directory CD C:\mysql-5.7.16-winx64\bin # connection MySQL server mysql-u root-p # Prompt Please enter the password, 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"-"to append the MySQL bin directory path to the variable value, and split" 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.16-winx64\bin
This way, when you start the service and connect later, you only need to:
12345 |
# 启动MySQL服务,在终端输入 mysqld # 连接MySQL服务,在终端输入: 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:
12345 |
# 制作MySQL的Windows服务,在终端执行此命令: "c:\mysql-5.7.16-winx64\bin\mysqld" --install # 移除MySQL的Windows服务,在终端执行此命令: "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:
12345 |
# 启动MySQL服务 net start mysql # 关闭MySQL服务 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