Unable to use my own Database

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Unable to use my own Database

Postby donpro » 22. April 2021 16:47

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?
donpro
 
Posts: 2
Joined: 22. April 2021 16:44
XAMPP version: 3.2.4
Operating System: WIndows 10

Re: Unable to use my own Database

Postby Altrea » 22. April 2021 17:27

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/
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 99 guests