Changing Password for phpmyadmin on Raspberry Pi

I happen to forget my password to phpmyadmin because it was months ago since i installed it with my Apache2 web server. I did a quick search on the net and found a forum post discussing about recovering password for phpmyadmin on XAMPP. I haven’t try this on Raspberry Pi because I managed to recover my root password. (username is root!) However this may be useful for future reference:

You may want to edit this file: “\xampp\phpMyAdmin\config.inc.php” for XAMPP on desktop or “/etc/phpmyadmin/confid.inc.php”

change this line (for XAMPP):

$cfg[‘Servers’][$i][‘password’] = ‘WhateverPassword’;

to whatever your password is. If you don’t remember your password, then run this command in the Shell:

mysqladmin.exe -u root password WhateverPassword

where ‘WhateverPassword’ is your new password.

However I couldn’t find the line for Raspberry Pi. Instead, this may be helpful:
/* Uncomment the following to enable logging in to passwordless accounts, after taking note of the associated security risks. */
// $cfg['Servers'][$i]['AllowNoPassword'] = TRUE;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s