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. mysqli_real_connect(): (HY000/2002): No such file or directory
  31. MySQL Error #1133 – Can’t find any matching row in the user table
  32. How to solve “Error: MySQL shutdown unexpectedly”?
  33. Moving WordPress from MAMP to WAMP, can’t access pages
  34. WordPress Subdomain MultiSite on localhost XAMPP on :8080 with IIS taking port 80
  35. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  36. How to delete users with no order history through phpmyadmin sql?
  37. Installing WordPress Theme Unit Data
  38. Export only pages and posts with mysql dump
  39. Using the Parcel build tool with WordPress
  40. How to do a MySQL dump from production site without using a search and replace script for local development?
  41. How to Move Local Singlesite Database to Remote Multsite Database?
  42. $wpdb->query() vs. $wpdb->get_results() vs. phpMyAdmin
  43. “Class ‘Phar’ not found” error setting up WP-CLI with Cygwin
  44. I have a desktop and a laptop: What’s the best way to move between local installations?
  45. Can’t find my wordpress DB in phpmyadmin
  46. WordPress database import: Row size too large
  47. WordPress on a local machine redirecting to xampp dashboard page [closed]
  48. Why wordpress kicks me back to the dashboard of xampp? [closed]
  49. Plugin: register_deactivation_hook works perfectly well, while register_activation_hook suddenly stopped working
  50. WordPress Database Huge wp_usermeta Table
  51. Multisite Create Site not working
  52. Better way to migrate to server?
  53. AWS Bitnami WordPress – SELECT command denied to user
  54. I want to create a 300 multi-site wordpress network using subdomains
  55. Post Views / Hit Counter Problem?
  56. Locally restoring a ManageWP full site backup
  57. WordPress admin creation through phpmyadmin not working
  58. Fatal error: Uncaught Error: Call to undefined function get_header() [closed]
  59. Getting Error Trying to Create Table
  60. change wordpress upload url to subdomain on xampp local
  61. How do I remove/reset all current widgets from the database?
  62. WordPress can I manually add columns in users table and display it in the default manage user plugin and registration form? [closed]
  63. Unable to install and upload theme due to php.ini file [closed]
  64. Changing a Child theme’s name on MAMP localhost
  65. Way to send multiple values for column to MySQL?
  66. SELECT SQL_CALC_FOUND_ROWS with wordpress search
  67. I installed WordPress locally now how do I login?
  68. xammp server permalink by postname not working
  69. Change WordPress Multisite Domain
  70. Local install not loading template images but is loading everything else XAMPP
  71. Installing local to live WP into subdirectory
  72. How to prevent a function from running based on host (ie web vs local)?
  73. Export SQL query based on custom field?
  74. Is there ANYTHING about this query that’s incompatible with WordPress 2.9.2?
  75. Can’t log into wordpress site – I have made a new user and still cant access
  76. Trying to copy linux blog locally with XAMPP – php fatal error
  77. Change word in woocommerce product category custom field
  78. Display data from phpMyAdmin with WordPress
  79. WordPress fails to install with “Can’t Select Database” Error (WAMPServer)
  80. 404 Error in Xampp
  81. Unable to insert two value in two different columns (WordPress database)
  82. Update WooCommerce stock status with SQL query if stock value is greater than 0
  83. why not selecting multiple rows of same standard_id using SQL query from database?
  84. localhost/wordpress(or other application), how does it work?
  85. Duplicate database to roll back theme & content changes
  86. submit form data to wordpress existing database table using my plugin
  87. Testing localhost WordPress site over LAN with iPad, iPhone
  88. 403 Forbidden Localhost Wamp Apache Php
  89. WordPress character set issue
  90. WordPress installation didn’t install any default data and returned empty rows!
  91. get backup file from wordpress database in x days
  92. Changed meta_key value in structures, now dashboard shows zero users
  93. WordPress not taking password and username
  94. Setting up XAMPP and Sendmail to enable WordPress emails on localhost
  95. Database question while Migrating from one domain to another on same WebHost [Bluehost]
  96. Export posts with postmeta without ID?
  97. WordPress site does not display content
  98. Need SQL query to find&replace image URL
  99. I cannot access to my wordpress
  100. 404 Error after URL update

Leave a Comment