1,105,169 Community Members

Foegot password and user nam. Need Help!!

Member Avatar
Aviplo
Light Poster
43 posts since Oct 2011
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

I try to access phpmyadmin but i can't get in because it said my password and username is wrong. The password and username, is it the same one as i entered when i install Appserve ?.So what should i do if i want to change username and password or can any one tell me where can i get password and user name to access localhost\phpadmin

Please help..

manojsamtani
Light Poster
37 posts since Apr 2011
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
Banned
 
0
 

Hi,

First of all confirm if this is Apache password or mysql password.....if this asking over browser in a small dialogue box then its apache's configuration or if its asking in browser's page then its mysql' config


if its mysql's configuration then do the following steps to change password:

1) stop mysql
2) start mysql with --skip-grant-tables (mysqld_safe --skip-grant-tables)
3) Reset user password with following steps:
enter into mysql prompt with "mysql" command:
use mysql
update user set password=password("newPassword") where user = 'root';
4) Restart mysql service and access phpmyadmin with new user and password (but keep this thing your mind the user root must be enabled to login in phpmyadmin....you can check this in /etc/phpMyAdmin/config.inc.php)

--
Manoj
Removed by mod

You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: