PDA

View Full Version : Enabling MySQL on port


southcot
19th November 2005, 08:05
I am very much a Linux newbie. I have just installed MySQL on Ubuntu. I want it to be available to my other PCs but I can't seem to get it to listen on port 3306. Can anyone help me achieve this?

falko
19th November 2005, 12:03
Can you post your /etc/mysql/my.cnf file here?

southcot
19th November 2005, 13:58
Thanks for the speedy response, file attached as requested.

falko
19th November 2005, 14:48
Comment out the line
bind-address = 127.0.0.1
so that it reads
#bind-address = 127.0.0.1
and restart MySQL:
/etc/init.d/mysql restart

southcot
19th November 2005, 21:39
Many Many thanks that did the trick.