Solutions to the mySQL woes!

[John]

Okay I posted this in another thread, but I figured this deserves its own spot

I have *no* idea why the mySQLadmin -u root password **** command doesn't work, but it doesn't! So..... how to change password? Use the web interface! Here is how I did it:

reset config.inc.php to look like this:
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';

Go to webserver and access phpMyAdmin from there. You will see the 'No root password blahblahblah'

go to "priviledges"
edit root@localhost
change password in the page (remember the password!!!!!!)

reload the phpMyAdmin page and make sure it denies you. If it does, then it worked.

reopen config.inc.php and change it again:
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'above_pw_here';

reload the phpMyAdmin page *again*. Should let you in, and you no longer see the evil red warning!

I hope this helps other frustrated people! I don't know jack about this stuff and I kinda stumbled across it

[Liath]

I'm realizing that the post's subject isn't right.... Should be something like "How to fix phpMyAdmin" or something... ugh