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: 12
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: 12
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: 9741
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 59 guests