[Request Help] dual database access

Quote:

Originally Posted by King_Arthur Quote: Originally Posted by Medo21 i made what u said,but it don't work,i want someone tell me how to make someone connect to my db ? and what this one should do? and ty arthur for ur guide Code: 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: Code: 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.

Quote:

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.

Quote:

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.