I too am confused. After upgrading to the latest Xampp version (in Windows 10), using this,

xampp-win32-5.6.14-0-VC11-installer.exe

I went here:

http://localhost/phpmyadmin/

And I saw this error message:

"You are connected as 'root' with no password, which corresponds to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole by setting a password for user 'root'."

The FAQ says "The easiest way is to use the security console, which you can access at http://localhost/security/ This console creates a password for the MySQL user root and adjusts the phpMyAdmin configuration."

But that URL returns "Object not found". The FAQ alternatively advises running the following in cmd, which I did in Xampp/Mysql/bin:

mysqladmin.exe -u root password secret

But when I return to phpmyadmin, I still see the same error message, indicating that my MySQL server does not have a secure password.

I ran the same command again to be sure, and I got this message:

"phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server."

So it seems my only option is to uninstall the latest version of Xampp and revert to the previous version.

Can someone please tell me how to set a secure password for my MySQL server in the new version of Xampp?

Thanks.

[Edit: I've found some instructions that work for phpMyAdmin version 4.1.14 in Wamp here: http://forum.wampserver.com/read.php?2,130113I really miss the simplicity of the old Xampp security system. Anyway, I got this working for Xampp, I think. ]

Updating to the new version..What exactly is involved to update Xampp from v3.2.1 to the lates versions listed below"

We just released new versions of XAMPP for all platforms with latest PHP versions: 5.5.19 and 5.6.3. We simplified the versioning for XAMPP releases and we now base the version number on the bundled PHP version, so you can more easily tell what is in the stack."

did not realize there was new version..of XAMPPSure would appreciate knowing how to execute the update without too much fuss...and is it necessary?

"You are connected as 'root' with no password, which corresponds to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole by setting a password for user 'root'."

This is the default message phpMyAdmin and MySQL are showing. In fact the user root is limited to login from localhost and phpMyAdmin with activated new XAMPP security concept can only get accessed from localhost too. So you are safe enough leaving the root user without password if only permitted users have direct access to the computer XAMPP is installed on (which should be the case on a local test and development environment).

Motivated wrote:The FAQ says "The easiest way is to use the security console, which you can access at http://localhost/security/ This console creates a password for the MySQL user root and adjusts the phpMyAdmin configuration."

But that URL returns "Object not found".

This FAQ is outdated and needs to be updated.

Motivated wrote:The FAQ alternatively advises running the following in cmd, which I did in Xampp/Mysql/bin:

Motivated wrote:mysqladmin.exe -u root password secret

On my test environment, this is working. But as already set there is no need to set a password for user root.

Motivated wrote:But when I return to phpmyadmin, I still see the same error message, indicating that my MySQL server does not have a secure password.

Maybe you need to set the command "flush-priviled" with mysqladmin after that. Restarting MySQL and clearing all browser cookies could also help.

Motivated wrote:Can someone please tell me how to set a secure password for my MySQL server in the new version of Xampp?

RJScout wrote:What exactly is involved to update Xampp from v3.2.1 to the lates versions listed below

There is no XAMPP version 3.2.1. What you mean is only the version number of the component "XAMPP control panel".This version of the XAMPP control panel is used in multiple XAMPP releases.

RJScout wrote:Sure would appreciate knowing how to execute the update without too much fuss...

There is no "update" functionality. So every update is in fact a reinstallation and migration.Backup XAMPP, Backup all your own files, export your databases and recreate all of that on a new XAMPP installation.

RJScout wrote:and is it necessary?

If you had to ask that than no. Don't update without any reason.Some reasons can be bugs with the specific version you uses (but than a helper would recommend you to update if he/she knows that this Bug is fixed in a later version)Or if you want to test out your scripts on a different PHP version, etc.

best wishes,Altrea

We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

Please feel free to use any of the content in the following web page at apachefriends.org or in the XAMPP dashboard web pages (no credit necessary):Install XAMPP For An Offline Development Environment With Apache And MySQL Running Locally On Windowshttp://www.learnwebcoding.com/misc/install_xampp_windows.php