New Welcome XAMPP and docs

Allgemeines Forum zum Thema Apache Friends. Bei Problemen mit XAMPP bitte entweder das Linux- oder das Windows-Forum benutzen. Hier geht's wirklich nur ganz allgemein um Apache Friends.

Re: New Welcome XAMPP and docs

Postby Motivated » 22. October 2015 19:59

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,130113
I really miss the simplicity of the old Xampp security system. Anyway, I got this working for Xampp, I think. ]
Motivated
 
Posts: 1
Joined: 25. June 2011 22:16

Re: New Welcome XAMPP and docs

Postby RJScout » 19. November 2015 20:34

Hello..
anybody there?

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 XAMPP
Sure would appreciate knowing how to execute the update without too much fuss...
and is it necessary?



Thanks in advance
User avatar
RJScout
 
Posts: 9
Joined: 17. April 2014 02:19
Location: Colorado
Operating System: Windows 7

Re: New Welcome XAMPP and docs

Postby Altrea » 19. November 2015 22:13

Hi Motivated,

Motivated wrote: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'."

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?

[FGA] Setting MySQL root password

Motivated wrote:I really miss the simplicity of the old Xampp security system. Anyway, I got this working for Xampp, I think. ]

Don't need to set any password because it is secure enough isn't simple?

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

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: New Welcome XAMPP and docs

Postby Altrea » 19. November 2015 22:19

Hi RJScout,

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!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: New Welcome XAMPP and docs

Postby maqpoon » 15. December 2015 18:10

you can change the permalink to post-name, and save the setting. and than try to click on the page links, it should work now..
maqpoon
 
Posts: 1
Joined: 15. December 2015 18:06
Operating System: Windows 10

Re: New Welcome XAMPP and docs

Postby jp26198926 » 17. December 2015 06:48

Hi Sir,

how do i display the login screen of phpmyadmin.

i already set the password for mysql by following the "reset-mysql-password.html" manual.

but still if i navigate to http://localhost/phpmyadmin/ it will bypass the login screen.

Thanks,
jp26198926
 
Posts: 1
Joined: 17. December 2015 06:38
Operating System: Windows, UBUNTU

Re: New Welcome XAMPP and docs

Postby Altrea » 17. December 2015 10:32

Hi,

This is also described in [FGA] Setting MySQL root password

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

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Please use any of the content in the following web page...

Postby steve_t » 13. November 2016 04:11

Hello Apache Friends,

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 Windows
http://www.learnwebcoding.com/misc/install_xampp_windows.php

My way of saying thanks for the wonderful XAMPP product you provide.

Regards,

Steve
steve_t
 
Posts: 15
Joined: 18. December 2014 04:28
XAMPP version: 5.6.24
Operating System: Windows Vista/7/8.1/10

Previous

Return to Apache Friends

Who is online

Users browsing this forum: No registered users and 5 guests