[DiscordArchive] Ok, did that now. What do I need to restart to get that config change to take effect?
[DiscordArchive] Ok, did that now. What do I need to restart to get that config change to take effect?
Original source
Ok, did that now. What do I need to restart to get that config change to take effect?
rektbyfaith
10-06-2023, 03:50 PM #1Archived author: Eyeheartpie • Posted: 2023-10-06T15:50:57.697000+00:00
Original source
Ok, did that now. What do I need to restart to get that config change to take effect?
Original source
mysql. systemctl restart mysql (with sudo if needed)
rektbyfaith
10-06-2023, 03:51 PM #2Archived author: Revision • Posted: 2023-10-06T15:51:09.301000+00:00
Original source
mysql. systemctl restart mysql (with sudo if needed)
Original source
Ah a new error! "Host XYZ is not allowed to connect to this MySQL server"
rektbyfaith
10-06-2023, 03:52 PM #3Archived author: Eyeheartpie • Posted: 2023-10-06T15:52:58.713000+00:00
Original source
Ah a new error! "Host XYZ is not allowed to connect to this MySQL server"
Original source
Yeah, root is set to only allow 127.0.0.1
rektbyfaith
10-06-2023, 03:53 PM #4Archived author: Revision • Posted: 2023-10-06T15:53:09.590000+00:00
Original source
Yeah, root is set to only allow 127.0.0.1
Original source
I would personally create a new user to access it remotely - especially since you would need to create a new entry for root to allow it to be used externally anyway
rektbyfaith
10-06-2023, 03:53 PM #5Archived author: Revision • Posted: 2023-10-06T15:53:38.530000+00:00
Original source
I would personally create a new user to access it remotely - especially since you would need to create a new entry for root to allow it to be used externally anyway
Original source
so the username/pw set in the authserver.conf file is not the right username/pw to use here?
rektbyfaith
10-06-2023, 03:54 PM #6Archived author: Eyeheartpie • Posted: 2023-10-06T15:54:07.934000+00:00
Original source
so the username/pw set in the authserver.conf file is not the right username/pw to use here?
Original source
If you created the users, yes it is. If not, no. You would need to create the user to access it from HeidiSQL or to connect to it using authserver/worldserver
rektbyfaith
10-06-2023, 03:54 PM #7Archived author: Revision • Posted: 2023-10-06T15:54:41.753000+00:00
Original source
If you created the users, yes it is. If not, no. You would need to create the user to access it from HeidiSQL or to connect to it using authserver/worldserver
Original source
If you ran `data/sql/create/create_mysql.sql` that won't let you access it from anywhere but the same system. You would need to edit that and change `localhost` to either the IP-address of the system that will use the user or `%` to allow all IPs to use it.
rektbyfaith
10-06-2023, 03:57 PM #8Archived author: Revision • Posted: 2023-10-06T15:57:27.784000+00:00
Original source
If you ran `data/sql/create/create_mysql.sql` that won't let you access it from anywhere but the same system. You would need to edit that and change `localhost` to either the IP-address of the system that will use the user or `%` to allow all IPs to use it.
Original source
I ran this script: https://github.com/azerothcore/azerothco..._mysql.sql
[Embed: azerothcore-wotlk/data/sql/create/create_mysql.sql at master · azer...]
Complete Open Source and Modular solution for MMO. Contribute to azerothcore/azerothcore-wotlk development by creating an account on GitHub.
https://github.com/azerothcore/azerothco..._mysql.sql
rektbyfaith
10-06-2023, 03:57 PM #9Archived author: Eyeheartpie • Posted: 2023-10-06T15:57:45.694000+00:00
Original source
I ran this script: https://github.com/azerothcore/azerothco..._mysql.sql
[Embed: azerothcore-wotlk/data/sql/create/create_mysql.sql at master · azer...]
Complete Open Source and Modular solution for MMO. Contribute to azerothcore/azerothcore-wotlk development by creating an account on GitHub.
https://github.com/azerothcore/azerothco..._mysql.sql
Original source
And I see that it only grants privileges on localhost
rektbyfaith
10-06-2023, 03:58 PM #10Archived author: Eyeheartpie • Posted: 2023-10-06T15:58:10.256000+00:00
Original source
And I see that it only grants privileges on localhost
1 Guest(s)
1 Guest(s)