can somebody tell me really quick how to give database access on navicat and be detailed so i dont get confused and also what the other person is suppose to do when i give access
can somebody tell me really quick how to give database access on navicat and be detailed so i dont get confused and also what the other person is suppose to do when i give access
First you login to the database, up beside "connection" you see a big icon with the next "Manage Users". Click on that.
You will not get a new window up, find the text "Add User" and click on that.
Fill in Hostname and Password first, this will be HIS login settings, can be whatever you want. He will use this information. On the Host: you will enter HIS IP adress, not the server one, his. He can find it on What is my IP address? Show my IP address. IP Tracer & IP Locator..
(If you are using hamachi you writes his hamachi IP there).
Now you hit Ok
Now it's time to give him permissions, the easiest way is just to give him persmision to everything, to do this you click on "Select all" and then save.
To give him persmission to just ONE database, you click on the + rign beside his username, click on the database you want him to access to. And select all again and save. You can also remove stuff like permission to delete.
thanx i would +rep but i need to spread