Open up the config.inc.php file in the phpmyadmin folder and make the following changes:
$cfg['PmaAbsoluteUri'] = '';
to
$cfg['PmaAbsoluteUri'] = 'http://localhost/phpmyadmin/';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
to
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] =
'your mysql user name';
$cfg['Servers'][$i]['password'] =
'your mysql password';
if you didn't set your mysql username and password then you must do that.
Do the following:
open your command prompt and switch to mysql folder (cd c:\mysql\bin).
type mysql -uroot -p mysql. This should let you login as root. Just hit enter when it asks for your password (since you haven't set up any). Now you're logged in as 'root'. Type the following:
USE mysql; (to use the 'mysql' db)
SET PASSWORD FOR root@localhost=PASSWORD('new_password');
This sets your mysql password. If you want to change user name to something other than 'root', Type:
UPDATE user SET user='new user' WHERE user='root';
hit enter then type:
FLUSH PRIVILEGES;
this allows privileges to take effect.
