MySQL 5.7.17 installation tutorial with solutions to the problem that the MySQL service cannot be started

For .net development, I am more familiar with Microsoft's SQL Server database, and I have used MySQL and Oracle before, but I am very familiar with them, so...

Preparation

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

Download mysql file

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

Install

The specific installation is as follows:

(1) Unzip mysql-5.7.17-winx64.zip to E:\MySQL\, open a command prompt and run it as an administrator, cd to E:\MySQL\mysql-5.7.17-winx64\bin

The command is: 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 the default service name of MySQL installed using the command under Windows system is mysql, and the default password is empty.

It can be clearly seen that the "MySQL service cannot be started" error occurs here.

The solution is as follows:

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

(4)Configure environment variables

1) Create a new MYSQL_HOME variable and set its value to: 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. You can also configure the bin directory under the MySQL installation directory to the path variable directly instead of creating a new MYSQL_HOME variable. Path : %MYSQL_HOME%\bin

(5) Enter MySQL

mysql -uroot -p , the password is empty by default. The display of “mysql>” indicates that you have entered MySQL.

(To set the password: mysqladmin -u root -p password password.

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

Next, you can use T-SQL statements to perform various operations on the database. The database can also be managed using database graphical management tools.

use

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

Wonderful topic sharing: Installation tutorials for different versions of MySQL Installation tutorials for MySQL 5.7 versions Installation tutorials for MySQL 5.6 versions

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.