[DiscordArchive] Noob question im sorry trying to learn with ai to help but it's a new field. So I got a server up an
[DiscordArchive] Noob question im sorry trying to learn with ai to help but it's a new field. So I got a server up an
Original source
```SQL
CREATE DATABASE IF NOT EXISTS `acore_characters2`;
GRANT ALL PRIVILEGES ON `acore_characters2`.* TO 'acore'@'127.0.0.1';
```
That's one example to create a second database and give acore (if that's the username you use) access to it.
rektbyfaith
11-22-2023, 04:13 PM #11Archived author: Revision • Posted: 2023-11-22T16:13:52.360000+00:00
Original source
```SQL
CREATE DATABASE IF NOT EXISTS `acore_characters2`;
GRANT ALL PRIVILEGES ON `acore_characters2`.* TO 'acore'@'127.0.0.1';
```
That's one example to create a second database and give acore (if that's the username you use) access to it.
Original source
Just change it to suit your needs, although I'd recommend still looking into how to manage privileges etc so you know how it works.
rektbyfaith
11-22-2023, 04:14 PM #12Archived author: Revision • Posted: 2023-11-22T16:14:29.431000+00:00
Original source
Just change it to suit your needs, although I'd recommend still looking into how to manage privileges etc so you know how it works.
Original source
Thanks brother that's a lot of help. I'm trying its a new field for me I'm learning in free time. Been using gpt to kinda guide me and double check things I learn.
rektbyfaith
11-22-2023, 04:17 PM #13Archived author: CzechMaster • Posted: 2023-11-22T16:17:08.032000+00:00
Original source
Thanks brother that's a lot of help. I'm trying its a new field for me I'm learning in free time. Been using gpt to kinda guide me and double check things I learn.
Original source
Obviously you would need to do the same for a second world server, ofc.
rektbyfaith
11-22-2023, 04:17 PM #14Archived author: Revision • Posted: 2023-11-22T16:17:10.549000+00:00
Original source
Obviously you would need to do the same for a second world server, ofc.
Original source
Of course
rektbyfaith
11-22-2023, 04:17 PM #15Archived author: CzechMaster • Posted: 2023-11-22T16:17:19.936000+00:00
Original source
Of course
Original source
world database* even
rektbyfaith
11-22-2023, 04:17 PM #16Archived author: Revision • Posted: 2023-11-22T16:17:22.920000+00:00
Original source
world database* even
Original source
Happy to help, we all learned it at some point after all.
rektbyfaith
11-22-2023, 04:18 PM #17Archived author: Revision • Posted: 2023-11-22T16:18:19.087000+00:00
Original source
Happy to help, we all learned it at some point after all.
Original source
And I would send that using query in Heidi right or should I use the mysql server 8 line thing. I think I tried something like that last weekend when I was poking around with it.
rektbyfaith
11-22-2023, 04:30 PM #18Archived author: CzechMaster • Posted: 2023-11-22T16:30:06.364000+00:00
Original source
And I would send that using query in Heidi right or should I use the mysql server 8 line thing. I think I tried something like that last weekend when I was poking around with it.
Original source
If I recall its in the command line thing.
rektbyfaith
11-22-2023, 04:30 PM #19Archived author: CzechMaster • Posted: 2023-11-22T16:30:48.477000+00:00
Original source
If I recall its in the command line thing.
Original source
You could do it either way. You would need to do it as root though, not acore.
rektbyfaith
11-22-2023, 04:33 PM #20Archived author: Revision • Posted: 2023-11-22T16:33:36.435000+00:00
Original source
You could do it either way. You would need to do it as root though, not acore.
1 Guest(s)
1 Guest(s)