Hello,


Is it possible to access to database without being 'localhost' user ? How can I configure it on the server ? I'm not sure if my question is clear either :D

Wish your help!

Thank you

You mean remotely - eg the database is on another server? Yes you can do that but the server has to be configured for it. Port 3306 has to be open on the firewall but generally making remote connections can be a security issue and is avoided.

While it is not advised, open your firewall (assuming you have one) to let 3306 in and out
as for the mysql setup, you must modify the mysql.user table (and possibly the mysql.db table) to have a user (and database entry) with the host "%" which will allow all hosts

well, thanks guys for the infos

I think I should forget that idea when my server is compromised.


Regards,

If you have an IP that is pretty much static, you can so as MaB suggested, but instead use your IP instead of %. If your IP changes, you could prolly do something like this. 111.222.%.% :) Of course, this still could open a security issue.

You can configure your firewall to only allow connections to port 3306 from that particular IP and set up a mysql user to connect from that IP and you should be pretty safe.

It seems you are talking about remote mysql access.

I would always suggest no to it...

But if you need to access it...
here is the way to do it

1)Get the static ip from your ISp(the ip with which you will be connecting )

2)Change the host enty in user table in mysql to this corresponding ip.

After making this change you will be able to connect remotly