mysql said: Cannot connect: invalid settings. xampp

The above code fixed problem for most of the ppl but I still could not login. Finally I found this (line#9 in the above code needs to be changed)

$cfg['Servers'][$i]['AllowNoPassword'] = true;   <--- change this
$cfg['Servers'][$i]['AllowNoPassword'] = false;  <--- to this fixed the problem.

Note: there are other areas in localhost where you have to change the password manually. For example in “CD Collection” example. The password is hard coded there rather than picking it up from config.inc.php.

Related Posts:

  1. http://localhost/phpMyAdmin/ unable to connect
  2. phpMyAdmin access denied for user ‘root’@’localhost’ (using password: NO)
  3. phpMyAdmin Error: The mbstring extension is missing. Please check your PHP configuration
  4. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)
  5. “Connection for controluser as defined in your configuration failed” with phpMyAdmin in XAMPP
  6. phpMyAdmin ERROR: mysqli_real_connect(): (HY000/1045): Access denied for user ‘pma’@’localhost’ (using password: NO)
  7. This table does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available
  8. Delete a database in phpMyAdmin
  9. PHPMyAdmin Default login password
  10. wamp server mysql user id and password
  11. phpmyadmin “Not Found” after install on Apache, Ubuntu
  12. Delete a database in phpMyAdmin
  13. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  14. Making someone a WordPress administrator using PhpMyAdmin
  15. Why am I unable to login to Dashboard after adding myself to admin via phpMyAdmin?
  16. Resetting menu_order to 0 for posts in PHPmyAdmin?
  17. phpMyAdmin displays error when importing database 2
  18. oembed_cache SPAM problem [closed]
  19. Delete all pages (thousands) except a few by their IDs
  20. Recovering a wordpress blog that got corrupted
  21. Importing posts content from csv
  22. duplicate wordpress site on same bdd
  23. I can not access my local PhpMyAdmin control panel
  24. wp_login.php redirects to old domain
  25. Check if a database is well installed
  26. Strings from database are not shown correctly
  27. How to change wordpress adminstrator user ‘s ID from 1 to 0?
  28. WordPress database defragmentation
  29. Cannot login to WordPress admin after update
  30. XAMPP Port 80 in use by “Unable to open process” with PID 4
  31. Cannot access to localhost/xampp/index.php
  32. Localhost is not working
  33. Xampp MySQL not starting – “Attempting to start MySQL service…”
  34. XAMPP Apache won’t start
  35. How to create a foreign key in phpmyadmin
  36. MySQL Daemon Failed to Start – centos 6
  37. Auto increment in phpmyadmin
  38. How do I find what causes a blank white screen in WordPress?
  39. Moving WordPress from MAMP to WAMP, can’t access pages
  40. WAMP vs XAMPP pros/cons – for running a local testing server [closed]
  41. Redirecting to old domain after migration
  42. WP Asking for FTP Credentials with XAMPP Localhost
  43. PHP function showing wrong time in WordPress
  44. the_post_thumbnail scaling not hard cropping
  45. What specific database privileges does WordPress need?
  46. POSTS list in WordPress by views
  47. How to copy post titles to post slug in phpmyadmin
  48. Delete all post meta except featured image
  49. Set wp-content folder to Dropbox folder
  50. Query to change custom post type with specific category
  51. Why can’t I swap a DB in a WP install? [closed]
  52. Why isn’t my imported database showing up? install.php pops up and adds new tables to the database
  53. Duplicate posts when posting nulls in records in phpMyAdmin [closed]
  54. Double domain name in category URL-s
  55. Multisite on localhost using xampp
  56. Query to import data from one MultiSite table to another (pages/sub-pages)
  57. How to make custom column Admin>Users sortable?
  58. How to display data from custom table in wordpress phpmyadmin
  59. Setting Up WordPress on Local Server, not showing full site when I test on remote server (Intranet)
  60. Lamp stack not supporting phpmyadmin? [closed]
  61. Will changing the folder name two directories above a fresh wordpress installation break the site?
  62. Restose content from revisions – sql query
  63. Update a buggy installation
  64. can’t see aditional themes in control panel
  65. How do you keep your live and and testing server?
  66. How to migrate a database from a server to another
  67. Broken wordpress site, non-working links and no access to wp-admin page
  68. migration wordpress to local machine does not work with all broken URLs except frontpage
  69. Live to Local on MAMP, not working, outputting functions.php code
  70. How to periodically roll back WordPress to a fixed point in time?
  71. WordPress on XAMPP over my home network [closed]
  72. phpMyAdmin error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
  73. List users with the most posts in the last 30 days
  74. How to track who has deleted files
  75. How can I get posts from 9/13/11 to today with SQL? [closed]
  76. Xamp installed local wordpress not allowing to publish or install plugin
  77. Transfer XAMPP local WordPress website from one PC to another
  78. Mysql Server keeps crashing
  79. How to change my 3000 Published post status to Draft using PHPMyAdmin
  80. Error establishing a database connection (Set-up locally)
  81. Delete all users with Editor role and their content mysql
  82. Updating user meta adds string count to value?
  83. How to re-connect WP files in lampp/htdocs to new SQL database to recover site under development
  84. I need to find posts that contain YouTube links without http:// or https:// prefix and add http:// to all of them
  85. How do I move my site from localhost to my domain?
  86. WordPress PHP version
  87. Help locating old custom_css in PHP MyAdmin
  88. wordpress redirect error in xampp
  89. WordPress asks to install, but is already installed?
  90. An SQL query to find orphaned image attachments and their meta
  91. Change Custom Post Type to Post + Category
  92. Adding wordpress posts using phpmyadmin
  93. I have my full special database from xampp how can i use this on wordpress?
  94. Missing latest posts and options after DB migration via phpMyAdmin
  95. Why when accessing some wordpress pages on my localhost setup do i get the localhost default page?
  96. Why is ‘register_activation_hook’ undefined?
  97. Options table – where does my values go?
  98. wordpress multisite duplicator plugin clon to localhost(xampp) but image not show
  99. Error Message when logging into WordPress on Xampp
  100. How to run site locally after downloading database

Leave a Comment