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 >>
"Huawei Genius Youth" got Robin Lee's investment, and its valuation was revealed to have exceeded the unicorn
On May 30, PinPlay reported that according to Tianyan App, the industrial and commercial change of Shanghai Zhiyuan Xinchuang Technology Co., Ltd...
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 >>
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 >>
The total revenue of China's science fiction industry in 2022 reached 87.75 billion yuan
On May 30th, the "2023 China Science Fiction Industry Report" was officially released at the 2023 China Science Fiction Conference. The report shows that in 2022, the total revenue of China's science fiction industry reached 87...
Tech >>
Cloud data business ushers in a period of performance return, and Century Huatong actively expands into emerging markets such as AI
On May 29th, Century Huatong mentioned in its announcement on responding to the inquiry letter on the annual report of the Shenzhen Stock Exchange that the company's Shenzhen data center project is expected to officially enter the operation period of the first batch of delivered cabinets in the second half of 2023 and generate operating income. It is expected that the net profit will turn positive in 2025; The Shanghai Data Center project has gradually generated operating revenue by delivering cabinets...
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 >>
Scientists in China Achieve Quantum Key Distribution in Thousand Kilometers of Relay Free Fiber Optics
Hefei, May 29 (Reporter Xu Jing) -- Pan Jianwei and Zhang Qiang of the University of Science and Technology of China, together with Wang Xiangbin of Tsinghua University, Liu Yang of Jinan Institute of Quantum Technology, You Lixing and Zhang Weijun of the Shanghai Institute of Microsystems and Information Technology of the Chinese Academy of Sciences, have cooperated to achieve 1002km point-to-point long-distance quantum key distribution in optical fibers by developing technologies such as low crosstalk phase reference signal control and extremely low noise single photon detectors, Not only has it set a world record for fiber optic relay free quantum key distribution distance, but it also provides a solution for high-speed backbone links in intercity quantum communication. The relevant research results were recently published in the international academic journal "Physical Review Letters"...
Tech >>
Fully empowering "gaming+AI" to solve industry pain points
On May 29th, gaming stocks collectively surged, with Shunwang Technology and Caesar Culture raising their limit, while Shenzhou Taiyue, Giant Network and others surged by over 8%. NVIDIA announced on the same day that it will provide customized AI model OEM services, which developers can use to build and deploy customized voice, dialogue, and animation AI models in their software and games...
Tech >>
Focusing on major application directions and accelerating the development of third-generation semiconductors
Recently, at the 2023 Zhongguancun Forum "Beijing (International) Third Generation Semiconductor Innovation and Development Forum", Xiang Libin, a member of the Party Group and Vice Minister of the Ministry of Science and Technology, stated that third-generation semiconductors represented by silicon carbide and gallium nitride have excellent performance and have a huge market in fields such as new energy vehicles, information communication, and smart grids.Building an Industrial EcologyXiang Libin stated that the "13th Five Year Plan" period has basically solved the "availability" problem of China's third-generation semiconductor products and related equipment, and the "14th Five Year Plan" period will focus on solving the problems of "usability, usability" and sustainable innovation ability...
Tech >>