Accessdeniedforuser~~(usingpassword: YES) appears during MySQL login
AD |
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
Log in to MySQL and type mysgl uroot p; Enter directly
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
The Chinese side is fighting back! Meiguang is banned in the Chinese market, foreign media: Will Apple be the next one?
NextShould GPT exist?
Guess you like
-
Pinduoduo's "Trillion-Yuan Support" Plan: A Three-Year, 100 Billion Yuan Investment to Build a Multi-Win Business EcosystemDetail
2025-04-03 14:41:29 11
-
Huyu Xianxiang and AVIC Optoelectronics Institute Forge Strategic Partnership to Shape China's eVTOL Avionics LandscapeDetail
2025-04-02 18:39:02 1
-
Haier Smart Home's 8th Global R&D Innovation Awards: Illuminating Better Lives with Technology, Achieving User SatisfactionDetail
2025-04-02 15:57:33 21
-
Huawei's 2025 China Digital Power Partner Conference: Carbon-Neutral Path for China, Shared Value CreationDetail
2025-03-31 18:57:09 11
-
OPPO Think Tank: A New Paradigm for Chinese Enterprises' Globalization From Wusha Village to the Global High-End MarketDetail
2025-03-31 18:48:21 11
-
ICLR 2025: Chinese Universities and Companies Showcase AI Prowess with Numerous Accepted Papers; Stanford-HKUST Collaboration Achieves Perfect ScoreDetail
2025-03-31 14:54:45 11
-
Huawei HarmonyOS Smart Home Partner Summit: Deep Dive into Spatial Intelligence Transformation and Ecosystem Development StrategyDetail
2025-03-31 13:01:45 1
-
AI Large Models Drive Innovation in Humanoid Robots and Autonomous Driving: 2025 as a Key MilestoneDetail
2025-03-31 13:00:04 11
-
Eight Cities Pilot Credit Supervision Data Openness, Empowering Micro and Small Enterprises with Mobile Payment PlatformsDetail
2025-03-26 09:32:47 1
-
Xiaomi's "Just a Little Profit": The Deep Logic and Sustainability Behind its Low-Margin StrategyDetail
2025-03-25 15:07:32 21
- Detail
-
The Ninth Huawei ICT Competition China Challenge Finals Conclude Successfully: Kunpeng and Ascend Tracks Crown Their ChampionsDetail
2025-03-24 16:26:03 11
-
Ronshen Sugar Cube Refrigerator: The Official Product of the 2025 FIFA Club World Cup, Ushering in a New Era of Healthy Food PreservationDetail
2025-03-24 15:40:35 21
-
Zhihu Launches New Version of Zhihu Straight Answer: Deep Integration of AI and Community to Enhance Professionalism and CredibilityDetail
2025-03-24 14:04:38 1
-
China Construction Ninth Harmony (Zhongjian Jiuhe) and Huawei HarmonyOS Smart Home Deepen Strategic Partnership at AWE2025, Building a Green and Intelligent Future HomeDetail
2025-03-23 15:21:15 41
-
ZuoYeBang Books Leads the New Trend in Intelligent Education Publishing at Changsha Book FairDetail
2025-03-21 15:15:33 31
-
Tianyancha: Shielding Consumer Safety and Reshaping Business Trust with DataDetail
2025-03-21 08:47:58 1
-
Hisense at AWE2025: AI Empowerment, Leading the Transformation of Future Smart LivingDetail
2025-03-20 18:24:11 11
-
Haier TV Makes a Stunning Debut at AWE 2024: Zhiyuan AI Large Model and PureScene Care Screen Usher in a New Era of Smart HomesDetail
2025-03-20 15:17:20 1
-
China Power's Xin Yuan Zhi Chu (New Source Smart Storage): Open Energy Intelligence Computing Center Leads Intelligent Transformation of the Energy IndustryDetail
2025-03-20 15:15:39 1