Archive for May, 2007

Custom MySQL port and more

tom on May 12th, 2007

Edit your /etc/my.cnf File and add something similar to this:

[mysqld]
user = mysql
pid-file = /var/lib/mysql/server.mysite.net.pid
socket = /var/lib/mysql/mysql.sock
port = 3307
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
bind-address = localhost
[/mysqld]

This will change the port to 3307, which is what I did. The other options are pretty much default, but they are included so you can alter then to your liking.

Post a comment | Comments Off