Mysql 5.7.17 installation tutorial attached MySQL service cannot be started solution, 5.7.17mysql

Mysql 5.7.17 installation tutorial attached MySQL service cannot be started solution, 5.7.17mysql

For most. net development, Microsoft's SQL server database is quite familiar, and MySQL and Oracle have been used before, but they are all very familiar, so .....

Preparation Phase

Mysql official website https://dev.mysql.com/

Download mysql files

Note: The above download is the compressed package installation method,

Install

The specific installation is as follows:

(1)mysql-5.7.17-winx64.zip unzip to E: \ MySQL \ file, open the command prompt to run as administrator, cd to E: \ MySQL \ mysql-5.7.17-winx64 \ bin

Command: cd/d E: \ MySQL \ mysql-5.7.17-winx64 \ bin

(2) install MySQL

Mysqld install. After running the command, MySQL is installed successfully.

(3) Start the MySQL service.

Net start mysql will start the MySQL service. It is worth noting that MySQL installed with commands is named mysql by default in Windows, and the default password is blank.

The error "MySQL service cannot be started" appears clearly.

SolutionAs follows:

Download the ZIP file of mysql-5.6.35-winx64. copy the data file under mysql-5.6.35-winx64.zip to the mysql-5.7.17-winx64 and repeat Step 3.

(4) Configure Environment Variables

1), new MYSQL_HOME variable, and configure the value: E: \ MySQL \ mysql-5.7.17-winx64

MYSQL_HOME: E :\mysql \ mysql-5.7.17-winx64

2) edit the path system variable and add % MYSQL_HOME % \ bin to the path variable. Configure the path environment variable. Instead of creating the MYSQL_HOME variable, directly configure the bin in the MySQL installation directory to the path variable, Path: % MYSQL_HOME % \ bin

(5) Enter MySQL

Mysql-uroot-p. The password is empty by default. "Mysql>" indicates entering MySQL.

(Set the password: mysqladmin-u root-p password.

Exit. Remember to close the cmd window without exiting. You must enter exit to exit)

Then you can use T-SQL statements to perform various operations on the database. You can also use graphical database management tools to manage databases.

Use

Navicat for MySQL graphical interface tool connection, open, use ....

Highlights: mysql installation tutorials for different versions mysql5.7 installation tutorials for various versions mysql5.6 installation tutorials

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.