#1  
Old 19th November 2005, 09:05
southcot southcot is offline
Junior Member
 
Join Date: Nov 2005
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Enabling MySQL on port

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?
Reply With Quote
  #2  
Old 19th November 2005, 13:03
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 31,853
Thanks: 781
Thanked 1,558 Times in 1,477 Posts
Default

Can you post your /etc/mysql/my.cnf file here?
__________________
Falko
--
Follow me on:
Reply With Quote
  #3  
Old 19th November 2005, 14:58
southcot southcot is offline
Junior Member
 
Join Date: Nov 2005
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for the speedy response, file attached as requested.
Attached Files
File Type: txt my.cnf.txt (3.2 KB, 305 views)
Reply With Quote
  #4  
Old 19th November 2005, 15:48
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 31,853
Thanks: 781
Thanked 1,558 Times in 1,477 Posts
Default

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
__________________
Falko
--
Follow me on:
Reply With Quote
  #5  
Old 19th November 2005, 22:39
southcot southcot is offline
Junior Member
 
Join Date: Nov 2005
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Many Many thanks that did the trick.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem installing ISPConfig, then with MySQL... ctroyp Installation/Configuration 7 26th September 2005 17:37
MySQL issue during install of ISPConfig ricbax Installation/Configuration 4 16th September 2005 10:41
Mysql ejs Installation/Configuration 5 12th August 2005 08:01
Problem opening firewall port weedguy General 15 12th August 2005 02:05
MySQL Privileges mcfly Server Operation 4 26th May 2005 20:00


All times are GMT +2. The time now is 06:12.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Sponsored Links: Unified Communications: Thoughts, Strategies and Predictions
Join the discussion.
www.seamlessenterprise.com

IP Convergence
Integrate your wireless and wireline networks.
Learn how from the experts at Sprint.
www.seamlessenterprise.com

Wireless & Wireline Integration
Thoughts, strategies and solutions: join the discussion
www.seamlessenterprise.com

Unified Communications 2009
Join the Discussion. Now.
www.seamlessenterprise.com

Red Hat Virtual Experience - a free virtual event. Dec. 9th