[HELP]How can i let someone connect to my db!

[rexes13]

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...

[Killin]

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




Next you will right click on your database name and choose "Manage Users" Just like the following




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



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.

[rexes13]

ty a lot bro

[PhantomNyte]

very good but what if u have a dinamic ip?

[Killin]

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.

[rexes13]

lol bro i followed the guide step by step and it isnt working

[DeathNoteEO]

Originally Posted by Killin

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.

LOL ............. i have nothing to say at all

[rexes13]

does anybody know sth else that could help me?

[forcer]

Originally Posted by Killin

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.

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.
see Reverse DNS lookup - Wikipedia, the free encyclopedia

Originally Posted by rexes13

does anybody know sth else that could help me?

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)

[rexes13]

Originally Posted by forcer

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.
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)

i didnt understand lots of it but i want a guide on how to let others connect my db!!!

[forcer]

Originally Posted by rexes13

i didnt understand lots of it but i want a guide on how to let others connect my db!!!

oh well.. just ask the one you want to let connect to your db for IP.
then run this query:

grant all on * to 'USERNAME'@'IP' identified by 'PASSWORD';

where USERNAME, IP and PASSWORD are needed to be changed.

[rexes13]

Originally Posted by forcer

oh well.. just ask the one you want to let connect to your db for IP.
then run this query:

grant all on * to 'USERNAME'@'IP' identified by 'PASSWORD';

where USERNAME, IP and PASSWORD are needed to be changed.

changed to what bro???

[DeathNoteEO]

Originally Posted by forcer

oh well.. just ask the one you want to let connect to your db for IP.
then run this query:

grant all on * to 'USERNAME'@'IP' identified by 'PASSWORD';

where USERNAME, IP and PASSWORD are needed to be changed.

he means in your sql query

[PhantomNyte]

and can u use the hamachi ip?

[rexes13]

if someone can explain it better it would be great....