[DiscordArchive] It does? are there scripts that give the acore account privileges?
[DiscordArchive] It does? are there scripts that give the acore account privileges?
Original source
It does? are there scripts that give the acore account privileges?
rektbyfaith
08-21-2022, 06:39 PM #1Archived author: Kek • Posted: 2022-08-21T18:39:46.411000+00:00
Original source
It does? are there scripts that give the acore account privileges?
Original source
There's the initial query that creates the user, DBs, and assigns privileges to the user on the wiki
rektbyfaith
08-21-2022, 06:40 PM #2Archived author: Bench • Posted: 2022-08-21T18:40:15.374000+00:00
Original source
There's the initial query that creates the user, DBs, and assigns privileges to the user on the wiki
Original source
`GRANT ALL PRIVILEGES ON acore_world.* TO 'acore'@'hostname';`
rektbyfaith
08-21-2022, 06:40 PM #3Archived author: Revision • Posted: 2022-08-21T18:40:28.251000+00:00
Original source
`GRANT ALL PRIVILEGES ON acore_world.* TO 'acore'@'hostname';`
Original source
that's a simple one
rektbyfaith
08-21-2022, 06:40 PM #4Archived author: Revision • Posted: 2022-08-21T18:40:38.590000+00:00
Original source
that's a simple one
Original source
Hmm... I'm gonna kill the database again and see if the privileges die
rektbyfaith
08-21-2022, 06:40 PM #5Archived author: Kek • Posted: 2022-08-21T18:40:50.515000+00:00
Original source
Hmm... I'm gonna kill the database again and see if the privileges die
Original source
I don't know why `WITH GRANT OPTION` is in the create script, it shouldn't be.
rektbyfaith
08-21-2022, 06:41 PM #6Archived author: Revision • Posted: 2022-08-21T18:41:25.775000+00:00
Original source
I don't know why `WITH GRANT OPTION` is in the create script, it shouldn't be.
Original source
I haven't had to redo privileges a single time in all my AC experience
rektbyfaith
08-21-2022, 06:41 PM #7Archived author: Bench • Posted: 2022-08-21T18:41:28.869000+00:00
Original source
I haven't had to redo privileges a single time in all my AC experience
Original source
Yeah, my acore user still has rights to that database even without the database existing
rektbyfaith
08-21-2022, 06:41 PM #8Archived author: Kek • Posted: 2022-08-21T18:41:33.234000+00:00
Original source
Yeah, my acore user still has rights to that database even without the database existing
Original source
How else could it create a database, if it doesn't have rights to that name?
rektbyfaith
08-21-2022, 06:42 PM #9Archived author: Kek • Posted: 2022-08-21T18:42:12.238000+00:00
Original source
How else could it create a database, if it doesn't have rights to that name?
Original source
If you're not privileged to do so, you can't create a database.
rektbyfaith
08-21-2022, 06:42 PM #10Archived author: Revision • Posted: 2022-08-21T18:42:30.582000+00:00
Original source
If you're not privileged to do so, you can't create a database.