#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. After Import: Insert “Use” Statement in Database
  44. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  45. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  46. How to use mysqli_query() in PHP?
  47. http://localhost/phpMyAdmin/ unable to connect
  48. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  49. How to log in to phpMyAdmin with WAMP, what is the username and password?
  50. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  51. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  52. Column count doesn’t match value count at row 1
  53. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  54. MySQL string replace
  55. Cannot add or update a child row: a foreign key constraint fails
  56. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  57. String concatenation in MySQL
  58. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  59. Cannot add or update a child row: a foreign key constraint fails
  60. MySQL Error “Operand should contain 1 column”
  61. How to use MySQL DECIMAL?
  62. Access denied for user ‘root@localhost’ (using password:NO)
  63. How do I use MySQL through XAMPP?
  64. Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (38)
  65. How to make MySQL table primary key auto increment with some prefix
  66. Access denied for user ‘root@localhost’ (using password:NO)
  67. MySQL ERROR 1290 (HY000) –secure-file-priv option
  68. MySQL error 2006: mysql server has gone away
  69. Which MySQL data type to use for storing boolean values
  70. sql query with multiple where statements
  71. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  72. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  73. Cannot delete or update a parent row: a foreign key constraint fails
  74. Cannot delete or update a parent row: a foreign key constraint fails
  75. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  76. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  77. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  78. MySQL server startup error ‘The server quit without updating PID file’
  79. Rename a column in MySQL
  80. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  81. Cannot delete or update a parent row: a foreign key constraint fails
  82. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  83. MySQL server startup error ‘The server quit without updating PID file’
  84. How do I restore a dump file from mysqldump?
  85. Syntax error due to using a reserved word as a table or column name in MySQL
  86. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  87. MySQL root password change
  88. Installation of MySQL for Visual Studio 1.2.8 failed
  89. Not unique table/alias
  90. How do I import an SQL file using the command line in MySQL?
  91. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  92. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  93. MySQL ERROR 1045 (28000): Access denied for user ‘bill’@’localhost’ (using password: YES)
  94. Your password does not satisfy the current policy requirements
  95. How do I quickly rename a MySQL database (change schema name)?
  96. What does SQL Select symbol || mean?
  97. Install mysql-python (Windows)
  98. MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user
  99. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  100. SQL – Update multiple records in one query

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)