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 >>
The highest volume of 618 in history has opened, and JD Jingzao has created a high-quality and low-priced model with long-term utilitarianism
At present, the Chinese economy has entered a new stage of high-quality development and is moving towards the era of brand economy. Brand winning is the growth path of every enterprise and an important path for high-quality development of the Chinese economy...
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 >>
The 20th ChinaJoy Press Conference was held in Shanghai in 2023, with a comprehensive interpretation of the top ten highlights of the exhibition
5292023ChinaJoyChinaJoy728731 ChinaJoyChinaJoy 2023ChinaJoy 728731ChinaJoy500221910030%12BTOC20010BTOB3002BTOB35%ChinaJoyChinaJoyChinaJoyAIGCChatGPTMidjourneyAIAIChinaJoyAIAI2023 ChinaJoy ChinaJoyAIChinaJoyCDECChinaJoy AIGCAIGCAIGCAIGCAIGCCGDCAIChinaJoy BTOB5GWeb3.0GAME+:AI++AINPCAIAIAIAI ChinaJoyDeNAAMDRazorGoldMy CardSnapXsollaVTC MobileAppsFlyerChinaJoy25%BTOBChinaJoyChinaJoy ChinaJoy[if !supportLists] 822DOTA2CSGOMA332IPIP:[if !supportLists] ChinaJoyUP4399[if !supportLists] R9000XY700IT990PROSSD[if !supportLists] ChinaJoy300 ChinaJoyCDECCGDC42023CDEC1 + 4 + NChinaJoy AIGCChinaJoy Web32023CGDC7AIIndieAzureSNKOminiverseScopelyJohn YinCD PROJEKT RED Mikoaj SzwedMundfish CEO Robert BagratuniKLab China CEO 3002023ChinaJoy ChinaJoy2023 ChinaJoy2023ChinaJoy ChinaJoyBTOCVR/ARBTOBIPB BSnapTAPTAPR9000XSnap ARGame for GoodIndieBC ChinaJoy CosplayChinaJoy ChinaJoyDeNAPICOCPICO VR ChinaJoyCJ Go ChinaJoyChinaJoyChinaJoyChinaJoyCJ GoZChinaJoy - CJ GoCJ GoChinaJoyARPKCJ GoChinaJoyChinaJoyChinaJoy/INDIE GAME ChinaJoyChinaJoy x Game Connection INDIE GAMEINDIE GAME ChinaJoyChinaJoyChinaJoyChinaJoyShowgirlChinaJoyChinaJoy...
Tech >>
Cainiao International Express 618 Enlarges Invitation for Free "Upgrade" of Logistics in 15 European and American Countries, Another 10 Days Faster
Global Network Technology Comprehensive Report: The 618 major promotion pre-sales and investment promotion at home and abroad have been launched, and international express logistics support needs to keep up.Today, Cainiao International Express has launched multiple logistics upgrade measures with a focus on improving logistics efficiency and service experience, creating a "fast, cost-effective" cross-border package service...
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 >>
Qinghai's First Domestic Waste Power Plant: Transforming Waste into Energy
As the first household waste power plant in Qinghai Province, Xining Municipal Household Waste Incineration Power Plant has a daily garbage treatment capacity of 3000 tons and an annual power generation capacity of 451 million kilowatt hours. It can achieve "harmless, reduced, and resourceful" treatment of household waste, playing a positive role in promoting pollution reduction, energy conservation, and environmental improvement...
Tech >>
Inventory of used mobile phones to commemorate the passing years
I used to be very passionate about mobile phones, and I usually change my phone every year or at most two years. As I age, I gradually lose that passion and no longer chase performance scores because I no longer play games...
Tech >>
Deep reinforcement learning for task offloading in unmanned aerial vehicle assisted intelligent farm network
Wen | Zhang BucaiEditor | Zhang Bucai1. IntroductionAs wireless network communication becomes increasingly powerful,It has become the norm for a scholar to know the world's affairs without going outDrones and artificial intelligence are becoming increasingly important in agriculture,Automatically monitor farmland to improve agricultural landscape and perform numerous image classification tasks to prevent damage to the farm in the event of fires or floods...
Tech >>