1
Dopey8Mars
reconfiguring phpMyAdmin after changing MySQL password
  • 2007/6/17 17:44

  • Dopey8Mars

  • Just popping in

  • Posts: 3

  • Since: 2007/6/17


I have XamppLite installed. After changing the MySQL datbase password How do I reconfigure phpMyAdmin correctly so phpMyAdmin can access the database?

The following is the readme said:

" C:\XAMPPlite\mysql\bin\mysqladmin.exe -u root -p secret

After changing the password you'll have to reconfigure phpMyAdmin to use the new password, otherwise it won't be able to access the databases. To do that, open the file config.inc.php in \XAMPPlite\phpmyadmin\ and edit the following lines:

$cfg['Servers'][$i]['user'] = 'root'; // MySQL User
$cfg['Servers'][$i]['auth_type'] = 'http'; // HTTP authentification
"

It says I have to edit the following lines, but when I open those files and go to those lines they are exactly the same. What am I supposed to change about in those lines. thanks for your help in advance

2
Dave_L
Re: reconfiguring phpMyAdmin after changing MySQL password
  • 2007/6/17 18:52

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


If $cfg['Servers'][$i]['auth_type'] is 'http' or 'cookie', then you shouldn't have to make any changes to config.inc.php. By the way, I prefer 'cookie'.

When you browse to http://localhost/phpmyadmin/, it will ask for your MySQL username and password.

If $cfg['Servers'][$i]['auth_type'] were 'config', then $cfg['Servers'][$i]['user'] and $cfg['Servers'][$i]['password'] to the correct values.

3
Dopey8Mars
Re: reconfiguring phpMyAdmin after changing MySQL password
  • 2007/6/18 8:21

  • Dopey8Mars

  • Just popping in

  • Posts: 3

  • Since: 2007/6/17


thx:) I'll try and reinstall xampp and see if I can get it to work.

4
Dopey8Mars
Re: reconfiguring phpMyAdmin after changing MySQL password
  • 2007/6/18 8:21

  • Dopey8Mars

  • Just popping in

  • Posts: 3

  • Since: 2007/6/17


thx:) I'll try and reinstall xampp and see if I can get it to work.

Login

Who's Online

410 user(s) are online (312 user(s) are browsing Support Forums)


Members: 0


Guests: 410


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits