LinuxQuestions.org
Latest LQ Deal: Linux Power User Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 07-19-2011, 10:12 AM   #1
cleibesouza
LQ Newbie
 
Registered: Jul 2011
Posts: 6

Rep: Reputation: Disabled
Changing mysql default port


Hi all,
I'm trying to change the default mysql port with no success. I looked at my.cnf file and there's no reference to port. I also looked at the iptables and mysql is running on 3306 (default).
I've changed the iptable file but mysql fails to restart.
If I add port = [my port number] to the my.cnf file, mysql fails to start.

I'm surely missing something. Any ideas?

Thanks.
 
Old 07-19-2011, 10:42 AM   #2
acid_kewpie
Moderator
 
Registered: Jun 2001
Location: UK
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,417

Rep: Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974
well that's the right thing to do, so what actually happens when you add "port=1234" ?
 
Old 07-19-2011, 11:08 AM   #3
cleibesouza
LQ Newbie
 
Registered: Jul 2011
Posts: 6

Original Poster
Rep: Reputation: Disabled
Quote:
well that's the right thing to do, so what actually happens when you add "port=1234" ?
After I change port number mysql doesn't start.
 
Old 07-19-2011, 11:19 AM   #4
acid_kewpie
Moderator
 
Registered: Jun 2001
Location: UK
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,417

Rep: Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974
yes you said that already. what errors are there? have you run mysqld in the foreground to look?
 
Old 07-19-2011, 11:34 AM   #5
cleibesouza
LQ Newbie
 
Registered: Jul 2011
Posts: 6

Original Poster
Rep: Reputation: Disabled
Quote:
yes you said that already. what errors are there? have you run mysqld in the foreground to look?
No errors. It just says [FAIL] after the restart command.
Sorry but I don't know what you mean by "have you run mysqld in the foreground to look?", but I'm willing to do it if you explain me how.

Thanks.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing the location a module is loaded from without changing the default path zOSGuy Linux - Newbie 2 09-28-2010 03:43 PM
Changing SSH default port ceantuco Linux - Newbie 5 04-22-2010 03:04 AM
changing default port of SSH service redscorpion69 Linux - Networking 4 11-18-2009 05:27 AM
Telnet default port changing shivanrathore Linux - Newbie 1 10-17-2008 12:20 PM
Sendmail and changing it's default listening port... darkarcon2015 Slackware 7 01-21-2005 12:17 AM


All times are GMT -5. The time now is 03:13 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration