MySQL 9.0: New Features Breakdown and Practical Applications
MySQL 9.0: New Features Breakdown and Practical ApplicationsMySQL 9...
Tech >>
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 >>