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