mysql5.7.17 installation tutorial with solutions to the problem that the MySQL service cannot be started (pictures and text)

This article mainly introduces the mysql 5.7.17 installation tutorial in detail, and shares with you the solution to the problem that the MySQL service cannot be started. It has certain reference value for those who are interested. You can refer to it

For .net development, Microsoft's sql server database is relatively familiar. As for MySQL and Oracle, they have been used before, but they are all very familiar, so...

Preparation phase

Download mysql file

## Note: The above download is a compressed package installation method.

Installation

The specific installation is as follows ：

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

command under 17-winx64\bin is:

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

(2)Install MySQL

mysqld install. MySQL is installed successfully after running the command.

(3) Start the MySQL service.

net start mysql will start the MySQL service. It is worth noting that the default service name of MySQL installed with the command is mysql under the Windows system, and the default password is empty.

#You can clearly see that the "MySQL service cannot be started" error appears here.

The solution is as follows:

First download the mysql-5.6.35-winx64 version zip file from the official website, and then put mysql-5.6.35 -Copy the entire data file under winx64.zip to mysql-5.7.17-winx64, and repeat step 3.

(4) Configure environment variables

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

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

2), edit path

system variable, and add %MYSQL_HOME%\bin to the path variable. Configure the path environment variable. You can also not create a new MYSQL_HOME variable, but 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>" is displayed to indicate entering MySQL.

(Method to set password: mysqladmin -u root -p password password.

Just exit. Remember that closing the cmd window directly will not exit. You must enter exit to exit)

Next, you can use T-SQL statements to perform various operations on the database. Database graphical management tools can also be used to manage the database.

Use

Navicat for MySQL graphical interface tool to connect, open, use....

The above is the detailed content of mysql5.7.17 installation tutorial with solutions to the problem that the MySQL service cannot be started (pictures and text). For more information, please follow other related articles on the PHP Chinese website!