#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
Sponsored Links
  #2  
Old 19th November 2005, 13:03
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,749 Times in 2,579 Posts
Default

Can you post your /etc/mysql/my.cnf file here?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | 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, 528 views)
Reply With Quote
  #4  
Old 19th November 2005, 15:48
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,749 Times in 2,579 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
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | 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 08:22.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.