Shulou(Shulou.com)06/01 Report--

1. Extract the downloaded file to the custom location 2. Under the decompressed directory, create a new my.ini file as follows:

[mysql]

Default-character-set=utf8

[mysqld]

Port=3306

Basedir= "C:\ mq-install\ mysql-5.7.28-winx64"

Datadir= "C:\ mq-install\ mysql-5.7.28-winx64\ data"

Max_connections=200

Character-set-server=utf8

Default-storage-engine=INNODB

3. Configure environment variables as follows:

This computer (win10)-> Properties-> Advanced system Settings-> Environment variables-> Path, add "Custom location\ bin", such as D:\ Program Files\ mysql-5.7.27-winx64\ bin

4. Use the administrator to open cmd and enter mysqld install

Then enter net start mysql

There's a-"

The MySQL service is starting. .

The MySQL service could not be started.

The service did not report any errors. Please type NET HELPMSG 3534 for more help.

When you enter net start mysql to start the Mysql service, it shows that the MySQL service is starting. . The MySQL service could not be started.

"- this mistake.

Enter mysqld-console to view the specific error information on the console.

Record your own appearance [ERROR]

Enter the command mysqld-initialize

Type mysqld-console to see what error message is reported

I created the data folder myself. Delete the data folder and then comment on the datadir under the my.init file.

Enter mysqld-- initialize again after deletion

And start net start mysql

The MySQL service is starting.

The MySQL service has started successfully.

During this time, I suspect that there may be a problem with the extracted files, so delete the extracted files and then extract them, but at this time, there is already a residue in the previous installation, so we need to

The presence of already means that it has been left.

Reopen cmd as an administrator

Enter the command sc query mysql to view the service named mysql

Enter the command sc delete mysql to delete the mysql

Execute mysqld-- install again and you can succeed.

Log in after successful configuration

Enter mysql-uroot-p

Because the password will be randomly generated after mysqld-- initialize, you cannot log in here.

Add skip-grant-tables at the end of the my.ini file

Then restart mysql

Stop before starting

Net start mysql

Enter mysql-uroot-p

Change the password after entering:

Use mysql

Update user set password=password ('12345') where user='root'

Note: my mysql is 5.7.28. If I execute the above update, I will get an error.

ERROR 1054 (42S22) Unknown column 'password' in' field list'

The reason for the error is that the password field is no longer available in the mysql database in version 5.7, and the password field has been changed to authentication_string.

Update mysql.user set authentication_string=password ('') where user=''; # password changed successfully

Effective immediately: flush privileges

Quit

After exiting, annotate the skip-grant-tables in my.ini and restart mysql, and log in with your password.

Any statement entered by MySQL prompts the You must reset your password using ALTER USER solution

After installing and configuring MySQL-5.7.22 on Win10, changing the password for the first time and logging in, the prompt "You must reset your password using ALTER USER..." appears no matter what statement you enter. The solution to the error statement is as follows

SET PASSWORD = PASSWORD ('new password')

ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER

FLUSH PRIVILEGES

After quit, log in with the new password and you can operate it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.