Problems with the Windows version of XAMPP, questions, comments, and anything related.
by 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
by 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
-
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