Adding users to mysql.user table

[Areadien]

Hello, all. I downloaded the most recent version of xampp, and I can't change my root password or insert SQL users at all, though I was able to insert them into the db table just fine. What do I do?

[Altrea]

Hi,

please read this for most recent changes of the mysql.user table:
https://mariadb.com/kb/en/mysqluser-table/

best wishes,
Altrea

[Areadien]

OK, even when I go to the global_priv table information, the link you gave me doesn't seem to tell me how to add users and passwords. For now, I'm using root with no password, but I'd really like not to.

Also, is there any chance this could be moved to the English forum, please? I don't speak German, so I won't be able to answer any replies without Google Translate.

Edit: Oh wait, it appears there is no English-only forum for Apache. Never mind then.

[Areadien]

OK, so I did some investigating into CREATE USER, but I'm having a problem. Sometimes the syntax works; at other times, it doesn't, even under the same circumstances, and I just don't understand why because the system is not telling me, and it's very frustrating. I'm even using the syntax exactly suggested by mariadb.com, but I'm getting the error, "Operation CREATE USER failed for 'foo2'@'test'," and it doesn't make any sense. Can you tell me the latest version of XAMPP that didn't have this create user nonsense?

[Altrea]

The Create User statement can fail for example if the user already exists. Please keep in mind that you need to FLUSH PRIVILEGES after changing the users table.
I don't know which was the last XAMPP version containing Mariadb 10.3 or lower