Page 1 of 1

Solutions to the mySQL woes!

PostPosted: 12. April 2003 16:21
by 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 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 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 :)

*G* I wish I coudl rename this post...

PostPosted: 08. May 2003 15:55
by Liath
I'm realizing that the post's subject isn't right.... Should be something like "How to fix phpMyAdmin" or something... ugh