Hey guys.I was wondering if there is any way to let someone control the db from his own pc.If ya know plz reply...
[HELP]How can i let someone connect to my db!
12/27/2008 16:39
rexes13#1
12/27/2008 17:23
Killin#2
Heres a small guide that should help.
First thing to do is open your navicat and then double click on your database such as this first picture
[Only registered and activated users can see links. Click Here To Register...]
Next you will right click on your database name and choose "Manage Users" Just like the following
[Only registered and activated users can see links. Click Here To Register...]
Next you will click "Add User"
[img]http://img187.imageshack.us/my.php?image=43525374hg7.png[img]
The next thing to do is fill out the new area.
In the Username field put their username to log in.
In the host put their ip, If your using hamachi put their hamachi ip here.
In the password field put their password.
In the repeat password, put their password again.
Then you click ok and it adds the user
[Only registered and activated users can see links. Click Here To Register...]
Next you will need to give them permissions.
On the left you will see the usernames that have access to your database, if you single left click on the new one, you will see all the fields to the right are unchecked. Check the ones that you want to give them permission for. Then hit save
[img]http://img187.imageshack.us/img187/493/34277154hl0.png[img]
Now for them to connect to your db, they will need to get navicat and make a new connection:
1: In the Label put anything to name your server.
2: In the host, they need to put your ip or hamachi ip to connect to your server.
3: In the username, they will enter the username you made earlier and then for the password its the one you created.
4. Next thing to do is test the connection and make sure it works. If it does then they have access, if it doesn't recheck all the other examples. Good luck.
First thing to do is open your navicat and then double click on your database such as this first picture
[Only registered and activated users can see links. Click Here To Register...]
Next you will right click on your database name and choose "Manage Users" Just like the following
[Only registered and activated users can see links. Click Here To Register...]
Next you will click "Add User"
[img]http://img187.imageshack.us/my.php?image=43525374hg7.png[img]
The next thing to do is fill out the new area.
In the Username field put their username to log in.
In the host put their ip, If your using hamachi put their hamachi ip here.
In the password field put their password.
In the repeat password, put their password again.
Then you click ok and it adds the user
[Only registered and activated users can see links. Click Here To Register...]
Next you will need to give them permissions.
On the left you will see the usernames that have access to your database, if you single left click on the new one, you will see all the fields to the right are unchecked. Check the ones that you want to give them permission for. Then hit save
[img]http://img187.imageshack.us/img187/493/34277154hl0.png[img]
Now for them to connect to your db, they will need to get navicat and make a new connection:
1: In the Label put anything to name your server.
2: In the host, they need to put your ip or hamachi ip to connect to your server.
3: In the username, they will enter the username you made earlier and then for the password its the one you created.
4. Next thing to do is test the connection and make sure it works. If it does then they have access, if it doesn't recheck all the other examples. Good luck.
12/27/2008 17:37
rexes13#3
ty a lot bro
12/27/2008 17:37
PhantomNyte#4
very good but what if u have a dinamic ip?
12/27/2008 17:53
Killin#5
I haven't tested it, but if you use a dns service it should still work in theory. Something such as no-ip's auto ip updater should fix the issue with a dynamic ip.
12/27/2008 17:59
rexes13#6
lol bro i followed the guide step by step and it isnt working
12/27/2008 19:16
DeathNoteEO#7
LOL ............. i have nothing to say at allQuote:
I haven't tested it, but if you use a dns service it should still work in theory. Something such as no-ip's auto ip updater should fix the issue with a dynamic ip.
12/27/2008 20:59
rexes13#8
does anybody know sth else that could help me?
12/27/2008 21:44
forcer#9
wont work.. because you don't have reverse dns entry. so you will be always connecting as a IP not as a no-ip host.Quote:
see Reverse DNS lookup - Wikipedia, the free encyclopedia
there is something you can do.. you can use % as wildcard for ip, so 212.145.% will allow to connect IP range: 212.145.0.1 to 212.145.255.255 unfortunately, MySQL 4.0 does not support netmasks at the end like 212.145.5.0/24 (that's network 212.145.5.0, mask 255.255.255.0)Quote:
12/28/2008 08:05
rexes13#10
i didnt understand lots of it but i want a guide on how to let others connect my db!!!Quote:
see Reverse DNS lookup - Wikipedia, the free encyclopedia
there is something you can do.. you can use % as wildcard for ip, so 212.145.% will allow to connect IP range: 212.145.0.1 to 212.145.255.255 unfortunately, MySQL 4.0 does not support netmasks at the end like 212.145.5.0/24 (that's network 212.145.5.0, mask 255.255.255.0)
12/28/2008 12:57
forcer#11
oh well.. just ask the one you want to let connect to your db for IP.Quote:
then run this query:
Code:
grant all on * to 'USERNAME'@'IP' identified by 'PASSWORD';
12/28/2008 15:12
rexes13#12
changed to what bro???Quote:
then run this query:
where USERNAME, IP and PASSWORD are needed to be changed.Code:grant all on * to 'USERNAME'@'IP' identified by 'PASSWORD';
12/28/2008 19:55
DeathNoteEO#13
he means in your sql queryQuote:
then run this query:
where USERNAME, IP and PASSWORD are needed to be changed.Code:grant all on * to 'USERNAME'@'IP' identified by 'PASSWORD';
12/28/2008 20:29
PhantomNyte#14
and can u use the hamachi ip?
12/28/2008 20:30
rexes13#15
if someone can explain it better it would be great....