[DiscordArchive] do I need to change all the acore names in it and rerun it?
[DiscordArchive] do I need to change all the acore names in it and rerun it?
Original source
well it said I could change those for extra security
rektbyfaith
01-04-2025, 10:16 AM #21Archived author: KlayTitan • Posted: 2025-01-04T10:16:09.735000+00:00
Original source
well it said I could change those for extra security
Original source
yeah you can
rektbyfaith
01-04-2025, 10:16 AM #22Archived author: Kitzunu • Posted: 2025-01-04T10:16:14.745000+00:00
Original source
yeah you can
Original source
but you need to make sure everything is run properly anyways
rektbyfaith
01-04-2025, 10:16 AM #23Archived author: Kitzunu • Posted: 2025-01-04T10:16:26.178000+00:00
Original source
but you need to make sure everything is run properly anyways
Original source
yeah, its not a big deal either, this is mainly a personal/friend project
rektbyfaith
01-04-2025, 10:17 AM #24Archived author: KlayTitan • Posted: 2025-01-04T10:17:03.263000+00:00
Original source
yeah, its not a big deal either, this is mainly a personal/friend project
Original source
thanks for the help though, both of you
rektbyfaith
01-04-2025, 10:17 AM #25Archived author: KlayTitan • Posted: 2025-01-04T10:17:18.271000+00:00
Original source
thanks for the help though, both of you
Original source
so if you want to change it up you would edit the 'acore' to whatever user you want and IDENTIFIED BY 'acore' to the password you want, and run it all with the new user
rektbyfaith
01-04-2025, 10:18 AM #26Archived author: Kitzunu • Posted: 2025-01-04T10:18:52.783000+00:00
Original source
so if you want to change it up you would edit the 'acore' to whatever user you want and IDENTIFIED BY 'acore' to the password you want, and run it all with the new user
Original source
yeah, I think I understand that bit now
rektbyfaith
01-04-2025, 10:19 AM #27Archived author: KlayTitan • Posted: 2025-01-04T10:19:15.548000+00:00
Original source
yeah, I think I understand that bit now
Original source
```sql
DROP USER IF EXISTS 'kitzunuthegreatest'@'localhost';
CREATE USER 'kitzunuthegreatest'@'localhost' IDENTIFIED BY 'verrysecurepassword' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0;
GRANT ALL PRIVILEGES ON * . * TO 'kitzunuthegreatest'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON `acore_world` . * TO 'kitzunuthegreatest'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON `acore_characters` . * TO 'kitzunuthegreatest'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON `acore_auth` . * TO 'kitzunuthegreatest'@'localhost' WITH GRANT OPTION;
```
For example
rektbyfaith
01-04-2025, 10:19 AM #28Archived author: Kitzunu • Posted: 2025-01-04T10:19:38.166000+00:00
Original source
```sql
DROP USER IF EXISTS 'kitzunuthegreatest'@'localhost';
CREATE USER 'kitzunuthegreatest'@'localhost' IDENTIFIED BY 'verrysecurepassword' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0;
GRANT ALL PRIVILEGES ON * . * TO 'kitzunuthegreatest'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON `acore_world` . * TO 'kitzunuthegreatest'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON `acore_characters` . * TO 'kitzunuthegreatest'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON `acore_auth` . * TO 'kitzunuthegreatest'@'localhost' WITH GRANT OPTION;
```
For example
1 Guest(s)
1 Guest(s)