• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

XAMPP v5.6.14 Table db in Database mysql has Possible Corruption Problem

Participant ,
Oct 26, 2015 Oct 26, 2015

Copy link to clipboard

Copied

The October 19th release of the first XAMPP stack with MariaDB rather than MySQL database server has, of course, been download by thousands of users; but, in a few cases a corruption issue of table db in database MySQL (even though it is MariaDB the database is still called MySQL [should be all lower case but spell check will not allow it])  is occurring.  I thought it was specific to my laptop and a particular download/install.  I have uninstalled and did repeat download/installs at least 4 times and the same SQL error occurs.  The error is:

User accounts error.png

I have found this to same error in this Apache Friends Support Forum Apache Friends Support Forum • View topic - Error Accessing "User Accounts" from phpmyadmin and noted to linuxs I am have the same problem.

I started an issue thread at GitHub SQL Error Opening User Accounts phpMyAdmin Version 4.5.1 Server version: 10.0.17-MariaDB · Issue #11... and lem9, one of the phpMyAdmin developers, noted the table db in database MySQL was corrupted and I was unable to repair it.  Moreover, lem9 pointed out his demo at demo.phpmyadmin.net / phpMyAdmin demo - MySQL | phpMyAdmin 4.6.0-dev did not have this problem I'm dealing with.

I noted to lem9, his demo is running MariaDB version 10.0.21 released 2015-08-06 and XAMPP is version 10.0.17 released 2015-02-27.

Anyone else, beside me and linuxs see this table corruption problem? More importantly, can someone guide me to a resource or link on how to get MariaDB 10.0.17 out of my XAMPP stack and replace it with MariaDB 10.0.21?  Since MariaDB just went in XAMPP October 19th I've found no discussion on how to update to a newer MariaDB version.

Thanks in advance. 

Views

1.9K

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guru ,
Oct 26, 2015 Oct 26, 2015

Copy link to clipboard

Copied

. . .and replace it with MariaDB 10.0.21

When I installed MariaDB 10.0.21, I found that I had to first remove mySQL through the windows remove program process, though the instructions did not say so. My ZendServer webserver did recognize it without problems, after a reboot.

Of course backup your data and your apache config files first.

https://downloads.mariadb.org/mariadb/10.0.21/

go for the msi version, not the zip  version, as that will install it as a windows service.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Participant ,
Oct 29, 2015 Oct 29, 2015

Copy link to clipboard

Copied

LATEST

Here is some more information about this problem that I have gathered over the last few days.

I wrote in Apache Friends Support Forum:

I'm running phpMyAdmin 4.5.1 and have loaded MariaDB 10.1.8 in my XAMPP stack to replace 10.0.17.

The whole thing's a complete train wreck.

Table db in database MySQL is completely unstable. I cannot add a user with PMA so I had to install HeidiSQL and only then could I add a user but could not drill down to give a user privileges to a particular database; thus, could only provide privileges at the global level. However, being the db table bug that it is, table db will, on occasion, populate with the users I've created and also the global privileges I've given them. However, when table db does show the users, that is when you get the error noted by linuxs in his original screen shot. And of course when that screen shot error appears you're not going to get to the PMA User accounts tab/page. And again, if the screen shot error does not present itself, one can access the User accounts tab/page and see the users you've created. However, clicking on the edit privileges is useless since table db is empty and thus you get an SQL error noting something to the effect that the MyISAM table was expecting more data than provided (i.e. no data is in the table db, duh).

Again, MairaDB, no matter what "stable" release is apparently doing a number on database MySQL and it seems in particular table db. I know lem9 has the demo in PMA working with MariaDB 10.0.21 and does have one user pma in table db of database MySQL. Yet, some of us are having serious problems with regard to User Management with the presence of MariaDB. And MariaDB is becoming a more widely used database server, the inclusion of said in the new stacks.

If anyone has any ideas why MariaDB is not actually, "An enhanced, drop-in replacement for MySQL" I'd greatly appreciate how to fix the User Management bugs. 

The thread at Apache Support is Apache Friends Support Forum • View topic - Error Accessing "User Accounts" from phpmyadmin

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines