Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
mysql port open, why?
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Networking & Security
View previous topic :: View next topic  
Author Message
iplayfast
l33t
l33t


Joined: 08 Jul 2002
Posts: 642
Location: Cambridge On,CA

PostPosted: Thu Jun 12, 2003 3:11 pm    Post subject: mysql port open, why? Reply with quote

I'm setting up a web server and have emerged a minimum of things. It's an old pc and I'm trying to keep it's load light.

My requirements are ssh (for offsite access) apache for serving the docs and mysql.

The mysql port is open. Does it need to be? It will only be accessed from cgi's running locally on the webserver. So can I close it and if so how?

tia
Back to top
View user's profile Send private message
dev-null-devil
Tux's lil' helper
Tux's lil' helper


Joined: 12 May 2003
Posts: 93

PostPosted: Thu Jun 12, 2003 3:13 pm    Post subject: Reply with quote

Code:
/etc/init.d/mysql stop

_________________
All change, motion, and time is an illusion.
-- Plato, year 310
Back to top
View user's profile Send private message
iplayfast
l33t
l33t


Joined: 08 Jul 2002
Posts: 642
Location: Cambridge On,CA

PostPosted: Thu Jun 12, 2003 3:14 pm    Post subject: Reply with quote

Um, I don't want to stop it, I just don't want it open to the world.
Back to top
View user's profile Send private message
Jorito
n00b
n00b


Joined: 23 Mar 2003
Posts: 7
Location: The Netherlands

PostPosted: Thu Jun 12, 2003 5:34 pm    Post subject: Reply with quote

Hmmm... iirc all you have to do is edit /etc/mysql/my.cnf. In that file, uncomment the line that says
Code:
#skip-networking

and restart MySQL.
_________________
This signature intentionally left blank.
Back to top
View user's profile Send private message
kashani
Advocate
Advocate


Joined: 02 Sep 2002
Posts: 2032
Location: San Francisco

PostPosted: Thu Jun 12, 2003 5:39 pm    Post subject: mysql ports Reply with quote

you can also edit with the startup script and bind it to local host only.

Code:

 /usr/bin/safe_mysqld  --defaults-file=/etc/my.cnf --bind-address=127.0.0.1 >/dev/null 2>&1 &


kashani
_________________
Will personally fix your server in exchange for motorcycle related shop tools in good shape.
Back to top
View user's profile Send private message
iplayfast
l33t
l33t


Joined: 08 Jul 2002
Posts: 642
Location: Cambridge On,CA

PostPosted: Thu Jun 12, 2003 6:10 pm    Post subject: Reply with quote

Thanks guys, both these solutions look like they will do the trick.
Back to top
View user's profile Send private message
samokk
Tux's lil' helper
Tux's lil' helper


Joined: 13 Jun 2003
Posts: 116
Location: Paris, France

PostPosted: Fri Jun 13, 2003 1:43 pm    Post subject: Reply with quote

Jorito wrote:
Hmmm... iirc all you have to do is edit /etc/mysql/my.cnf. In that file, uncomment the line that says
Code:
#skip-networking

and restart MySQL.



or use some firewall rule to block the port...

but yeah, not opening it at all is always more secure... :)

sam
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Networking & Security All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum