MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)

I installed xampp,but when I tried to run it I got an error as thus:

Error

MySQL said: Documentation

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

Connection for controluser as defined in your configuration failed. phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

I tried to search on internet for a solution, but I still can’t fix my problem. I have already checked whether I used a password or not in config.inc.php file but i have not used any password.Also, when i try to access with a password, I still can’t solve this problem.

I hope anyone can help me. .thank you

Related Posts:

  1. Access denied for user ‘root@localhost’ (using password:NO)
  2. Access denied for user ‘root@localhost’ (using password:NO)
  3. MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user
  4. Setting up foreign keys in phpMyAdmin?
  5. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  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 solve “Error: MySQL shutdown unexpectedly”?
  9. How to create a foreign key in phpmyadmin
  10. importing a CSV into phpmyadmin
  11. What specific database privileges does WordPress need?
  12. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  13. How to copy post titles to post slug in phpmyadmin
  14. Error: MySQL shutdown unexpectedly. XAMPP local conf running WordPress
  15. How to do a MySQL dump from production site without using a search and replace script for local development?
  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. Error: MySQL shutdown unexpectedly [closed]
  21. Backing up and restoring multiple sites efficiently
  22. $wpdb to insert html form information
  23. Locally restoring a ManageWP full site backup
  24. Setting up WordPress Locally on WAMP for a new site (with one already)
  25. Getting Error Trying to Create Table
  26. Export Yoast Keywords from MySQL/phpMyAdmin
  27. Editing mysql tables/database with wordpress or other app/cms
  28. List users with the most posts in the last 30 days
  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. WordPress fails to install with “Can’t Select Database” Error (WAMPServer)
  35. Find locations of all featured images of draft posts via SQL
  36. SQL query to change custom field in WordPress database
  37. WordPress asks to install, but is already installed?
  38. An SQL query to find orphaned image attachments and their meta
  39. Check if a database is well installed
  40. cannot log in to the mysql server (wamp and wordpress)
  41. SQL command to export post_content from wp_posts using phpMyAdmin
  42. Need SQL query to find&replace image URL
  43. phpMyAdmin access denied for user ‘root’@’localhost’ (using password: NO)
  44. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  45. MySQL DROP all tables, ignoring foreign keys
  46. ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
  47. mysql is not recognised as an internal or external command,operable program or batch
  48. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)
  49. MySQL error code: 1175 during UPDATE in MySQL Workbench
  50. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  51. Data truncated for column?
  52. Access denied; you need (at least one of) the SUPER privilege(s) for this operation
  53. MySQL date format DD/MM/YYYY select query?
  54. MySQL Server on MAMP-Windows Will Not Start
  55. SQL statement not working – “Operand type clash: date is incompatible with int’
  56. Error: select command denied to user ‘‘@’‘ for table ‘‘
  57. #1214 – The used table type doesn’t support FULLTEXT indexes
  58. How can I rebuild indexes and update stats in MySQL innoDB?
  59. How to use the keyword ‘references’ in MySQL?
  60. select * from table where column = something or, when unavailable, column = something else
  61. Differences between utf8 and latin1
  62. There can be only one auto column
  63. What SQL Query to do a simple find and replace
  64. how to refresh wordpress permalink settings? (without admin panel)
  65. Ordering posts by day (not time) AND meta value
  66. Problems with DBDelta with FOREIGN key?
  67. How to delete posts that does not have a thumbnail?
  68. wpdb insert and boolean fields
  69. What are the issues associated with upgrading MySQL for WordPress?
  70. How to find meta entries with their posts missing via SQL?
  71. #1115 – Unknown character set: ‘utf8mb4’
  72. Slow wp-admin due to “SELECT DISTINCT post_mime_type FROM wp_posts WHERE post_type = ‘attachment'”
  73. Better ads plugin has 500.000 entries in wp_postmeta
  74. Which is better and faster ? WordPress Queries or SQL Query
  75. Changing root password in PHPMyAdmin for WordPress Database when going live
  76. Using WPDB->Insert()
  77. Active DB queries in WordPress?
  78. Changing MySQL password via WHM – does this affect WordPress?
  79. Run Username SQL Query from WordPress Child Theme Functions File
  80. MySQL query for taxonomy-meta
  81. Sql – Search with serialized Data / better database concept
  82. WordPress unescape text on mysql?
  83. Getting data from Mysql Table..confusing
  84. SQL Statement – Mass Delete Custom Post Types
  85. Ubuntu 12.04, Nginx and MySQL issue with WordPress Database
  86. latency problems with wordpress install (from SQL import)
  87. mysql – Delete keyword with link from wordpress post database
  88. Creating dynamic content and pages for 1000’s of locations
  89. Remove duplicate media entries from mysql database
  90. In a MySQL query, one of the columns in the LEFT JOIN returns “Unknown column”
  91. DB option update with wp-cli
  92. Login issue in WordPress
  93. 403 Forbidden home on localhost with nginx server
  94. WPDB delivers wrong results from complex queries
  95. #1115 – Unknown character set: ‘utf8mb4’
  96. Why can’t I connect to imported WP DB on local MAMP?
  97. Where other than wp-config can database access details be defined?
  98. Is there an equivalent of MySQL’s SHOW CREATE TABLE in Postgres?
  99. How can I show user’s privileges in MySQL?
  100. Changing host permissions for MySQL users

Leave a Comment