[GUIDE] Give Permission For A User to Enter Your Database

[[Blackstorm]]

Hello MMOwned community! I will show you how to give access to your database for another person, like your friend. Basicially what it does is it lets your friend enter your database to execute things and such. You should have your server/MySQL installed and ready. Otherwise look around MMOwned to find how to make a server. Do not ask about anything other than this.

This is written for SQLyog!

Note: I tried my best to search for another guide like this, making sure this is not a repost. If it is...SORRY!!

Step ONE ) Make sure you have "Remote Access" enabled. If you are not sure, open up Start > All Programs > MySQL > MySQL Server 5.0 (or whatever you have) > MySQL Server Instance Config Wizard. Open it up and choose "Reconfigure Instance" and then "Standard Configuration" fill in the security settings and check off "Enable root access from remote machines" and "Execute". Then you are good to go.



Step TWO ) Open up SQLyog and log in. If you can't log in because your trial is finished, then move your mouse to the grey part and hit "Enter"...that should get you past the pop-up and into the Editor. (Credits go to Illidan1 for finding this out)


Step THREE ) Hit Ctrl + U to open up the "Add User" screen --OR-- to do it manually, go to Tools > User Manager > Add User


Step FOUR) Now fill in Username, Password, Confirm Password, and for Host you can either put your hostname (if your server is public) or your external ip (www.whatismyip.com). If you are giving access to another computer in your house, you can put your internal ip (Start > Run > cmd > ipconfig) Now check off the privileges you want your user to have. After, click "Create".


Step FIVE (optional) ) If you want more advanced privileges, hit Ctrl + Shift + W --OR-- Tools > User Manager > Manage Permissions. Edit whatever you need.


Step SIX ) Your user should be able to connect to your database from his computer now. All he has to do is change MySQL host address to your host (you got this from step three) and the User/Pass you created for him.


And VOILA!! Your friend will now be able to edit your database from his computer!


WARNING!! Make sure your friend (or whatever your giving access to) is a nice guy that you are best friends with, otherwise he can take down your server really bad!!

This is my FIRST Guide!! So be easy Ps..im adding the photos now

[[Blackstorm]]

tell me what you guys think :biggthumpup:

[2dgreengiant]

this is awesoem thanks dude i actually needed this ^^ +9 rep

[[Blackstorm]]

thanks very much 2d

[Free Hugs]

Wow ive never seen a more simple guide thats short and easy to read


+2 rep

[[Blackstorm]]

thanks i really appreciate this

[Appled]

Hmm, what if i use Wamp Mysql, not normal mysql? :S cause wamp mysql host my server

[Anarchy [RD]]

very nice! +Rep for you

[Etherealamd]

Ok so I followed the guide but a remote user still could not connect. I believe it has something to do with my lan. Is it even possible to make this work through a lan? How does the remote computer know what computer to connect to inside of a lan?

[pwned22]

Thanks!
+rep

[flop159]

nice guide been looking for how to do this thx
+rep

[Ellenor]

Another advice is to make backup so you wont have nay promblems

[[Blackstorm]]

Im not sure about WAMP hosted server, sorry.

[Lich King]

Nice guide +Rep if it works

[[Blackstorm]]

@Zenneth

do u mean to make a backup of the database? ya...ur rite anyway. if ur friend screws up on the DB, u can redo the changes