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

Below I will give you a brief talk about how to solve NET HELPMSG 353 when configuring mysql decompression version. Have you known about similar topics before? Interested words to see this article together, I believe that after reading the configuration mysql decompression version appears NET HELPMSG 353 how to solve the number of people to help it.

1. Extract downloaded files to a custom location

2. Under the decompression directory, create a new my.ini file with the following contents:

[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. Open cmd with admin Enter mysqld install

Then type net start mysql

It appears-----

MySQL service is starting...

MySQL service failed to start.

The service did not report any errors. Type HELNET PMSG 3534 for more help.

Enter net start mysql to start MySQL service, it shows MySQL service is starting…. MySQL service failed to start.

- -------

Enter mysqld -console to view specific error messages on the console

[ERROR] is recorded.

Enter the command mysqld -initialize

Enter mysqld -console to see what error message is reported

I created the data folder myself, so delete the data folder and comment on datadir under my.init file.

Delete and type mysqld again--initialize

Start net mysql

MySQL service is starting…

MySQL service started successfully.

Here I suspect that there may be problems with the files after decompression, so delete the decompressed files and decompress them, but at this time the previous installation has been residual, so you need to

The presence of already means that it has been left behind

Open cmd again as administrator

Enter sc query mysql to view a service named mysql

Enter sc delete mysql to delete the mysql

Then execute mysqld --install to succeed

Login after successful configuration

Enter mysql -uroot -p

Here, because mysqld --initialize will generate a password randomly, so login is not possible.

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

Then restart MySQL.

Stop then start

net start mysql

Enter mysql -uroot -p

Change password after entering:

use mysql;

update user set password=password('12345') where user='root';

Note: My mysql is 5.7.28, if you execute the update above, you will report an error.

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

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

update mysql.user set authentication_string=password ('') where user =''; #Modify password successfully

immediate effect: flush privileges;

quit

After exiting, add comments to skip-grant-tables in my.ini, restart mysql, and log in with password.

MySQL You must reset your password using ALTER USER

MySQL-5.7.22 is installed and configured on Win10. After modifying the first password and logging in, no matter what statement you enter, the prompt "You must reset your password using ALTER USER..." appears. "The solution 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 again and you can operate.

We feel that the configuration mysql decompression version appeared NET HELPMSG 353 how to solve this article, whether there is harvest. If you want to know more about it, you can continue to pay attention to our industry information section.

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.