The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

Migrating users table from Maria 10.2.22 to MariaDB 10.4.7

I have an application using MariaDB Server version 10.2.22 which I am planning to migrate that application to MariaDB 10.4.7.

In the process of securing the database using mysql_secure_installation script, I noticed that the mysql.users table is now a view and the table to look for user information is called mysql.global_priv. This is the case when I install MariaDB Server version 10.4.7. However, when I do yum update to upgrade my running application from MariaDB Server 10.2.22 to MariaDB Server 10.4.7, I end with a DB that does not have a mysql.global_priv table but continues to have a mysql.user table.

Given the current direction outlined in the documentation for the user table, what is the correct procedure to migrate the contents of the mysql.user table to the new mysql.global_priv table when upgrading MariaDB Server versions?

TIA, Jaime

Answer Answered by Ian Gilfillan in this comment.

Have you followed all steps from Upgrading from MariaDB 10.2 to MariaDB 10.3 and Upgrading from MariaDB 10.3 to MariaDB 10.4, including running mysql_upgrade?

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.