Apache Friends Support Forum

Hi all,

I installed xampp 7.4.20 / PHP 7.4.20, then i did some testing found an error, tried to figure it out , did some research and that lead me to "repair table". That did nothing so I "end task" anything related to xampp and then deleted the xampp folder.

I then re-installed xampp 7.4.20 / PHP 7.4.20

when i checked via phpadmin, i still had the same issue: Error 'mysql.user' is not of type 'BASE TABLE'






I do not know if i caused the error, and hopefully someone can help me fix it.

thank you,

Hi,

Maybe this explains it:

https://mariadb.com/kb/en/mysqluser-table/ wrote:MariaDB starting with 10.4
In MariaDB 10.4 and later, the mysql.global_priv table has replaced the mysql.user table, and mysql.user is now a view. From MariaDB 10.4.13, the dedicated mariadb.sys user is created as the definer of the view. Previously, root was the definer, which resulted in privilege problems when this username was changed (MDEV-19650).

Any suggestions on how to fix it?

there is nothing to fix. you cannot repair a view with table ccommand.
if ypu have any current issued we need the description of your issue.