Accessdeniedforuser~~(usingpassword: YES) appears during MySQL login
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...
Tech >>
Apple phone users are aware that many people claim to be electrocuted or even injured by the charging head
Recently, several Little Red Book bloggers shared their experience of being charged by an Apple charger, which has sparked a heated discussion among netizens. # Can an Apple charger stop charging me? # has become a hot topic...
Tech >>
Why are more and more regular users no longer considering adding one when changing their phones?
I don't know if you have noticed that in recent years, fewer and fewer people have chosen to use OnePlus phones. A few years ago, although Yijia's popularity was not high, many loyal Yijia fans could still be seen online...
Tech >>
AppleWatch users do not have two identical rainbows on their wrists
World Rainbow Day has just passed, and Comrade Pride Month is approaching. Apple's new AppleWatchPride rainbow strap, as well as a series of wallpapers and dials, has arrived as scheduled...
Tech >>
Ranking of users of various mobile operating systems: iOS 1.7 billion>MIUI 600 million>Hongmeng 320 million
On May 24th, Xiaomi officially released its first quarter financial report for 2023. Data shows that in the first quarter of this year, Xiaomi's revenue was 59...
Tech >>
Why are more and more Honor old users no longer considering Honor when switching to a new phone
Honor used to be a popular brand among young people, but now more and more old users are choosing other brands instead of Honor when purchasing new phones. So, why did this happen? I always remember the following three points...
Tech >>
The WACHMAX-A90 smartwatch with diverse functions and usage can meet the different needs of users
With the development of technology, smart watches have become an indispensable part of people's lives. Among many smart watch brands, the WACHMAX-A90 from Langbang can be said to be a versatile and versatile smart watch...
Tech >>
Not bragging? Huawei P60 users are rescued through satellite communication, and once they are saved, they will continue for a lifetime
I believe that the vast majority of users' mobile phones currently do not support satellite communication. To be blunt, even with this feature, many people will only treat it as a novelty and give it a try, because in daily life, we will not encounter such extreme situations, and we must use satellite to get in touch with the outside world...
Tech >>
The total number of internet users in Henan Province has reached 133 million, ranking fourth in the country
On May 17th, the Information Office of the Henan Provincial People's Government held a press conference to introduce and interpret the specific situation of the 2022 Henan Internet Development Report and the development of the Henan Internet industry, and to answer questions from reporters.On site of the press conference (photo taken by Shao Qi from CCTV)At the press conference, Chang Jiang, a member of the Party Group and Deputy Director of the Henan Provincial Communications Management Bureau, introduced that the "2022 Henan Provincial Internet Development Report" is divided into 5 parts and 11 chapters, systematically summarizing the basic situation and main achievements of the development of the Internet industry in Henan Province in 2022...
Tech >>
Founder of ofo Xiaohuangche, Dai Wei, went to the United States to start a business: registered users drink coffee for free, with an estimated value of $200 million
On May 16th, Tech Planet reported that according to Phoenix Technology, the founder of OFO Little Yellow Car, Dai Wei, has once again started his business, choosing the United States. According to media reports in December last year, the company is seeking new financing with a valuation of $200 million...
Tech >>
The Fall of "Navigation Brother": Why Was It Abandoned by Users After Occupying 77% of the Market Share and Overcoming Gaode
introductionIn modern society, with the development of the economy and the improvement of people's living standards, cars have entered thousands of households and become an indispensable and important part of everyone's lives. For drivers, having an efficient and practical navigation software has become a necessity for daily travel...
Tech >>
How can San Francisco gradually become a paradise for drug users?
When it comes to San Francisco in the United States, what do you think?'Silicon Valley' may be the first word that pops into people's minds, and countless well-known technology giants, such asAppleGoogleTwitterFacebookThey are all located here.In the imagination of many international students who aspire to work in North American technology giants, Silicon Valley should be filled with energetic technical personnel, each with an expensive cup of cold squeezed juice, eagerly leading the digital revolution in the office...
Tech >>