Page 1 of 1

Unable to use my own Database

PostPosted: 22. April 2021 16:47
by donpro
Hi. I wish to use my own MySQL DBs in XAMPP so that I can test my own applications. I am unable to insert to rows into mysql.user

Error: The target table user of the INSERT is not insertable-into

This seems odd for a fresh installation as the idea is to tun my own applications locally. Is there a fix for this?

Re: Unable to use my own Database

PostPosted: 22. April 2021 17:27
by Altrea
Hi,

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).

Source: https://mariadb.com/kb/en/mysqluser-table/