Hi everyone,
Is there a way to lock down mysql so it only accepts connections from the Local Host?
Thanks
Mabs
Locking down MySql
Moderator: General Moderators
- superdezign
- DevNet Master
- Posts: 4135
- Joined: Sat Jan 20, 2007 11:06 pm
Just myself.superdezign wrote:Who else has access to it??
I ideally what I would like to say is. Only allow the IP address of my machine to connect and also allow all server side scripts to run. If it means I have to lock it down to server side only and access the database via the web interface I will.
Mabsey
All you have to do then is ensure that every MySQL user only has access from localhost. Then you can create a single account that has remote access for you to use remotely. You can do this in phpMyAdmin if your not sure how to.
Other solutions would be to disable all remote access, then create a tunnel over SSH and access the database that way.
Other solutions would be to disable all remote access, then create a tunnel over SSH and access the database that way.
- superdezign
- DevNet Master
- Posts: 4135
- Joined: Sat Jan 20, 2007 11:06 pm