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 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...

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
Posts: 12
Joined: 08. May 2003 15:18

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 46 guests