[SOLVED] MySQL, public for windows?

[Blazeqts]

So, I'm currently trying to make my Devs be able to connect to my World DB through Heidisql/Navicat/etc.

However, I can only connect to it with 127.0.0.1 - Not even I, can connect to the world DB with the IP/Realmlist.

I've made accounts with MySQL Command Line - also made privileges and such needed.

3306 port is open aswell.

- It's on windows btw.

It seems like the mysql isn't public (obviously)

The server itself is public and available to play on with the Realmlist.


whelp, dunno what to do.

~loveblaze

 

[yvoms]

Connecting to your own machine using your external ip?
Anyways, Have you portforwarded, Allowed your firewall.
And gave their host a wildcard?

http://canyouseeme.org/

You yourself, can only connect to the machine using your Internal adress, Not your external adress.
I.e

Localhost:3306
:::3306
192.168.1.xxx:3306(where xxx=Your internal IP)

 

[Blazeqts]

I know that lol, how do u think my server got public I did give their host a wildcard, aswell as my own, everything is port forwarded, and allowed firewall.

And I want my devs who are somewhere else to connect to it, i dont care about connecting to it wtih external from where i live.

 

[Syphex]

To be honest you need to bind the msql to your ip address, are you using justie's external msql or your own?

Anyway using the Mysql workbench you can add remote acces by editing the connection.

and there you can choose which computer in the network the remote acess should connect to when connecting and you can also choose if it should connect to your ip or a custom link. (altrough i don't know how it works with a custom link)

 

[Tommy]

are you using justie's external msql or your own?

Hopefully his own or from EmuDevs. That guy's website is full of outdated links and it just confuses people, along with giving them the wrong links for certain things.

- Moved to General Support since this isn't emulation related.

 

[Blazeqts]

I downloaded MySQL 5.5 from this guide:
http://collab.kpsn.org/display/tc/Requirements
http://dev.mysql.com/downloads/mysql/5.6.html <- this link is inside the guide



- I'm not using workbench, but HeidiSQL. The guide says, quote:
"Choose one of these database management tools:
a. mysql cli (Fastest (recomended since we use some very big files))
b. SQLYog Community Edition
c. HeidiSQL (Best for beginners)
d. MySQL Workbench (already installed if you chose to install full MySQL package)"

 

[Syphex]

I downloaded MySQL 5.5 from this guide:
http://collab.kpsn.org/display/tc/Requirements
http://dev.mysql.com/downloads/mysql/5.6.html <- this link is inside the guide



- I'm not using workbench, but HeidiSQL. The guide says, quote:
"Choose one of these database management tools:
a. mysql cli (Fastest (recomended since we use some very big files))
b. SQLYog Community Edition
c. HeidiSQL (Best for beginners)
d. MySQL Workbench (already installed if you chose to install full MySQL package)"

you should set up your own mysql, since if you do you will get the latest mysql everytime a new update come. and it's much easier to use. also it will be running 24/7 if you want.


Follow this guide here -
http://emudevs.com/showthread.php/4014-How-to-install-MySQL-Server-correctly

after that if you don't know how to set it up , Then i'll happily walk you through.