Hello,
after an unexpected issue on my server, the system table mysql.user is missing.
Now I cannot manage any database users in aaPanel and also applications like WoltLab or Shopware cannot connect anymore.
Environment:
• aaPanel (latest version)
• Ubuntu 24.04
• MariaDB 11.4.4 (installed via aaPanel under /www/server/mysql)
Error shown in aaPanel:
Db table not found!
Table 'mysql.user' doesn't exist
What I already tried:
• mariadb-upgrade -u root -p → reports “already upgraded”
• Tried mysql < mysql_system_tables.sql but files are missing in /usr/share/mysql/ and /www/server/mysql/share/
• The table mysql.user is completely gone (SHOW FULL TABLES LIKE 'user'; returns empty set).
My Question:
How can I properly re-initialize or restore the mysql.user system table in aaPanel without breaking my existing databases?
Is there an aaPanel-specific way (e.g. reinstalling MariaDB component without data loss) to rebuild the missing system tables?
This problem is critical, because I cannot create, edit or manage database users in aaPanel anymore.
Thanks in advance for your help!
