Some help with MySQL please

[Zordin]

So me and some others are working on a server, but I'm not quite sure how to give the others DB access from without the hosting machine... What im looking to do is login to the DB on the host, from my machine.
+Rep to whoever solves it for me

[hax0rz]

First, all your friends get navicat
second, make your server public like with hosting info and whatnot...heres a guide http://www.mmowned.com/forums/ascent...o-hamachi.html
third, Click manage users on navicat and make them an account and have them put ur server address in the host address and put in their info and then they can connect and edit db if you allowed all permissions in the manage users tab.

[illegalalien]

btw when creating the users for the sql make sure that the field where it says host is set to a wildcard "%" that way they can connect from any ip

[waymirec]

and people wonder why their databases get hacked... *sigh*

[illegalalien]

lawl true that :3 but it wont happen if you set a good user and pass
if you dont use a wildcard for a host then you have to keep up with the ip of the person who is trying to connect which pretty hard nowadays since everyone has dynamic ips

i guess if you dont wanna get hacked like waymirec suggest you can make a vpn with hamachi or something along the lines of that ^_^ the hamachi will only be used for connecting to the db not to connect to the server i hope im not making this confusing >_<

[waymirec]

You should realistically not have more than 2-3 people accessing your database. Any more than that and you are begging for trouble. Given that and the fact that the majority of people are using Broadband and their IP wont change, unless they are rebooting their Broadband Modem often for some odd reason, that often it's not a very big administrative task to update their IP once in a while. All it takes is one person to figure out one of the passwords either through luck or social networking and you're entire db is at stake. Personally I would take it even a step further and setup your firewall to only allow access to port 3306 from the specific IP's of those that need access to it.. but that's just me.