Mysql help please :)

[bradderz8]

Previously i have hosted a private server and somehow allowed it for remote computers to connect to my Mysql server, but i can't remember how?
any help would be appreciated

+Rep

[archonmagnus]

You'd have to tell us more information. Are you using MaNGOS, Ascent, etc.? If you are using MaNGOS, you'd have to first modify the information in the realmd table to contain the data relevant to your computer (IP address, port, etc.) I don't know what the analogous Ascent method would be. Perhaps another user could help?

[Claiver]

You'd have to tell us more information. Are you using MaNGOS, Ascent, etc.? If you are using MaNGOS, you'd have to first modify the information in the realmd table to contain the data relevant to your computer (IP address, port, etc.) I don't know what the analogous Ascent method would be. Perhaps another user could help?

You could ofcourse use Remote Desktop or something additional like VNC to log into the hostcomputer yourself.
I don't exactly know how to make your SQL server ready to be connected to from outside, I got it working, but someone else fixed it for me :-(.

[hollen]

It shouldnt matter about the emulator your running. Have the person download SQLyog or Navicat or something.. Have them type in the IP address and port (make sure the port is forwarded with a router) and give them the username and password for the db. I know there is a way to create new users aswell and give them read/write only commands no delete or download/backup.. but i havent messed with that in AWHILE.. Also, I could be missing afew things, like i said, its been AWHILE and im just starting to get back into things again =P Hope this helps alittle! send a pm if you have more questions, ill try to help

[Dynashock]

Yeah, open up your database with a database editor and add a new user there. In HeidiSQL it can be found under Tools and then User-Manager. There you'll have to fill in their host (ip), their account data and their privileges. (like delete, add, etc.)

I'm not familiar with the other DB editors (i.e. Navicat, SQLyog), so I can't help you with that.

[stoneharry]

SQLyog is the same as HediSQL, navicat not sure about but it should be similer.
Just a note, if you put host as "%" (without the ") then it will allow all ip's to connect, it saves the hassle of if somone's ip changes.