Accessdeniedforuser~~(usingpassword: YES) appears during MySQL login

Tech 2023-05-30 20:21:14 Source: Network

Windows~~~Access denied foruser 'root' @ 'localhost' (usingpassword: YES) appears during MySQL login and changes the MySQL passwordcatalogueSuitable for installing MySQL on WindowsSolution for denying access to root usersSolution:Restart MySQL serverIf the above still doesn't work1 Uninstall all MYSQL related applications on the computer2 Delete all MYSQL configuration files3 Then install or perform relevant configurationsSuitable for Linux protocol socket configuration mysglMySQL Technical Forum: MySQL:: MySQL ForumsSuitable for installing MySQL on WindowsSolution for denying access to root users1045 (28000) : 'root @localhost' (: YES) Firstly, analyze this English: ERROR1045 (28000): Accessdeniedforuserroot @ 'localhost' (usingpassword: YES);There are two parsing places: Accessdenied and usingpassword; The combination is as follows:DAccessdenied (access denied: username and address)Quisingpassword: NOOusingpassword: YESReason analysis: The reasons for the occurrence of accessed may be as follows:1) MySQL server stopped2) The port number of the service3) MySQL configuration file error - files such as my ini4) Root user does not use a password, but access is denied (password is not used, local access is denied 5) Root user uses the correct password, but access is denied (password is used, local access is denied)Omyini configuration file path issueOmyini : MySQLRestart MySQL server: net start mysql:(3306/3307)myin: portX(:port 3306)Reason three solution: The myini file mistakenly entered invalid content, and I don't know where to go Copy and replace the file Someone has already explained and annotated the myin fileReason 4 Solution: The root user's password is correct, but they refuse to log in The main content of this blog article is [Solution]@Problem with the content of the myini configuration file1myiniMySglcatalogue@Problem with the content of my ini configuration fileThe reasons for the occurrence of usingpassword are as follows:1: Do not type password:2: Password typed:SolutionMySQLcataloguemyini:Add skip grant tables after mysqldl (using setpasswordfor to set the password is invalid, and there is no need to type a password for subsequent login)Step above: Minimize operations as much as possible(Refers to adding skip grant tables)Note: After adding, you can enter the MySQL service without entering a password!!!Starting MySQL Server1 Stop running netstopmysql2 Start and run netstartmysqlLog in to MySQL and type mysgl uroot p; Enter directlyAt this point, you want to type setpasswordforroot@localhost '=password (123456'; this command is invalid!!!Because adding skip grant tables to my ini file eliminates the need to type a password from now onMySQLmyiniskip-grant-tablesRestart MySQL server:Netstopmysglnetstartmysg!Step 1:Open the cmd command line and type mysal uroot p twice to enter MySQLStep 2:Simply delete or annotate skip grant tables from the myini configuration fileStep 3:Set password again: setpasswordforroot@localhost '=password (123456)Step 4:Restart MySQL serviceStep 5:validateSuccessfully set the MySQL password.Skip name resolve # Prohibits MySQL from performing DNS resolution on external connections

Windows~~~Access denied foruser 'root' @ 'localhost' (usingpassword: YES) appears during MySQL login and changes the MySQL password

catalogue

Suitable for installing MySQL on Windows

Solution for denying access to root users

Solution:

Restart MySQL server

If the above still doesn't work

1 Uninstall all MYSQL related applications on the computer

2 Delete all MYSQL configuration files

3 Then install or perform relevant configurations

Suitable for Linux protocol socket configuration mysgl

MySQL Technical Forum: MySQL:: MySQL Forums

Suitable for installing MySQL on Windows

Solution for denying access to root users1045 (28000) : 'root @localhost' (: YES)

Firstly, analyze this English: ERROR1045 (28000): Accessdeniedforuserroot @ 'localhost' (usingpassword: YES);

There are two parsing places: Accessdenied and usingpassword; The combination is as follows:

DAccessdenied (access denied: username and address)

Quisingpassword: NO

Ousingpassword: YES

Reason analysis: The reasons for the occurrence of accessed may be as follows:

1) MySQL server stopped

2) The port number of the service

3) MySQL configuration file error - files such as my ini

4) Root user does not use a password, but access is denied (password is not used, local access is denied 5) Root user uses the correct password, but access is denied (password is used, local access is denied)

Omyini configuration file path issue

Omyini : MySQLRestart MySQL server: net start mysql:(3306/3307)myin: portX(:port 3306)

Reason three solution: The myini file mistakenly entered invalid content, and I don't know where to go Copy and replace the file Someone has already explained and annotated the myin file

Reason 4 Solution: The root user's password is correct, but they refuse to log in The main content of this blog article is [Solution]

@Problem with the content of the myini configuration file

1myiniMySglcatalogue

@Problem with the content of my ini configuration file

The reasons for the occurrence of usingpassword are as follows:

1: Do not type password:

2: Password typed:

Solution

MySQLcataloguemyini:

Add skip grant tables after mysqldl (using setpasswordfor to set the password is invalid, and there is no need to type a password for subsequent login)

Step above: Minimize operations as much as possible

(Refers to adding skip grant tables)

Note: After adding, you can enter the MySQL service without entering a password!!!

Starting MySQL Server

1 Stop running netstopmysql

2 Start and run netstartmysql

At this point, you want to type setpasswordforroot@localhost '=password (123456'; this command is invalid!!!

Because adding skip grant tables to my ini file eliminates the need to type a password from now on

MySQLmyiniskip-grant-tablesRestart MySQL server:Netstopmysglnetstartmysg!

Step 1:Open the cmd command line and type mysal uroot p twice to enter MySQL

Step 2:Simply delete or annotate skip grant tables from the myini configuration file

Step 3:Set password again: setpasswordforroot@localhost '=password (123456)

Step 4:Restart MySQL service

Step 5:validate

Successfully set the MySQL password.

Skip name resolve # Prohibits MySQL from performing DNS resolution on external connections. Using this option can eliminate the need for MySQL to perform DNS resolution. However, it should be noted that if this option is enabled, all remote host connection authorization must use IP address method, otherwise MySQL will not be able to process connection requests properly!

***If the above still doesn't work

If the above still doesn't work,

1 Uninstall all MYSQL related applications on the computer

2 Delete all MYSQL configuration files

3. Then install or perform relevant configurations

The above methods still do not work, we can only ask you to replace your computer or reinstall the system!!!

Suitable for Linux protocol socket configuration mysq

And the socket connection between the client and server needs to be on the same machine - I'm not sure how to configure skipnameresolve

Disclaimer: The content of this article is sourced from the internet. The copyright of the text, images, and other materials belongs to the original author. The platform reprints the materials for the purpose of conveying more information. The content of the article is for reference and learning only, and should not be used for commercial purposes. If it infringes on your legitimate rights and interests, please contact us promptly and we will handle it as soon as possible! We respect copyright and are committed to protecting it. Thank you for sharing.(Email:[email protected])

Mobile advertising space rental

Tag: Accessdeniedforuser usingpassword YES appears during MySQL login