Solved

phpMyadmin login password lost- need to reset

Posted on 2004-09-05
4
1,408 Views
Last Modified: 2008-03-04
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
Comment
Question by:nspolley
  • 2
4 Comments
 
LVL 26

Accepted Solution

by:
ushastry earned 500 total points
ID: 11987033
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
 
LVL 26

Expert Comment

by:ushastry
ID: 12024022
any updates?
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Trigger usage 2 75
insert row field data graphically 4 28
Mysql Left Join Case 10 70
Sql Query show error "SELECT statements have a different number of columns" 4 29
Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Creating and Managing Databases with phpMyAdmin in cPanel.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

791 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question