[DiscordArchive] Hi folks, just following the installation instructions on the Wiki and when trying to run https://gi
[DiscordArchive] Hi folks, just following the installation instructions on the Wiki and when trying to run https://gi
Original source
Hi folks, just following the installation instructions on the Wiki and when trying to run https://github.com/azerothcore/azerothco..._mysql.sql against my db as root, I'm getting the following error:
> SQL Error [1410] [42000]: You are not allowed to create a user with GRANT
I was scrolling through past mentions of this script, and is this an issue with MySQL versions? Do I just need to screw with the syntax? I should have all permissions available as root, no?
rektbyfaith
07-28-2025, 07:03 PM #1Archived author: necro • Posted: 2025-07-28T19:03:54.915000+00:00
Original source
Hi folks, just following the installation instructions on the Wiki and when trying to run https://github.com/azerothcore/azerothco..._mysql.sql against my db as root, I'm getting the following error:
> SQL Error [1410] [42000]: You are not allowed to create a user with GRANT
I was scrolling through past mentions of this script, and is this an issue with MySQL versions? Do I just need to screw with the syntax? I should have all permissions available as root, no?
Original source
what mysql version do you use
rektbyfaith
07-28-2025, 07:05 PM #2Archived author: Kitzunu • Posted: 2025-07-28T19:05:09.140000+00:00
Original source
what mysql version do you use
Original source
and are you using your root user to run it
rektbyfaith
07-28-2025, 07:05 PM #3Archived author: Kitzunu • Posted: 2025-07-28T19:05:35.706000+00:00
Original source
and are you using your root user to run it
Original source
I'm running 8.4 and yeah, I'm logged in as my root.
rektbyfaith
07-28-2025, 07:10 PM #4Archived author: necro • Posted: 2025-07-28T19:10:04.199000+00:00
Original source
I'm running 8.4 and yeah, I'm logged in as my root.
Original source
Maybe I'm reading this wrong (SQL isn't my forte) but does root not have perms to GRANT ALL PRIVILEGES ... WITH GRANT OPTION by default?
rektbyfaith
07-28-2025, 07:14 PM #5Archived author: necro • Posted: 2025-07-28T19:14:29.840000+00:00
Original source
Maybe I'm reading this wrong (SQL isn't my forte) but does root not have perms to GRANT ALL PRIVILEGES ... WITH GRANT OPTION by default?
Original source
just making sure, you are not using MariaDB right
rektbyfaith
07-28-2025, 07:19 PM #6Archived author: Nyeriah • Posted: 2025-07-28T19:19:08.768000+00:00
Original source
just making sure, you are not using MariaDB right
Original source
Nope, using MySQL Server 8.4 and Dbeaver to poke around
rektbyfaith
07-28-2025, 07:21 PM #7Archived author: necro • Posted: 2025-07-28T19:21:12.476000+00:00
Original source
Nope, using MySQL Server 8.4 and Dbeaver to poke around
Original source
Only because I use it at work so I'm somewhat familiar with it
rektbyfaith
07-28-2025, 07:21 PM #8Archived author: necro • Posted: 2025-07-28T19:21:19.156000+00:00
Original source
Only because I use it at work so I'm somewhat familiar with it
Original source
The user you create for the first time it's always a super user, which you tend to call root, so it should have all permissions to do whatever with it
rektbyfaith
07-28-2025, 07:22 PM #9Archived author: Ryan Turner • Posted: 2025-07-28T19:22:42.074000+00:00
Original source
The user you create for the first time it's always a super user, which you tend to call root, so it should have all permissions to do whatever with it
Original source
I don't really understand, but i was able to run the script line by line instead.
rektbyfaith
07-28-2025, 07:27 PM #10Archived author: necro • Posted: 2025-07-28T19:27:10.109000+00:00
Original source
I don't really understand, but i was able to run the script line by line instead.
1 Guest(s)
1 Guest(s)