[Request Help] dual database access

[Crazy123456]

can someone make a guide how to access the database threw navicat threw another computer. if so it would be very helpfull to me and many others

[King_Arthur]

Well you can use this quote to add a mysql user which is the biggest part:

Originally Posted by King_Arthur

grant all privileges on *.* to 'username' @ 'ipaddress' identified by 'password';

This will give whatever person you put in full database access to do anything but add other people. They could potentially drop your whole database if they wanted to. So you should use a nice GUI like navicat and remove what you don't want them to have access to. On the other side, you could do:

grant usage on *.* to 'username' @ 'ipaddress' identified by 'password';

and then add only what you want them to have access to. The first option is usually easier.

If that is all setup correctly then you just need to have port 3306 open to your server and allow inbound connections in your firewall for the user you wish to allow access to.

[Crazy123456]

Originally Posted by King_Arthur

Well you can use this quote to add a mysql user which is the biggest part:


If that is all setup correctly then you just need to have port 3306 open to your server and allow inbound connections in your firewall for the user you wish to allow access to.

i don't really undertstand.... can you explain it better please

[~WARNING~]

open port 3306, run the queries he listed, and give your IP, and your MySQL username and password to the people you want to access the database.

[jayk10304]

Originally Posted by ibeatuall

open port 3306, run the queries he listed, and give your IP, and your MySQL username and password to the people you want to access the database.

external or internal IP?


so if my pass and id is root and test, how does he use it? Do i give him 1? And why are u never on msn any more mister?

[Crazy123456]

external. next time make your own post this is an old one.

[~Sword~Stalker~.]

well u need to make some tests for it to work

first of all change ur sig. having another forum as epvp announced even with a link back would give u a Ban ..

Regards