[Guide] Give A User Permission to Access Your Database menu

These ads disappear when you log in.

Results 1 to 5 of 5
  1. #1
    [Blackstorm]'s Avatar Contributor
    Reputation
    101
    Join Date
    Oct 2007
    Posts
    424
    Thanks G/R
    0/0
    Trade Feedback
    1 (100%)

    [Guide] Give A User Permission to Access Your Database

    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!


    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: Only trust close people... otherwise your server can seriously damaged!


    These ads disappear when you log in.

  2. #2
    gimmeurlife's Avatar Member
    Reputation
    12
    Join Date
    Aug 2008
    Posts
    99
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Good job here man I use Heidisql and have been using the "Add User" section for some time with another person i am putting together a server with but many people will benefit from this guide. +Rep soon as i can

  3. #3
    Rayuski's Avatar Corporal
    Reputation
    3
    Join Date
    May 2009
    Posts
    32
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)

    guide

    Good guide

  4. #4
    ZGoldsmith92's Avatar Corporal
    Reputation
    1
    Join Date
    Jun 2008
    Posts
    20
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Thanks alot. Really needed this! +rep!

  5. #5
    Glorianglorre's Avatar Active Member
    Reputation
    40
    Join Date
    Feb 2009
    Posts
    337
    Thanks G/R
    1/0
    Trade Feedback
    0 (0%)
    Thanks i didn't know how to do this +Rep!

Similar Threads

  1. [Guide] Best way to let ppl into your DataBase!
    By Sebastian011 in forum WoW EMU Guides & Tutorials
    Replies: 6
    Last Post: 01-05-2009, 03:10 PM
  2. How to let others access your database
    By sgtbullfire in forum WoW EMU Guides & Tutorials
    Replies: 9
    Last Post: 09-24-2008, 03:14 PM
  3. Replies: 1
    Last Post: 08-22-2008, 06:32 PM
  4. [GUIDE] Give Permission For A User to Enter Your Database
    By [Blackstorm] in forum WoW EMU Guides & Tutorials
    Replies: 27
    Last Post: 07-03-2008, 06:02 AM
  5. [GUIDE] Give Permission for A User to Enter Your Database
    By [Blackstorm] in forum World of Warcraft Emulator Servers
    Replies: 7
    Last Post: 01-26-2008, 08:53 PM
All times are GMT -5. The time now is 09:00 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved. Digital Point modules: Sphinx-based search