[DiscordArchive] quick setup question - when doing the mysql_secure_installation does the level of the password valid
[DiscordArchive] quick setup question - when doing the mysql_secure_installation does the level of the password valid
Original source
like it won't give me shit for having a password that doesn't meet it's password validation requirements?
rektbyfaith
09-13-2023, 09:46 AM #11Archived author: ninjaf00t • Posted: 2023-09-13T09:46:49.948000+00:00
Original source
like it won't give me shit for having a password that doesn't meet it's password validation requirements?
Original source
If you follow the documentation yes, because authserver access the database using acore user, so if you set other policy that isn´t in the documentation it´ll give you problems
rektbyfaith
09-13-2023, 09:51 AM #12Archived author: Carlos • Posted: 2023-09-13T09:51:04.161000+00:00
Original source
If you follow the documentation yes, because authserver access the database using acore user, so if you set other policy that isn´t in the documentation it´ll give you problems
Original source
altright, thanks for the help
rektbyfaith
09-13-2023, 09:58 AM #13Archived author: ninjaf00t • Posted: 2023-09-13T09:58:43.215000+00:00
Original source
altright, thanks for the help
Original source
Np mate
rektbyfaith
09-13-2023, 10:00 AM #14Archived author: Carlos • Posted: 2023-09-13T10:00:40.718000+00:00
Original source
Np mate
Original source
last question on setting up the database - the instructions from the manual install is different to the bash script install - the manual install has this:
rektbyfaith
09-13-2023, 10:38 AM #15Archived author: ninjaf00t • Posted: 2023-09-13T10:38:05.612000+00:00
Original source
last question on setting up the database - the instructions from the manual install is different to the bash script install - the manual install has this:
Original source
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_unicode_ci;
CREATE DATABASE `acore_characters` DEFAULT CHARACTER SET UTF8MB4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE `acore_auth` DEFAULT CHARACTER SET UTF8MB4 COLLATE utf8mb4_unicode_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
09-13-2023, 10:38 AM #16Archived author: ninjaf00t • Posted: 2023-09-13T10:38:06.478000+00:00
Original source
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_unicode_ci;
CREATE DATABASE `acore_characters` DEFAULT CHARACTER SET UTF8MB4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE `acore_auth` DEFAULT CHARACTER SET UTF8MB4 COLLATE utf8mb4_unicode_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
but the bash scrip install has this:
rektbyfaith
09-13-2023, 10:38 AM #17Archived author: ninjaf00t • Posted: 2023-09-13T10:38:26.482000+00:00
Original source
but the bash scrip install has this:
Original source
DROP USER IF EXISTS 'acore'@'localhost';
DROP USER IF EXISTS 'acore'@'127.0.0.1';
CREATE USER 'acore'@'localhost' IDENTIFIED BY 'acore';
CREATE USER 'acore'@'127.0.0.1' IDENTIFIED BY 'acore';
GRANT ALL PRIVILEGES ON * . * TO 'acore'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON * . * TO 'acore'@'127.0.0.1' WITH GRANT OPTION;
FLUSH PRIVILEGES;
exit;
rektbyfaith
09-13-2023, 10:38 AM #18Archived author: ninjaf00t • Posted: 2023-09-13T10:38:27.164000+00:00
Original source
DROP USER IF EXISTS 'acore'@'localhost';
DROP USER IF EXISTS 'acore'@'127.0.0.1';
CREATE USER 'acore'@'localhost' IDENTIFIED BY 'acore';
CREATE USER 'acore'@'127.0.0.1' IDENTIFIED BY 'acore';
GRANT ALL PRIVILEGES ON * . * TO 'acore'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON * . * TO 'acore'@'127.0.0.1' WITH GRANT OPTION;
FLUSH PRIVILEGES;
exit;
Original source
the manual install instructions appear more up to date
rektbyfaith
09-13-2023, 10:39 AM #19Archived author: ninjaf00t • Posted: 2023-09-13T10:39:02.101000+00:00
Original source
the manual install instructions appear more up to date
Original source
should I be using that one?
rektbyfaith
09-13-2023, 10:39 AM #20Archived author: ninjaf00t • Posted: 2023-09-13T10:39:07.925000+00:00
Original source
should I be using that one?
1 Guest(s)
1 Guest(s)