#1045 – Access denied for user ‘root’@’localhost’ (using password: YES)

The problem was I have 2 instances of Mysql installed and I didn’t know the password for both instances.Just check if port 80 is used by any of the programs. This is what I did

1.Quit Skype because it was using port 80.(Please check if port 80 is used by any other program).

2.Search for Mysql services in task manager and stop it.

3.Now delete all the related mysql files.Make sure you delete all the files.

4.Reinstall

Related Posts:

  1. How to do a MySQL dump from production site without using a search and replace script for local development?
  2. WordPress fails to install with “Can’t Select Database” Error (WAMPServer)
  3. cannot log in to the mysql server (wamp and wordpress)
  4. Setting up foreign keys in phpMyAdmin?
  5. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  6. MySQL Error #1133 – Can’t find any matching row in the user table
  7. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  8. How to create a foreign key in phpmyadmin
  9. importing a CSV into phpmyadmin
  10. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  11. Moving WordPress from MAMP to WAMP, can’t access pages
  12. Moving WordPress from MAMP to WAMP, can’t access pages
  13. What specific database privileges does WordPress need?
  14. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  15. How to copy post titles to post slug in phpmyadmin
  16. How to Create a Admin User for A WordPress Site via MySQL (PHPMyAdmin)?
  17. SQL error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’ [closed]
  18. Set meta_key and meta_value for all registered user in wordpress using sql query [closed]
  19. Can’t find my wordpress DB in phpmyadmin
  20. Backing up and restoring multiple sites efficiently
  21. $wpdb to insert html form information
  22. Locally restoring a ManageWP full site backup
  23. Setting up WordPress Locally on WAMP for a new site (with one already)
  24. Getting Error Trying to Create Table
  25. Export Yoast Keywords from MySQL/phpMyAdmin
  26. Editing mysql tables/database with wordpress or other app/cms
  27. List users with the most posts in the last 30 days
  28. Installing local to live WP into subdirectory
  29. Export SQL query based on custom field?
  30. How can I view my site directly from WordPress dashboard?
  31. Mysql Server keeps crashing
  32. How to bulk delete a certain part of all wordpress posts
  33. When I add metadata, metavalue length is added in to the value in some cases
  34. Find locations of all featured images of draft posts via SQL
  35. SQL query to change custom field in WordPress database
  36. 403 Forbidden home on localhost with nginx server
  37. An SQL query to find orphaned image attachments and their meta
  38. Why is local wordpress install calling live site executions?
  39. SQL command to export post_content from wp_posts using phpMyAdmin
  40. Need SQL query to find&replace image URL
  41. Why does the MySQL command line tool ignore the –port parameter?
  42. How to check what port mysql is running on
  43. How to use mysqli_query() in PHP?
  44. Access denied for user ‘root@localhost’ (using password:NO)
  45. How do I use MySQL through XAMPP?
  46. MySQL ERROR 1045 (28000): Access denied for user ‘bill’@’localhost’ (using password: YES)
  47. How do I quickly rename a MySQL database (change schema name)?
  48. What does SQL Select symbol || mean?
  49. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  50. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  51. phpMyAdmin: secret passphrase?
  52. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  53. ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
  54. MySQL error code: 1175 during UPDATE in MySQL Workbench
  55. java.sql.SQLException: Access denied for user ‘root’@’localhost’ (using password: YES)
  56. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  57. How to update a record using sequelize for node?
  58. Can’t open the mysql.plugin table. Please run mysql_upgrade to create it
  59. Convert MySQL to SQlite [closed]
  60. Convert partially non-numeric text into number in MySQL query
  61. MySql: is it possible to ‘SUM IF’ or to ‘COUNT IF’?
  62. MySQL Select Multiple VALUES
  63. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  64. How to unblock with mysqladmin flush hosts
  65. MySQL Error #1071 – Specified key was too long; max key length is 767 bytes
  66. How To have Dynamic SQL in MySQL Stored Procedure
  67. MySQL – UPDATE query with LIMIT
  68. What SQL Query to do a simple find and replace
  69. Scanning Database for malicious Data
  70. how to refresh wordpress permalink settings? (without admin panel)
  71. Ordering posts by day (not time) AND meta value
  72. wpdb->prepare function remove single quote for %s in SQL statment
  73. Is it useful to turn on MySQL query cache for performance
  74. Programmatically changing role information; editing role name and deleting
  75. Search and replace in post content
  76. How to add 2 hours to the wordpress time formed with current_time(“mysql”, false)?
  77. Update slug (URL) of pending posts via phpMyAdmin
  78. Mysql SELECT posts
  79. #1115 – Unknown character set: ‘utf8mb4’
  80. How to add a private user page populated from sql?
  81. Active DB queries in WordPress?
  82. Run Username SQL Query from WordPress Child Theme Functions File
  83. SQL syntax error. However, it works normally at phpmyadmin
  84. string literals in query
  85. Need to change all links in page content but not in post content
  86. Create pages from MySQL database
  87. Files on Localhost, Database on Server
  88. Exporting completed webiste for another server
  89. Using mysql to replace img src?
  90. mysqli_sql_exception: Unknown column ‘wp_’ in ‘field list’ PHP 8
  91. DB prefix not updating
  92. Store GravityForm data in phpmyadmin (mysql)
  93. wpdb insert into point column in db
  94. Search and Replace in Windows XAMPP site
  95. WPDB delivers wrong results from complex queries
  96. How to change link in all posts?
  97. Get data from 3rd table
  98. Why can’t I connect to imported WP DB on local MAMP?
  99. InnoDB: Error: log file ./ib_logfile0 is of different size
  100. Postgres equivalent to MySQL’s \G?

Leave a Comment