Results 1 to 3 of 3
Mar 6, 2003, 12:17 #1
Running MySQL without TCP port???
Is this possible, I have a need to shutdown mysql's port and use another method if possible. My client doesn't want anything listening on a tcp port since they have limited firewall and router port blocking support.
In other words. Does it HAVE to have a port assignment, or can it connect through say, named pipes, or some other protocol?
Mar 6, 2003, 18:44 #2
- Join Date
- Jul 2001
- 0 Post(s)
- 0 Thread(s)
if the connections are only local, you don't need to use TCP/IP connections. in fact, you shouldn't if you want the fastest connection.
on *nix, if you're connecting with the special hostname "localhost," it uses a Unix socket connection, no TCP/IP and therefore no port.
on Windows NT/2000/XP, start mysqld with --enable-named-pipe in your my.ini and then leave the host parameter blank (in PHP's mysql_connect() or whatever) and it will connect with named-pipes.
to disable mysqld listening on any TCP port, start it with skip-networking in your my.cnf/my.ini. this is actually recommended in the MySQL manual if you only have local connections.
hope that helps.- Matt ** Ignore old signature for now... **
Dr.BB - Highly optimized to be 2-3x faster than the "Big 3."
"Do not enclose numeric values in quotes -- that is very non-standard and will only work on MySQL." - MattR
Mar 6, 2003, 19:13 #3
Yes, thanks! Initially that helps very much. I went to mysql.com and researched that option. I think I can come up with a solution for my client. Thanks again.