Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?

Use the instructions for resetting the root password – but instead of resetting the root password, we’ll going to forcefully INSERT a record into the mysql.user table

In the init file, use this instead

INSERT INTO mysql.user (Host, User, Password) VALUES ('%', 'root', password('YOURPASSWORD'));
GRANT ALL ON *.* TO 'root'@'%' WITH GRANT OPTION;

Related Posts:

  1. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  2. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  3. String concatenation in MySQL
  4. MySQL root password change
  5. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  6. Create a new database with MySQL Workbench
  7. MySQL error code: 1175 during UPDATE in MySQL Workbench
  8. Cannot connect to Database server (mysql workbench)
  9. Is there a naming convention for MySQL?
  10. How to unblock with mysqladmin flush hosts
  11. Cannot add or update a child row: a foreign key constraint fails
  12. How to make MySQL table primary key auto increment with some prefix
  13. sql query with multiple where statements
  14. Cannot delete or update a parent row: a foreign key constraint fails
  15. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  16. Syntax error due to using a reserved word as a table or column name in MySQL
  17. Installation of MySQL for Visual Studio 1.2.8 failed
  18. How do I import an SQL file using the command line in MySQL?
  19. Select from multiple tables without a join?
  20. SQL Query Where Field DOES NOT Contain $x
  21. what does “/index.php?admin/admin_dashboard” in my url mean
  22. SQL – Update multiple records in one query
  23. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  24. MySQL: Invalid use of group function
  25. mysqladmin: connect to server at ‘localhost’ failed
  26. mysql update multiple columns with same now()
  27. Usage of MySQL’s “IF EXISTS”
  28. Generating a random & unique 8 character string using MySQL
  29. MySQL > Table doesn’t exist. But it does (or it should)
  30. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  31. mysql count duplicates
  32. How to create a foreign key in phpmyadmin
  33. Can’t create test file lower test start server mysql
  34. MySQL delete multiple rows in one query conditions unique to each row
  35. SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known
  36. CAST to DECIMAL in MySQL
  37. Error Code 1292 – Truncated incorrect DOUBLE value – Mysql
  38. MySql – HAVING vs WHERE 
  39. How to stop mysqld
  40. Failed to Connect to MySQL at localhost:3306 with user root
  41. How do you properly prepare a %LIKE% SQL statement?
  42. Optimize Multiple Taxonomy Term MySQL Query?
  43. WordPress MySQL & PHP Performance
  44. Using source control with WordPress
  45. SQL query to update post_date (one post = one single date & time)
  46. Updating User Meta with SQL Query
  47. wpdb prepare syntax
  48. How to run this SQL query of wp_terms database
  49. How to copy post titles to post slug in phpmyadmin
  50. If I consider changing my WordPress DB tables to InnoDB, will it have an effect on the way WordPress works?
  51. Database: Custom table: sprintf value for DateTime column
  52. What is the most secure way to set up the MySQL user in WPMU?
  53. WP_USE_EXT_MYSQL
  54. writing inner join in wpdb
  55. Distinction on meta value on pre_get_posts
  56. Unknown collation when I import a dump from an existing site into a development database?
  57. PHP script can’t connect to Database on port 3307
  58. MySQL Rank & $wpdb
  59. WordPress post_status is future, manually added
  60. How are multiple WordPress WPDB queries handled?
  61. How to translate this mySQL query to $wpdb query
  62. Regarding “Insert query error” in wordpress
  63. Separate DB by yearly archive of WordPress
  64. WordPress plugin overloading with tmp tables
  65. Site not responding error – taking long to load [closed]
  66. WordPress(wpdb class) and mysql stored procedures
  67. WordPress plugins for database queries
  68. Update MySQL query so that it functions again
  69. WordPress doesn’t display accents after migration
  70. Replace a character in all post titles and slugs
  71. Array Formation Issue
  72. Understanding custom php that reads from WP MYSQL
  73. Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
  74. $wpdb->get_var multiple queries in one database check
  75. List users with the most posts in the last 30 days
  76. Way to extract wordpress data from folder backup
  77. Data is not constatntly loading from custom wordpress table
  78. Mysql Server keeps crashing
  79. edit_user_created_user hook – using to update Groups
  80. How to search usermeta table
  81. How to add virtual column in wpdb get_result statement
  82. PHP Warning: mysqli_error(): Couldn’t fetch mysqli in
  83. I want to share local developement and staging DB — Is this very smart or very stupid?
  84. Extract all users along with yoast metadata description
  85. WordPress asks to install, but is already installed?
  86. Deleting a table row through query
  87. Improving performance of SQL sub-queries in WordPress
  88. An SQL query to find orphaned image attachments and their meta
  89. Weird characters displayed when importing WordPress MySQL db
  90. Simple SQL Query in wordpress
  91. optimise SQL wordpress call
  92. MYSQL Join on meta key value?
  93. WP_Query with LIKE returns strange query
  94. Need SQL query to find&replace image URL
  95. remove wordpress post links
  96. SQL get last entry of a specific gravity form
  97. mysqldump to a tar.gz
  98. Postgres equivalent to MySQL’s \G?
  99. How to check what port mysql is running on
  100. Where is my mysql log on OS X?

Leave a Comment

tech