FUDforum: Database discussions » binding mysql to localhost (I/O)

Home » General » Database discussions » binding mysql to localhost (I/O)

Show: Today's Messages :: Polls :: Message Navigator

Re: binding mysql to localhost (I/O) [message #3046 is a reply to message #3030]

Sat, 08 June 2002 10:20

Olliver

Messages: 443
Registered: March 2002

Karma:

Senior Member

Hi,
Meanwhile I did a bit of testing and playing around and found the following as the most useful solution:
The arguments can all be conveniently passed over to the daemon via /etc/my.cnf.The following illustrates the section in my.cnf, where the entry has to be made:

Case 1 (binding SQL just to interface I/0):

[mysqld]
[...]
bind-address=127.0.0.1

This will the daemon cause just to listen on the loopback device, so no one in the network will have an idea that there's a daemon at all, because they are accessing the machine from a different interface (eth0, eth1 etc). Makes sense where SQL and httpd are hogging up the same machine.

Case 2 (disabling TCP/IP completely):

[mysqld]
[...]
skip networking

Now SQL only listens on local unix sockets, a solution I do prefer over the first one, because it's always better to reduce the amount of services on a machine (even if they're running on loopback) since it makes it less vulnerable.
bye Ken

Report message to a moderator

[Message index]

		binding mysql to localhost (I/O) By: Olliver on Fri, 07 June 2002 17:45
		Re: binding mysql to localhost (I/O) By: hackie on Fri, 07 June 2002 18:07
		Re: binding mysql to localhost (I/O) By: Olliver on Fri, 07 June 2002 19:12
		Re: binding mysql to localhost (I/O) By: Olliver on Sat, 08 June 2002 10:20

Previous Topic:	Tip for mysql
Next Topic:	Scheduling Actions - Automation 101 question.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 04:35:04 GMT 2024

Total time taken to generate the page: 0.04028 seconds