how to retrieve/reset phpmyadmin password [SOLVED]

[manuleka]

i've just fixed my lamp installation so php is functioning ok now but i've forgotten the phpmyadmin password (i'm guessing this is the same as mysql)

can anyone give me directions or quick guide on how to retrieve this password (or reset it)? is it stored in a file? this lamp server is installed for localhost testing purposes only...

[pompom]

Hi,

First, we need to stop the daemon

Code: Select all

sudo /etc/init.d/mysql stop
sudo mysqld --skip-grant-tables --skip-networking &
mysql -u root
UPDATE root SET password=PASSWORD('newpassword')
FLUSH PRIVILEDGES (if necessary)
sudo /etc/init.d/mysql restart

and for "password' be sure to use anything that is easily accessible on Facebook and your favorite social networking sites, such as your favorite girlfriend's name, a pet name, an anniversary date and the ilk, which anyone should have no trouble retrieving. Remember that adding a digit makes the password 70 times more difficult to crack, but password generating programs that produce random characters are probably a safer bet.

Regards,

pompom

[manuleka]

Code: Select all

~ $ sudo /etc/init.d/mysql stop
[sudo] password for manu: 
sudo: /etc/init.d/mysql: command not found

$ cd /etc/init.d
/etc/init.d $ sudo mysql stop
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

what is this telling me?

[Habitual]

as root:

Code: Select all

mysqld_safe –skip-grant-tables
mysql
use mysql;
update user set Password=PASSWORD(‘newpassword’) where user=’root’;
flush privileges;
exit;

service mysqld restart

[manuleka]

Code: Select all

 
# mysqld_safe -skip-grant-tables
The program 'mysqld_safe' can be found in the following packages:
 * mysql-server-5.1
 * mysql-cluster-server-5.1
Try: apt-get install <selected package>

was my installation incomplete or something? missing a few core packages? this is weird...

[manuleka]

ran this:

Code: Select all

sudo aptitude install mysql-server

when i run phpinfo() it seem to show mysql there, but i'm newbie so i guess it wasn't installed... cheers anyways for the help