View previous topic :: View next topic |
Author |
Message |
iplayfast l33t
![l33t l33t](/images/ranks/rank_rect_4.gif)
![](images/avatars/21247608843e3851d36b479.png)
Joined: 08 Jul 2002 Posts: 642 Location: Cambridge On,CA
|
Posted: Thu Jun 12, 2003 3:11 pm Post subject: mysql port open, why? |
|
|
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 |
|
![](templates/gentoo/images/spacer.gif) |
dev-null-devil Tux's lil' helper
![Tux's lil' helper Tux's lil' helper](/images/ranks/rank_rect_1.gif)
![](images/avatars/gallery/PowerPuffs/cartoon_powerpuff_blossom.gif)
Joined: 12 May 2003 Posts: 93
|
Posted: Thu Jun 12, 2003 3:13 pm Post subject: |
|
|
Code: | /etc/init.d/mysql stop |
_________________ All change, motion, and time is an illusion.
-- Plato, year 310 |
|
Back to top |
|
![](templates/gentoo/images/spacer.gif) |
iplayfast l33t
![l33t l33t](/images/ranks/rank_rect_4.gif)
![](images/avatars/21247608843e3851d36b479.png)
Joined: 08 Jul 2002 Posts: 642 Location: Cambridge On,CA
|
Posted: Thu Jun 12, 2003 3:14 pm Post subject: |
|
|
Um, I don't want to stop it, I just don't want it open to the world. |
|
Back to top |
|
![](templates/gentoo/images/spacer.gif) |
Jorito n00b
![n00b n00b](/images/ranks/rank_rect_0.gif)
![](images/avatars/2152671293e7de7cc35876.gif)
Joined: 23 Mar 2003 Posts: 7 Location: The Netherlands
|
Posted: Thu Jun 12, 2003 5:34 pm Post subject: |
|
|
Hmmm... iirc all you have to do is edit /etc/mysql/my.cnf. In that file, uncomment the line that says
and restart MySQL. _________________ This signature intentionally left blank. |
|
Back to top |
|
![](templates/gentoo/images/spacer.gif) |
kashani Advocate
![Advocate Advocate](/images/ranks/rank-G-1-advocate.gif)
![](images/avatars/9629732313ee51df8c5935.jpg)
Joined: 02 Sep 2002 Posts: 2032 Location: San Francisco
|
Posted: Thu Jun 12, 2003 5:39 pm Post subject: mysql ports |
|
|
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 |
|
![](templates/gentoo/images/spacer.gif) |
iplayfast l33t
![l33t l33t](/images/ranks/rank_rect_4.gif)
![](images/avatars/21247608843e3851d36b479.png)
Joined: 08 Jul 2002 Posts: 642 Location: Cambridge On,CA
|
Posted: Thu Jun 12, 2003 6:10 pm Post subject: |
|
|
Thanks guys, both these solutions look like they will do the trick. |
|
Back to top |
|
![](templates/gentoo/images/spacer.gif) |
samokk Tux's lil' helper
![Tux's lil' helper Tux's lil' helper](/images/ranks/rank_rect_1.gif)
![](images/avatars/gallery/The Matrix/movie_the_matrix_neo.gif)
Joined: 13 Jun 2003 Posts: 116 Location: Paris, France
|
Posted: Fri Jun 13, 2003 1:43 pm Post subject: |
|
|
Jorito wrote: | Hmmm... iirc all you have to do is edit /etc/mysql/my.cnf. In that file, uncomment the line that says
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 |
|
![](templates/gentoo/images/spacer.gif) |
|