[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
quick setup question - when doing the mysql_secure_installation does the level of the password validation policy have an effect on the azerothcore installation?
rektbyfaith
09-13-2023, 09:30 AM #1Archived author: ninjaf00t • Posted: 2023-09-13T09:30:17.706000+00:00
Original source
quick setup question - when doing the mysql_secure_installation does the level of the password validation policy have an effect on the azerothcore installation?
Original source
or does that not matter for the acore user?
rektbyfaith
09-13-2023, 09:31 AM #2Archived author: ninjaf00t • Posted: 2023-09-13T09:31:29.767000+00:00
Original source
or does that not matter for the acore user?
Original source
As I know, mysql_secure_installation is a sql-server config, so it could impact on the password rules, because acore user "lives" inside the database, so is you set a high level of password you´ll need to set a high password to acore user. IDK if I explained properly
rektbyfaith
09-13-2023, 09:33 AM #3Archived author: Carlos • Posted: 2023-09-13T09:33:33.296000+00:00
Original source
As I know, mysql_secure_installation is a sql-server config, so it could impact on the password rules, because acore user "lives" inside the database, so is you set a high level of password you´ll need to set a high password to acore user. IDK if I explained properly
Original source
I have it enabled, because I´,m compiling AC on a Virtual Machine, I´ll made the search too. Thanks
rektbyfaith
09-13-2023, 09:34 AM #4Archived author: Carlos • Posted: 2023-09-13T09:34:40.215000+00:00
Original source
I have it enabled, because I´,m compiling AC on a Virtual Machine, I´ll made the search too. Thanks
Original source
yeah that makes sense. I'm still pretty new to this but looking at the database setup instructions for acore would I be correct in assuming the line 'CREATE USER 'acore'@'localhost' IDENTIFIED BY 'acore' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0;' means create user without a password?
rektbyfaith
09-13-2023, 09:39 AM #5Archived author: ninjaf00t • Posted: 2023-09-13T09:39:22.405000+00:00
Original source
yeah that makes sense. I'm still pretty new to this but looking at the database setup instructions for acore would I be correct in assuming the line 'CREATE USER 'acore'@'localhost' IDENTIFIED BY 'acore' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0;' means create user without a password?
Original source
or is acore the default password for the acore user?
rektbyfaith
09-13-2023, 09:40 AM #6Archived author: ninjaf00t • Posted: 2023-09-13T09:40:20.414000+00:00
Original source
or is acore the default password for the acore user?
Original source
and if so, where would I need to edit the password so the binary can communicate with the db?
rektbyfaith
09-13-2023, 09:40 AM #7Archived author: ninjaf00t • Posted: 2023-09-13T09:40:58.433000+00:00
Original source
and if so, where would I need to edit the password so the binary can communicate with the db?
Original source
Yeah thats it, the way to access db is -u acore -p acore
rektbyfaith
09-13-2023, 09:41 AM #8Archived author: Carlos • Posted: 2023-09-13T09:41:36.450000+00:00
Original source
Yeah thats it, the way to access db is -u acore -p acore
Original source
Becuse when u access db for the 1st time you need to access with root to set up the security
rektbyfaith
09-13-2023, 09:42 AM #9Archived author: Carlos • Posted: 2023-09-13T09:42:33.010000+00:00
Original source
Becuse when u access db for the 1st time you need to access with root to set up the security
Original source
so even if I set up password validation, I can, as a root user, just add acore with password acore and sql will be fine with it?
rektbyfaith
09-13-2023, 09:46 AM #10Archived author: ninjaf00t • Posted: 2023-09-13T09:46:12.414000+00:00
Original source
so even if I set up password validation, I can, as a root user, just add acore with password acore and sql will be fine with it?