After changing the password, MySQL does not work.

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Re: After changing the password, MySQL does not work.

Postby badLoser » 26. July 2019 09:05

After password change:

[ERROR] mysqld: Table '.\mysql\user' is marked as crashed and should be repaired
[ERROR] mysqld: Index for table '.\mysql\user' is corrupt; try to repair it
[ERROR] Couldn't repair table: mysql.user
[ERROR] Fatal error: Can't open and lock privilege tables: Index for table 'user' is corrupt; try to repair it

Just to confirm that this recurs despite upgrading to Windows XAMPP 7.3.7 (complete re-install).

My circumvention was to restore the mysql.user table from the distribution backup table
badLoser
 
Posts: 1
Joined: 26. July 2019 08:48
XAMPP version: 7.3.7
Operating System: Windows

Re: After changing the password, MySQL does not work.

Postby gonzalo » 09. August 2019 12:11

Hi,

We have just released new XAMPP installers upgrading PHP only. The released installers are 7.1.31-0, 7.2.21-0 and 7.3.8-0. We continue investigating this issue and working on upgrading MariaDB to 10.4.

Regards,
Gonzalo
gonzalo
 
Posts: 30
Joined: 12. March 2019 08:52
XAMPP version: any
Operating System: any

Re: After changing the password, MySQL does not work.

Postby gonzalo » 14. August 2019 14:49

Hi,

We have just released a new revision of the installers (7.1.31-2 / 7.2.21-2 / 7.3.8-2) shipping MariaDB 10.4.6. These installers should fix the issues when restarting the MariaDB service after updating passwords.

Regarding the MariaDB version, we are facing the reported issue linked below when building MariaDB 10.4.7, that's why we included version 10.4.6:

https://jira.mariadb.org/browse/MDEV-20258

Regards,
Gonzalo
gonzalo
 
Posts: 30
Joined: 12. March 2019 08:52
XAMPP version: any
Operating System: any

Re: After changing the password, MySQL does not work.

Postby Altrea » 14. August 2019 17:41

Hi Gonzalo,

Thank you for this new release. I am still performing some testing but so far this release 7.3.8-2 seems to be much more stable than the releases containing Mariadb 10.3
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: 10248
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: After changing the password, MySQL does not work.

Postby MikeWid » 14. October 2019 13:21

I have experienced a similar problem on XAMPP 7.3.5 when Windows 10 1903 did an cumulative update kb4524100 & Kb2517389.
I suspect it rebooted without stopping background processes.
This does not occur when rebooting from the start menu.
I didn't try the repair, I restored a backup.
MikeWid
 
Posts: 3
Joined: 27. August 2013 16:38
Operating System: Windows 7

Re: After changing the password, MySQL does not work.

Postby ducknukam » 28. May 2020 00:51

Is there any new development to get over this?

I'm assuming that this issue is still ongoing since it happened to me today.
Not yet entirely sure how, but it seems that a Windows update and/or improper mysqld shutdown were contributing factors (as already hinted several times).

At the moment the best I can hope for is to downgrade. Can anyone point me to the last version of XAMPP that does not easily end up with corrupt tables?
The next time it happens I'll try to replace MariaDB with MySQL and see how that fares, 9/10 stability beats performance so there isn't really an option while MariaDB keeps dying.

Cheers.
ducknukam
 
Posts: 6
Joined: 28. May 2020 00:30
XAMPP version: 7.4.6
Operating System: Win10

Re: After changing the password, MySQL does not work.

Postby Altrea » 28. May 2020 08:44

ducknukam wrote:At the moment the best I can hope for is to downgrade. Can anyone point me to the last version of XAMPP that does not easily end up with corrupt tables?

Difficult question. If a Windows update has something to do with this issue, then there is no guarantee that older versions are not effected by this issue.
The main problem from my point of view is the way how XAMPP kills the process to shut it down, and maybe the MariaDB configuration which really really needs a rework.
So the easiest way would be to install and use MariaDB/MySQL as a single component.
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: 10248
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: After changing the password, MySQL does not work.

Postby ducknukam » 28. May 2020 10:20

Altrea wrote:The main problem from my point of view is the way how XAMPP kills the process to shut it down, and maybe the MariaDB configuration which really really needs a rework.
So the easiest way would be to install and use MariaDB/MySQL as a single component.

Ok, so I'm trying to understand the above. If MariaDB is installed from XAMPP then a daemon from XAMPP is responsible for stopping MariaDB (possibly improperly). But when MariaDB is installed as standalone somehow its own service takes that role on system shutdowns and handles it differently how?

More importantly, if I really want to deploy MariaDB standalone, how would I integrate it with XAMPP, I mean configuration wise? Or it would work out of the box?

This last question is mainly because instructions on swapping MariaDB with MySQL always assume the initial integration of XAMPP with its prepackaged DBS where you literally swap one for the other with small adjustments that it encompasses.
ducknukam
 
Posts: 6
Joined: 28. May 2020 00:30
XAMPP version: 7.4.6
Operating System: Win10

Re: After changing the password, MySQL does not work.

Postby Altrea » 28. May 2020 12:00

ducknukam wrote:If MariaDB is installed from XAMPP then a daemon from XAMPP is responsible for stopping MariaDB (possibly improperly).

Well, not exactly. The XAMPP control panel is just a piece of software to centralize the prozess commands into one single place.
But the control panel is not able to shutdown MariaDB properly, because the methods to stop a MariaDB Server would need Database credentials to fire a SHUTDOWN command, which can be changed by the user at any time and therefor destroy the ability to stop the MariaDB Daemon completely.
For that reason (and because it was never a problem for early MySQL Servers) the control panel simply kills the mariadb process. But that seems to do some harm to modern MariaDB Daemons.

ducknukam wrote:if I really want to deploy MariaDB standalone, how would I integrate it with XAMPP, I mean configuration wise? Or it would work out of the box?

MariaDB is coupled relatively loose to other XAMPP components. You would only need to recreate/reinstall the phpmyadmin database. And you need to configure MariaDB Server to listen on TCP port 3306 which can be done by the MariaDB installer.
You cannot start or stop any standalone MariaDB servers from the XAMPP control panel, so you need to use the MariaDB internal methods with mysqladmin shutdown, or by windows service.
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: 10248
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: After changing the password, MySQL does not work.

Postby ducknukam » 28. May 2020 13:46

Thanks for clarifying the process involved.
There is still something which I don't fully understand about how a standalone MariaDB would work around this:

Altrea wrote:You cannot start or stop any standalone MariaDB servers from the XAMPP control panel, so you need to use the MariaDB internal methods with mysqladmin shutdown, or by windows service.

The issue of not being able to start/stop from XAMPP's control panel is a minor nuisance. What really is puzzling me, assuming that I won't ever shutdown the DBS through mysqladmin, why is it safe to do so using a Windows service (which I'm assuming MariaDB installer creates) and why doesn't XAMPP use the same approach? I mean, if issuing a shutdown needs credentials, how does the standalone's service work around this in a way that XAMPP cannot?

What if there is an unexpected power outage, the same would be bound to happen no? I'm not even sure where the blame falls at this point, it seems to me that MariaDB is feeble when it comes to handling unexpected termination, whatever the cause is.
ducknukam
 
Posts: 6
Joined: 28. May 2020 00:30
XAMPP version: 7.4.6
Operating System: Win10

Re: After changing the password, MySQL does not work.

Postby Altrea » 28. May 2020 14:16

XAMPP tries to change as less in the system is possible, so no system path variables are set, no registry keys and no services by default.

You can register and use services in the control panel, but XAMPP also tries to be operable even without them.

Services are safer because the developers have programmed Mariadb to how to shutdown correct if the system fires a stop service command. And because only System Administrators can start and stop services you don't need any extra credentials.

What if there is an unexpected power outage, the same would be bound to happen no?

This can result in a corrupt Mariadb instance too I would expect. But as I already said, the default configuration xampp uses for MariaDB is from my point of view far away from optimal, so I would expect the default configuration from Mariadb itself could be much more forgiving
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: 10248
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: After changing the password, MySQL does not work.

Postby ducknukam » 28. May 2020 14:20

Right, but when I install the MySQL (MariaDB) service from XAMPP'S control panel, and if I then use that control panel to issue a stoppage, it sends a kill command instead of using the service it created to send a stop command?
ducknukam
 
Posts: 6
Joined: 28. May 2020 00:30
XAMPP version: 7.4.6
Operating System: Win10

Re: After changing the password, MySQL does not work.

Postby Altrea » 28. May 2020 15:19

No, then it will use the windows service commands.
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: 10248
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: After changing the password, MySQL does not work.

Postby ducknukam » 28. May 2020 17:36

Altrea wrote:No, then it will use the windows service commands.

So in this context there isn't any difference between using prepackaged or standalone MariaDB, assuming the user installs the service in both cases, right?
ducknukam
 
Posts: 6
Joined: 28. May 2020 00:30
XAMPP version: 7.4.6
Operating System: Win10

Re: After changing the password, MySQL does not work.

Postby Altrea » 28. May 2020 20:12

Sure, there are still some differences, mainly the default configuration. Many of the used configuration parameters xampp uses are there for many years now. Especially size limits. A default Mariadb configuration sets nearly none extra parameters, they rely on the global default settings. An these main default settings are much different from this xampp sets.
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: 10248
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Previous

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 87 guests