How to log in to phpMyAdmin with WAMP, what is the username and password?
Try username = root and password is blank.
unable to login phpMyAdmin using WAMP
When you install WAMP, it comes with a standard install of MySQL. The standard user for MySQL is root
and there is no password.
Before you can add your own user ashish
, you need to log in as root and add this user (or just use root if it's for testing only).
Regaining access to lost MySQL password for PHPMyAdmin on WAMP
Here is a method that will allow you to reset the MYSQL 'root' password quite simply.
Stop the mysql service
wampmanager -> MySQL -> Service -> Stop Service
Edit the my.ini file
wampmanager -> MySQL -> my.ini
Find the [wampmysqld]
(32bit) or [wampmysqld64]
(64bit) section in the ini file
Add this line directly after that section heading
skip-grant-tables
Restart the mysql service.
wampmanager -> MySQL -> Service -> Start/Resume Service
Open the MySQL console
wampmanager -> MySQL -> MySQL Console
Now we are going to reset the password for the root user, of course this could be used to reset any users password.
Enter the following 2 commands at the mysql>
command prompt, each with a semi colon at the end of a line, and press ENTER after each line to issue the command to mysql.
Pre MYSQL version 5.7
UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;
Post MYSQL version 5.7 the column name changed
UPDATE mysql.user SET authentication_string=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;
Note that the update may report that it has updated more than one row, that because there may be more than one user accounts with the userid of 'root' each with a different domain i.e. 127.0.0.1, localhost and ::1
Now enter 'quit' at the mysql command promt to exist mysql.
Stop the mysql service
wampmanager -> MySQL -> Service -> Stop Service
Edit the my.ini file
wampmanager -> MySQL -> my.ini
Find the [wampmysqld]
(32bit) or [wampmysqld64]
(64bit) section in the ini file
Remove the skip-grant-tables
parameter we added earlier.
DO NOT Leave this parameter in the ini file its a HUGH security hole.
Restart the mysql service.
wampmanager -> MySQL -> Service -> Start/Resume Service
Now if you want you can set the root user account so it does not expire the password automatically
wampmanager -> MySQL -> MySQL Console
and then run this query
ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
You should now be able to login with phpmyadmin using the userid 'root' and the new password you have just set for that user.
Related Topics
Mysqli Prepared Statement Num_Rows Returns 0 While Query Returns Greater Than 0
How to Visualize a Bunch of Functions in Uml
Convert All Node's Attributes into Child Nodes
How to Create Multi-Dimensional Array from a List
Cascade Dropdown List Using Jquery/Php
How to Read About Conditionals Done with "" and ":" (Colon)
PHP Date Conversion to Strtotime
How to Properly Create HTML Links in PHP
How to Use PHP to Get the Current Year
How to Detect Fake Users ( Crawlers ) and Curl
Laravel 5.3 New Auth::Routes()
Remove First 4 Characters of a String with PHP
Loading CSV into MySQL Table with PHP
Html5 Audio Says "Live Broadcast" in iOS When It's a Static File