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. Help required with local wordpress setup
  31. How to log in to phpMyAdmin with WAMP, what is the username and password?
  32. What is the difference between XAMPP or WAMP Server & IIS?
  33. How do I use MySQL through XAMPP?
  34. mysqli_real_connect(): (HY000/2002): No such file or directory
  35. XAMPP Port 80 in use by “Unable to open process” with PID 4
  36. Setting up foreign keys in phpMyAdmin?
  37. Cannot access to localhost/xampp/index.php
  38. Localhost is not working
  39. phpMyAdmin: secret passphrase?
  40. localhost/xampp/ or http://localhost/index.php can’t be accessed
  41. Forbidden :You don’t have permission to access /phpmyadmin on this server
  42. mysqli_real_connect(): (HY000/2002): No such file or directory
  43. How do I run a file on localhost?
  44. Xampp MySQL not starting – “Attempting to start MySQL service…”
  45. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  46. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  47. XAMPP Apache won’t start
  48. XAMPP, Apache – Error: Apache shutdown unexpectedly
  49. MySQL Error #1133 – Can’t find any matching row in the user table
  50. What is the use of Mercury and Tomcat in Xampp control panel?
  51. Xampp Access Forbidden php
  52. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  53. How to solve “Error: MySQL shutdown unexpectedly”?
  54. How to create a foreign key in phpmyadmin
  55. importing a CSV into phpmyadmin
  56. MySQL: Can’t create table (errno: 150)
  57. XAMPP installation on Win 8.1 with UAC Warning
  58. MySQL: How to reset or change the MySQL root password?
  59. MySQL Daemon Failed to Start – centos 6
  60. Auto increment in phpmyadmin
  61. How do I find what causes a blank white screen in WordPress?
  62. Moving WordPress from MAMP to WAMP, can’t access pages
  63. Moving WordPress from MAMP to WAMP, can’t access pages
  64. WordPress on XAMPP setting up Zoho mail
  65. WAMP vs XAMPP pros/cons – for running a local testing server [closed]
  66. Redirecting to old domain after migration
  67. Relative or dynamic site url possible?
  68. How to remove “Connection Information” requirement on localhost install of WP on MACOSX
  69. WordPress Subdomain MultiSite on localhost XAMPP on :8080 with IIS taking port 80
  70. How do I find all admin users using phpmyadmin?
  71. WP Asking for FTP Credentials with XAMPP Localhost
  72. PHP function showing wrong time in WordPress
  73. the_post_thumbnail scaling not hard cropping
  74. What specific database privileges does WordPress need?
  75. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  76. Manually delete post from database
  77. Connect to remote database using Localhost install
  78. “Could not open input file” error even when WP-CLI is in the path
  79. Where is the “default attribute” values located in the phpMyAdmin in Woocommerce?
  80. WordPress multisite with domain mapping and virtual host on local with fake domain
  81. Gaining Login Access via the Database
  82. Reseting admin password through PHPMyadmin fails
  83. How to delete users with no order history through phpmyadmin sql?
  84. How to add an export function to a custom Option Theme Page
  85. Moving database with phpMyAdmin
  86. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  87. Installing WordPress Theme Unit Data
  88. POSTS list in WordPress by views
  89. How to copy post titles to post slug in phpmyadmin
  90. Delete all post meta except featured image
  91. Error: MySQL shutdown unexpectedly. XAMPP local conf running WordPress
  92. Trying to run WordPress on localhost?
  93. Export only pages and posts with mysql dump
  94. Connect to live db whilst working locally
  95. unable to upload image locally
  96. Using the Parcel build tool with WordPress
  97. Set wp-content folder to Dropbox folder
  98. How to do a MySQL dump from production site without using a search and replace script for local development?
  99. Installation Issue WordPress locally – The file ‘wp-config.php’ already exists
  100. How to Move Local Singlesite Database to Remote Multsite Database?

Leave a Comment

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