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 >>
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 >>
2023 Digital Expo | Fuji Film Shi Zemin: Magnetic tape storage will strongly support the construction and operation of green data centers
Global Network Technology Reporter Zheng XiangqiFrom May 26th to 28th, the 2023 China International Big Data Industry Expo (hereinafter referred to as the "Digital Expo") was held in Guiyang. Entering the Fuji Film booth for offline exhibitions at the Digital Expo, rows of magnetic tape storage products came into view...
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 >>
Silicon Valley Fur Swordsman, GPU Godfather Huang Renxun
Huang Renxun, born in Taiwan, China Province in 1963, obtained a master's degree in computer science from the University of California, Berkeley in 1987 and joined NVIDIA in the same year. NVIDIA is a globally renowned semiconductor company that specializes in computer chips based on graphics processors (GPUs), primarily used in applications such as games, PCs, and workstations...
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 >>
[Global Vision] Yadi will launch electric motorcycle in European market in cooperation with Porsche
[Global Network Technology Comprehensive Report] On May 30, it was reported that the VFF200 electric motorcycle jointly developed by Yadi and Porsche was about to be launched in the European market.From a power perspective, the VFF200 is equipped with a motor with a maximum power of 11 kW and a peak torque of 236 Nm...
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 >>