when connecting supertokens to my mysql database i...
# support-questions-legacyf
fayzul_
04/10/2022, 9:01 AMwhen connecting supertokens to my mysql database im told i have to change it from localhost to my ip
r
rp_st
04/10/2022, 9:02 AMThat’s if you are using docker for supertokens
rp_st
04/10/2022, 9:02 AMCause if you give localhost to the docker container env var, it will point to inside the image
f
fayzul_
04/10/2022, 9:02 AMoh okay
fayzul_
04/10/2022, 9:02 AMso
r
rp_st
04/10/2022, 9:03 AMI mean inside the container*
f
fayzul_
04/10/2022, 9:03 AMi looked into my settings and found my local ip
fayzul_
04/10/2022, 9:03 AMi changed it
fayzul_
04/10/2022, 9:03 AMbut it didnt work
r
rp_st
04/10/2022, 9:03 AMIs MySQL listening to all interfaces?
rp_st
04/10/2022, 9:04 AMCause be default mysql will only listen to localhost
f
fayzul_
04/10/2022, 9:04 AMdang
fayzul_
04/10/2022, 9:04 AMhow can i change that pls?
r
rp_st
04/10/2022, 9:04 AMI think you could google that 😅
f
fayzul_
04/10/2022, 9:04 AM🙈
r
rp_st
04/10/2022, 9:04 AMI don’t remember it off the top of my head
f
fayzul_
04/10/2022, 9:05 AMsure
fayzul_
04/10/2022, 9:05 AMill get back to you with an update
fayzul_
04/10/2022, 9:06 AMit also said something about setting the bind-address to 0.0.0.0 using mysqld.cnf
r
rp_st
04/10/2022, 9:11 AMYea. That listens to all interfaces. And that would work
rp_st
04/10/2022, 9:11 AMYou also need to add a users in mysql that would listen on all ips.
f
fayzul_
04/12/2022, 9:57 AMhey rp
fayzul_
04/12/2022, 9:57 AMi did it
fayzul_
04/12/2022, 9:57 AMyou have to create a new user
fayzul_
04/12/2022, 9:58 AMthe host has to be your ip address
fayzul_
04/12/2022, 9:58 AMgrant him all priviliges
fayzul_
04/12/2022, 9:58 AMthem
fayzul_
04/12/2022, 9:59 AMthen go to the firewall and allow all connections
r
rp_st
04/12/2022, 10:34 AMyes! great!
2 Views