[DiscordArchive] special symbols, spaces, Unicode ?
[DiscordArchive] special symbols, spaces, Unicode ?
Original source
do not use the default passwords or the password as the same as the user
rektbyfaith
09-30-2025, 09:52 AM #11Archived author: Ryan Turner • Posted: 2025-09-30T09:52:45.122000+00:00
Original source
do not use the default passwords or the password as the same as the user
Original source
Yeah, only allowing specific IPs, only granting *required* privileges and using secure passwords = triple security. not allowing access to MySQL from the outside would make it quadruple.
rektbyfaith
09-30-2025, 09:53 AM #12Archived author: Revision • Posted: 2025-09-30T09:53:17.160000+00:00
Original source
Yeah, only allowing specific IPs, only granting *required* privileges and using secure passwords = triple security. not allowing access to MySQL from the outside would make it quadruple.
Original source
Can I restrict the SQL port so it’s accessible only from my IP and my developer’s IP, while still keeping the WoW server running normally for players?
rektbyfaith
09-30-2025, 09:54 AM #13Archived author: Durotan • Posted: 2025-09-30T09:54:45.897000+00:00
Original source
Can I restrict the SQL port so it’s accessible only from my IP and my developer’s IP, while still keeping the WoW server running normally for players?
Original source
yes
rektbyfaith
09-30-2025, 09:54 AM #14Archived author: Mithria • Posted: 2025-09-30T09:54:56.604000+00:00
Original source
yes
Original source
you could also use an ssh tunnel
rektbyfaith
09-30-2025, 09:55 AM #15Archived author: Mithria • Posted: 2025-09-30T09:55:04.118000+00:00
Original source
you could also use an ssh tunnel
Original source
I don't understand the last statement. Clients dont' access MySQL in order to play. they never need the MySQL-server to be public
rektbyfaith
09-30-2025, 09:55 AM #16Archived author: Revision • Posted: 2025-09-30T09:55:21.477000+00:00
Original source
I don't understand the last statement. Clients dont' access MySQL in order to play. they never need the MySQL-server to be public
Original source
mysql access control will never affect the player.
rektbyfaith
09-30-2025, 09:55 AM #17Archived author: Mithria • Posted: 2025-09-30T09:55:53.741000+00:00
Original source
mysql access control will never affect the player.
Original source
The only 2 ports you need to have open is the auth and world
rektbyfaith
09-30-2025, 09:55 AM #18Archived author: Ryan Turner • Posted: 2025-09-30T09:55:54.069000+00:00
Original source
The only 2 ports you need to have open is the auth and world
Original source
But yeah, creating a user `CREATE USER IF NOT EXISTS 'username'@'ip-address' IDENTIFIED BY 'secure-af-password-please';` means only that specific ip-address can connect
rektbyfaith
09-30-2025, 09:56 AM #19Archived author: Revision • Posted: 2025-09-30T09:56:18.369000+00:00
Original source
But yeah, creating a user `CREATE USER IF NOT EXISTS 'username'@'ip-address' IDENTIFIED BY 'secure-af-password-please';` means only that specific ip-address can connect
Original source
You may want `WITH GRANT OPTION` at the end though but that's easy
rektbyfaith
09-30-2025, 09:56 AM #20Archived author: Revision • Posted: 2025-09-30T09:56:38.629000+00:00
Original source
You may want `WITH GRANT OPTION` at the end though but that's easy
1 Guest(s)
1 Guest(s)