Adding users to mysql.user table

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

Adding users to mysql.user table

Postby Areadien » 28. April 2020 19:06

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?
Areadien
 
Posts: 3
Joined: 28. April 2020 18:07
XAMPP version: 7.4.5
Operating System: Windows 10

Re: Adding users to mysql.user table

Postby Altrea » 28. April 2020 20:56

Hi,

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

best wishes,
Altrea
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: 10196
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Adding users to mysql.user table

Postby Areadien » 29. April 2020 02:23

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. :D
Areadien
 
Posts: 3
Joined: 28. April 2020 18:07
XAMPP version: 7.4.5
Operating System: Windows 10

Re: Adding users to mysql.user table

Postby Areadien » 01. May 2020 18:36

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?
Areadien
 
Posts: 3
Joined: 28. April 2020 18:07
XAMPP version: 7.4.5
Operating System: Windows 10

Re: Adding users to mysql.user table

Postby Altrea » 01. May 2020 19:27

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
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: 10196
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 2 guests