Re: [cobalt-users] MYSQL Variables

[k k <ircservices@xxxxxxxxxxxxx>]

Hello,

To disable networking and only use Unix Sockets, recompile MySQL with:

./congifure  xxxxxx  --skip-networking

Where xxxxxx is your usual configuration params.

Note: This will disable all connections to port 3306 and also it takes 
away the valuable feature "Replication" where the a second MySQL server 
need to make connection to the master server for synchronization stuff. 
If you have only one server and only allow local connection, use the 
above, it's faster and much more secured.


Regards,

KN



> Hi Rodolfo,
> 
>> The "mysql socket" you mention on the first line *is* the port. The 
port
> is
>> the only way MySQL accepts connections, and that's how most things 
work on
>> a Linux box. Therefore it *must* be open as someone replied.
> 
> No, that is _not_ correct.
> 
> There is two totally different terms here:
> 
> 1. TCP/IP port. This is a "networking" thing, and works for both 
local and
> remote connections.
> 
> 2. Unix socket. This can only be used for local connections, but is 
faster
> than using the TCP/IP port.
> 
> You can setup MySQL to not allow TCP/IP connections, and thus only 
allow
> local connections using Unix sockets.
> 
> --
> Jens Kristian Søgaard, Mermaid Consulting I/S,
> jens@xxxxxxxxxxxxxxxxxxxx,
> http://www.mermaidconsulting.com/
> 
> 
> _______________________________________________
> cobalt-users mailing list
> cobalt-users@xxxxxxxxxxxxxxx
> To Subscribe or Unsubscribe, please go to:
> http://list.cobalt.com/mailman/listinfo/cobalt-users


------------------------------------
Powered by <a href=http://www.vietmedia.com>http://www.vietmedia.com</a>
Free E-mail, Instant Messaging, and more!