Solutions to the mySQL woes!

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Solutions to the mySQL woes!

Postby John » 12. April 2003 16:21

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 :)
John
 

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

Postby Liath » 08. May 2003 15:55

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


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 68 guests