Hi!!
Yes you can use..and you need to specify this in the options file (my.cnf/my.ini)..thgis would be required when you have to run multiple servers on the same machine.. your options file should be something like this..
[mysqld2]
socket = /tmp/mysql.sock2
port = 3307
pid-file = /usr/local/mysql/var2/hostname.pid2
datadir = /usr/local/mysql/var2
language = /usr/local/share/mysql/english
user = umesh
[mysqld3]
socket = /tmp/mysql.sock3
port = 3308
pid-file = /usr/local/mysql/var3/hostname.pid3
datadir = /usr/local/mysql/var3
language = /usr/local/share/mysql/swedish
user = shastry
Check out the manual for more details on how to do this..
Regards,
Umesh Shastry
http://www.blogger.com/profile/02551756983528645221