[DiscordArchive] Why mariadb over mysql?
[DiscordArchive] Why mariadb over mysql?
Original source
Why mariadb over mysql?
rektbyfaith
02-15-2023, 02:55 AM #1Archived author: CommanderX • Posted: 2023-02-15T02:55:26.931000+00:00
Original source
Why mariadb over mysql?
Original source
you can use MySQL too.. it really doesn't make much different tbh
rektbyfaith
02-15-2023, 02:55 AM #2Archived author: matrix1999 • Posted: 2023-02-15T02:55:35.571000+00:00
Original source
you can use MySQL too.. it really doesn't make much different tbh
Original source
MariaDB is newer I guess
rektbyfaith
02-15-2023, 02:55 AM #3Archived author: matrix1999 • Posted: 2023-02-15T02:55:44.890000+00:00
Original source
MariaDB is newer I guess
Original source
Been having a hard time getting mysql to work, so I'll try maria
rektbyfaith
02-15-2023, 02:55 AM #4Archived author: CommanderX • Posted: 2023-02-15T02:55:50.949000+00:00
Original source
Been having a hard time getting mysql to work, so I'll try maria
Original source
once you have compiled the code and all, the important part is to run the `mysql_secure_installation`. This step is not documented but you absolutely need it to make it work.
rektbyfaith
02-15-2023, 02:57 AM #5Archived author: matrix1999 • Posted: 2023-02-15T02:57:17.070000+00:00
Original source
once you have compiled the code and all, the important part is to run the `mysql_secure_installation`. This step is not documented but you absolutely need it to make it work.
Original source
Do you have it running under a debian or ubuntu image?
rektbyfaith
02-15-2023, 02:58 AM #6Archived author: CommanderX • Posted: 2023-02-15T02:58:37.254000+00:00
Original source
Do you have it running under a debian or ubuntu image?
Original source
Then install it all?
rektbyfaith
02-15-2023, 02:58 AM #7Archived author: CommanderX • Posted: 2023-02-15T02:58:45.335000+00:00
Original source
Then install it all?
Original source
after that you will need to do the following via MySQL or MariaDB (# sudo mysql):
`DROP USER IF EXISTS 'acore'@'localhost';
CREATE USER 'acore'@'localhost' IDENTIFIED BY 'acore' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0;
GRANT ALL PRIVILEGES ON * . * TO 'acore'@'localhost' WITH GRANT OPTION;
CREATE DATABASE `acore_world` DEFAULT CHARACTER SET UTF8MB4 COLLATE utf8mb4_general_ci;
CREATE DATABASE `acore_characters` DEFAULT CHARACTER SET UTF8MB4 COLLATE utf8mb4_general_ci;
CREATE DATABASE `acore_auth` DEFAULT CHARACTER SET UTF8MB4 COLLATE utf8mb4_general_ci;
GRANT ALL PRIVILEGES ON `acore_world` . * TO 'acore'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON `acore_characters` . * TO 'acore'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON `acore_auth` . * TO 'acore'@'localhost' WITH GRANT OPTION;`
rektbyfaith
02-15-2023, 02:59 AM #8Archived author: matrix1999 • Posted: 2023-02-15T02:59:09.675000+00:00
Original source
after that you will need to do the following via MySQL or MariaDB (# sudo mysql):
`DROP USER IF EXISTS 'acore'@'localhost';
CREATE USER 'acore'@'localhost' IDENTIFIED BY 'acore' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0;
GRANT ALL PRIVILEGES ON * . * TO 'acore'@'localhost' WITH GRANT OPTION;
CREATE DATABASE `acore_world` DEFAULT CHARACTER SET UTF8MB4 COLLATE utf8mb4_general_ci;
CREATE DATABASE `acore_characters` DEFAULT CHARACTER SET UTF8MB4 COLLATE utf8mb4_general_ci;
CREATE DATABASE `acore_auth` DEFAULT CHARACTER SET UTF8MB4 COLLATE utf8mb4_general_ci;
GRANT ALL PRIVILEGES ON `acore_world` . * TO 'acore'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON `acore_characters` . * TO 'acore'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON `acore_auth` . * TO 'acore'@'localhost' WITH GRANT OPTION;`
Original source
I am running under Ubuntu 20.04
rektbyfaith
02-15-2023, 02:59 AM #9Archived author: matrix1999 • Posted: 2023-02-15T02:59:27.540000+00:00
Original source
I am running under Ubuntu 20.04
Original source
20
![[Image: 2x.png?ex=690c0ff5&is=690abe75&hm=dfdb94...1a6165d37&]](https://cdn.discordapp.com/attachments/284406375495368704/1075250925205213224/2x.png?ex=690c0ff5&is=690abe75&hm=dfdb940d729902c9c8d8374afb1aea771772e7ed7bd16b541ed3b1f1a6165d37&)
rektbyfaith
02-15-2023, 03:03 AM #10Archived author: Rymercyble • Posted: 2023-02-15T03:03:17.848000+00:00
Original source
20
1 Guest(s)
1 Guest(s)