• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1428
  • Last Modified:

phpMyadmin login password lost- need to reset

I have a Cobalt RAQ 4 web server that is running Red Hat 7.3 Apache Web Server 1.36
512MB RAM, 60GB HD, 500GB Bandwidth,PHP4.1.2 MySQL 3.23 and phpMyAdmin

I have a login screen that had the Window for access to my phpMyadmin with the password remembered. Today something else got accidentally typed into the password box and now I cannot open phpMyAdmin and I have looked all over for the admin password but cannot locate. I do have the root user password for MYSQL but that is not the same as the phpMyAdmin password. How do I reset the admin login password to use phpMyAdmin again or reset so that it does not need a password. I am a self-taught PC user and not strong in MYSQL but can follow instructions.            
0
nspolley
Asked:
nspolley
  • 2
1 Solution
 
UmeshMySQL Principle Technical Support EngineerCommented:
Hi,

First check the config.inc.php then look for a line similar to this..(there should be more lines similar to this.. find out which one is real
)


$cfgServers[1]['user']          = 'userName';      // Here comes your phpmyadmin username..
$cfgServers[1]['password']      = '123456';          // Confirm whether this is your password

If this solves your problem then fine, otherwise you have to reset the password of phpmyadmin..

login using root ( I guess you have stored phpmyadmin user info in mysql database..user name is phpmyadmin then follow these steps...

$mysql -uroot -p ( would prompt for password)
use mysql

update user set password=password('yoursecretpassword') where user='phpmyadmin'

that's it..


Hope this helps!


0
 
UmeshMySQL Principle Technical Support EngineerCommented:
any updates?
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now