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 >>
The Heart of Molecules Xu Jinbo's speech at Zhongguancun Forum: AI protein design leads to new changes in biobased economy
On May 30, it was reported that at the Zhongguancun Forum "Scientific Research Forum Driven by Artificial Intelligence", Xu Jinbo, a well-known computational biologist, founder of Molecular Heart and outstanding visiting professor of the Institute of Intelligent Industry (AIR) of Tsinghua University, said that AI biology has become a new core field of global science and technology integration and innovation. Driven by emerging technologies such as AI protein design technology, the field of biotechnology is undergoing disruptive changes, The AI biological model will accelerate this process...
Tech >>
Who could have imagined that these companies that shook the world would do so behind the scenes! Netizen: Unbelievable
The protagonist of today's article is Elon Reeve Musk. Yes, you know Tesla's CEO Musk...
Tech >>
Zhouming Technology Announces Cooperation with Blue Cursor to Explore the Metaverse Industry
On May 29th, at the Zhongguancun Forum in Beijing, Zhouming Technology and Blue Cursor Group officially reached a strategic cooperation relationship in the metaverse field. Both parties will cooperate in fields such as metaverse marketing, XR virtual technology, and digital asset construction based on their respective technological, talent, and resource advantages...
Tech >>
Amazon Cloud Technology: Data Centers are Moving towards Energy Conservation and Efficiency Improvement
With the accelerated development of the digital economy, computing power has become one of the important social productivity, and the data center has become the infrastructure for the development of Digital transformation. As the data center market expands, industry energy consumption is gradually increasing...
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 >>
Nenglian Smart Electric Appears at TheEVIS2023, Exporting Charging Service Solutions to the World
On May 29th, Nenglian Smart Electric participated in the 2023 Abu Dhabi New Energy Electric Vehicle Exhibition (EVIS 2023), which is also one of the most influential new energy electric vehicle professional exhibitions in the Middle East region and even globally. As a representative of China's new energy charging service enterprise, Nenglian Intelligent Power showcases its charging service solutions to the world...
Tech >>
What if the 4S store quotes 70000 yuan and the insurance company sets a loss of 7000 yuan?
At the end of April, Mr. Lv, who was running a ride on the internet in Hangzhou, had an accident...
Tech >>
Don't buy 618 phones indiscriminately. Choosing these four models around 2500 is very suitable, with strong features and a significant price reduction
If you like it, you can click on the word "Follow" above. We will provide you with more valuable content in the future...
Tech >>
666 self media are banned for life, we must take this as a warning!
internetinternetinternetinternetinternetinternetEven more so!internetinternetCry the injustice!internet21internetinternet21internetinternetBeyond the law!internetExecuted!!!...
Tech >>
Study on the metabolic potential of six ancient bacterial lineages in deep-sea sediments using MAGs macrogene assembly method
//CR(MAGs)6(Lokiarchaeota, Thorarchaeota, Heimdallarchaeota, Bathyarcheota, ThermoplasmatalesHadesarchaea)31magLokiarchaeotaBathyarchaeotamagCRLokiarchaeotaLokiarchaeotaWood-LjungdahlcomarchaeotaarchaeotaCR31(MAGs)6(Lokiarchaeota, Thorarchaeota, Heimdallarchaeota, Bathyarcheota, ThermoplasmatalesHadesarchaea)LokiarchaeotaBathyarchaeotaMAGsLokiarchaeotaDNAIQ-Tree16(L2L3L4L5L6L14L15L16L18L22L24S3S8S10S17S19)(VT + F + R10) 1000HMMsearchHMMMAGsBlastKoalKEGGUSEARCH-ublastMEROPSbinKEGG,CR Lokiarchaeota(rG)pH81mmCRU1378U1379CR Lokiarchaeota:G0rRCHNOSZ(4C)Qr16S rRNACR5,12616S rRNA(3125%)archaeotaLokiarchaeota531mag11(60%5%)magNCBI (nr)MAG(60-75%)CR_1215%Heimdallarchaeota16MAGs6Lokiarchaeota, Thorarchaeota, Heimdallarchaeota, Bathyarcheota, ThermoplasmatalesHadesarchaeaCRMAGs(ESPs)espCRHeimdallarchaeotaLokiarchaeota MAGs (CR_06, CR_11)ESPsCRarchaeota, HadesarchaeotaThermoplasmata MAGsespMCR(mcrABCDG)CRMCRHMMmag(AssA)(BssA)C-CLokiarchaeota CR_06Lokiarchaeota CR_06BCRBBzd4(BzdONPQ)BCRiCR_06BCR(LokiarchaeotaBathyarchaeotaArchaeoglobus)BCRPQATP/ATP[4Fe-4S]a(ON)aaCR_06BCR4(CR_06-contig-100_3495)CR_06 MAG(= 1110)> 200xCR_ Lokiarchaeota (CR_06)CRAsgardAsgard MAGs(CR_06, 07, 08, 1112)CO2H2OrG '(rG ' = 196.3 [kJ/mol])CR(86%)Lokiarchaetoa():(a)CO2H2O(rG ' =1206...
Tech >>
It's not just cloud costs that are out of control: burning 450 million yuan a year for observability
InfoQ Architecture HeadlinesMay 2023-2915:00 Published in HeilongjiangOrganize | Chu Xingjuan, Nuclear ColaWhich company spent $65 million on Datadog in 2022? "Datadog recently revealed at a financial meeting that a customer made a one-time prepayment of up to $65 million, which instantly sparked industry attention: which company is so generous? Can you observe how suppliers make money?Datadog is the main force of observability, with a financing listing in 2019 and a current market value of $28 billion. The company's revenue in 2022 was $1...
Tech >>