Apache Friends Support Forum

In the security panel for MySQL it says:
The MySQL admin user root has no longer no password
It also says that mysql is secure. Hmmm.
How can I fix this?

MySQL admin as in phpMyAdmin?

I would set a new password using xampp's web pages and then see what it says.

Woosh

This is for MySQL under XAMPP SECURITY [Security Check 1.0]

The MySQL admin user root has no longer no password SECURE
PhpMyAdmin password login is enabled. SECURE

I've already changed the password. Can't log into PHPMyAdmin.

Sorry, I read your first post wrong.

The message is correct. If you have created a password for mysql then it is secure.

If you have created one for phpmyadmin that is secure also.

If you goto localhost/phpmyadmin

you get a popup ?

enter root as the username and then the password you entered twice

Sorry if that is teaching you to suck eggs but I am a bit lost as to what you can / can't do.

Woosh

No, that doesn't work. I don't get a popup either.

To be honest and for pure ease, if this is the first time you have installed xampp and have not made any changes to anything, just uninstall and re-install.

Sorry I can't be of more help.

Woosh

I already uninstalled and re-installed. I'm going to re-install it over the instalation I have now and see if that helps.

Thanks.

kjharrison wrote:No, that doesn't work. I don't get a popup either.

then you have to edit phpmyadmin/config.inc.php
$cfg['Servers'][$i]['auth_type']= 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'YourNewPW';

I'm in! Thank you.
You know, I don't have to log in, though. Is that odd? Concened about safety.

Id o have to log in to get the XAMPP admin.