Just updated xampp, and security messed up mySQL!
Posted: 29. August 2005 08:41
Hi,
Been a while, but I just updated xampp using the 7zip archive. Everything was running smoothly until I went to the security area in the /xampp/ section.
I set up mySQL with mysqladmin (for new root password), and changed the config.inc.php. phpMyAdmin worked perfectly. Then, being curious me, I checked out the security page and noticed it said the /xampp/ directory could be opened by anyone, so I did my duty and typed in a username and password to generate the .htaccess and .htpasswd files, just like a good boy should, then I **hit enter** instead of clicking on the "Make safe the XAMPP directory" button. Well, it seemed fine at first other than it said my SQL password had been changed instead... hrmm
Remembering the new username and password I'd set, I went back to phpMyAdmin, and neither the old, nor the new passwords would work! I get "Cannot connect to SQL database." Well, that is a drag. I'd spent about 3 hours updating my old htdocs files to be up to par, and modfying the various settings for the server using the config files. I cant seem to find the problem ANYWHERE! What exactly did the MYSQL root password security 'update' break, and how can I fix it without a lovely repeat of the utterly aggrivating config file editing? I'd really appreciate any help!
Thanks! Seems that this is the only nasty bug i've found so far, which is pretty darned good, considering there are so many updates. I remember the endless 'fixxing' I had to do to get my old xampp working the way I wanted it to. Big improvement!
Been a while, but I just updated xampp using the 7zip archive. Everything was running smoothly until I went to the security area in the /xampp/ section.
I set up mySQL with mysqladmin (for new root password), and changed the config.inc.php. phpMyAdmin worked perfectly. Then, being curious me, I checked out the security page and noticed it said the /xampp/ directory could be opened by anyone, so I did my duty and typed in a username and password to generate the .htaccess and .htpasswd files, just like a good boy should, then I **hit enter** instead of clicking on the "Make safe the XAMPP directory" button. Well, it seemed fine at first other than it said my SQL password had been changed instead... hrmm
Remembering the new username and password I'd set, I went back to phpMyAdmin, and neither the old, nor the new passwords would work! I get "Cannot connect to SQL database." Well, that is a drag. I'd spent about 3 hours updating my old htdocs files to be up to par, and modfying the various settings for the server using the config files. I cant seem to find the problem ANYWHERE! What exactly did the MYSQL root password security 'update' break, and how can I fix it without a lovely repeat of the utterly aggrivating config file editing? I'd really appreciate any help!
Thanks! Seems that this is the only nasty bug i've found so far, which is pretty darned good, considering there are so many updates. I remember the endless 'fixxing' I had to do to get my old xampp working the way I wanted it to. Big improvement!