[PhpMyAdmin MySQL] Fix Login Errors 1045 & 2054 [Part 2] – ALTER & UPDATE (8 steps solution)

Follow the 8 steps of ALTER and UPDATE for 2 solution clauses and relative clauses FLUSH PRIVILEGES and SELECT, use Unix Bash command CLI to run MySQL statements and fix PhpMyAdmin login error HY000/1045 (user access denied) or HY000/2054 (requested authentication method), which can effectively reset the MySQL authentication plugin and user password encryption. Follow the Steps as below: The syllabus of this tutorial (Part 2) – [ 00:33 ] Step 1 – Find MySQL Location – [ 00:43 ] Step 2 – Stop MySQL Server – [ 00:55 ] Step 3 – skip-grant-tables – [ 01:25 ] Step 4 – Access MySQL Commands – [ 02:15 ] Step 5 – Run MySQL Statements (SELECT) – [ 02:52 ] ---Solution 1 – ALTER – [ 03:45 ] ---Solution 2 – UPDATE & ALTER – [ 05:02 ] Step 6 – Exit all commands – [ 06:43 ] Step 7 – Restart MySQL Server – [ 06:58 ] Step 8 – Re-login PhpMyAdmin – [ 07:14 ] 無法登錄PhpMyAdmin-修復MySQL錯誤1045和2054 [第2部分]-使用ALTER＆UPDATE Full Tutorials: [PhpMyAdmin MySQL] Fix Login Errors 1045 & 2054 [Part 1] – Causes , Find & Stop    • [PhpMyAdmin MySQL] Fix Login Errors 1045 &...   [PhpMyAdmin MySQL] Fix Login Errors 1045 & 2054 [Part 2] – ALTER & UPDATE (8 steps solution)    • [PhpMyAdmin MySQL] Fix Login Errors 1045 &...   [PhpMyAdmin MySQL] Fix Login Errors 1045 & 2054 – [Part 3] – CREATE, GRANT & default-authentication-plugin    • Video   Relative videos URI: Upgrade the latest version of PHP to Mac 2020 Using Unix Bash    • Upgrade the latest version of PHP to Mac 2...   Bash Learning - Fix Error 403 404 & Unable To Connect Apache Localhost    • Bash Learning - Fix Error 403 404 & Unable...   Localhost Error 404 & 403 After Upgraded Mac Yosemite El Capitan    • Localhost Error 404 & 403 After Upgraded M...   The solution of unable to install latest version macOS    • The solution of unable to install latest v...   Hell Programming Solutions - PHP MySQL    • Hell Programming Solutions - PHP MySQL   ********* ******** ******** ******** [HellBuddy Talk - Life is simple but programming is not 生活簡單但編程不是] If you enjoyed this episode, please give HellBuddy a like and subscribe to the HellBuddySolutions channel on YouTube. Welcome to buy HellBuddy coffee and encourage me to make more videos. HellBuddy likes to share some experiences and solutions to provide some useful information about web development and programming. Life is simple, but coding is not. Better kindly to say hello to HellBuddy before leaving a comment or question. 1000X Thanks 如果您喜歡這一集，請給 HellBuddy 一個贊並訂閱 YouTube 上的 HellBuddySolutions 頻道。歡迎購買 HellBuddy 咖啡並鼓勵我製作更多視頻。 HellBuddy 喜歡分享一些經驗和解決方案，以提供一些關於 Web 開發和編程的有用信息。生活很簡單，但編程卻不容易。最好在發表評論或提問之前向 HellBuddy 打個友善招呼。 1000X Thanks [Subscribe & Follow & Support -訂閱 & 關注 & 支持] HellBuddySolutions:    / hellbuddysolutions   BuyHellBuddyCoffee: https://www.buymeacoffee.com/hellbuddy Facebook:   / hellbuddysolutions   Instagram:   / hellbuddysolutions   - @HellBuddySolutions Twitter:   / hellsolutions   - @HellSolutions [Report & Help - 報告和幫助] If you suspect someone infringes copyright of a HellBuddy video without permission or HellBuddy video was posted on a platform not owned by HellBuddy / HellBuddySolutions, please report it to HellBuddySolutions Channel YouTube or hellbuddy.com. 如果您懷疑有人未經許可盜用了 HellBuddy 視頻的版權，或者 HellBuddy 視頻發佈在不屬於 HellBuddy / HellBuddySolutions 的平台上，請向YouTube HellBuddySolutions 頻道 或 hellbuddy.com 報告。 [Channel’s Tags] #HellBuddy #HellBuddySolutions #Programming #Computer #WebDevelopment #WebsiteDesign #PHP #Javascript #JQuery #HTML#CSS #Python #Networking #Apache #Database #MySQL#UnixCommands #CLI