Enabling MySQL on port

Discussion in 'HOWTO-Related Questions' started by southcot, Nov 19, 2005.

  1. southcot

    southcot New Member

    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?
     
  2. falko

    falko Super Moderator

    Can you post your /etc/mysql/my.cnf file here?
     
  3. southcot

    southcot New Member

    Thanks for the speedy response, file attached as requested.
     

    Attached Files:

  4. falko

    falko Super Moderator

    Comment out the line
    Code:
    bind-address            = 127.0.0.1
    so that it reads
    Code:
    #bind-address            = 127.0.0.1
    and restart MySQL:
    Code:
    /etc/init.d/mysql restart
     
  5. southcot

    southcot New Member

    Many Many thanks that did the trick.
     

Share This Page