LinuxQuestions.org
Share your knowledge at the LQ Wiki.
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 01-28-2011, 08:50 AM   #1
Vcepelin
LQ Newbie
 
Registered: Apr 2009
Posts: 20

Rep: Reputation: 0
Mysql Problem


Hello all
I have a problem starting MySQL server
In mysqld.log i have these messages

110128 05:04:24 mysqld ended

110128 06:00:10 mysqld started
110128 6:00:10 InnoDB: Started; log sequence number 0 59427073
110128 6:00:10 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
110128 6:00:10 [ERROR] Do you already have another mysqld server running on port: 3306 ?
110128 6:00:10 [ERROR] Aborting

110128 6:00:10 InnoDB: Starting shutdown...
110128 6:00:12 InnoDB: Shutdown completed; log sequence number 0 59427073
110128 6:00:12 [Note] /usr/sbin/mysqld-max: Shutdown complete

110128 06:00:12 mysqld ended

I would be happy if you help me.
 
Old 01-28-2011, 09:41 AM   #2
AlucardZero
Senior Member
 
Registered: May 2006
Location: USA
Distribution: Debian
Posts: 4,808

Rep: Reputation: 604Reputation: 604Reputation: 604Reputation: 604Reputation: 604Reputation: 604
Do you already have another mysqld server (or ANYTHING) running on port: 3306 ?
Code:
lsof -i tcp:3306
If so, stop whatever is taking port 3306, or change MYSQL to a different port.
 
Old 02-03-2011, 11:31 AM   #3
Vcepelin
LQ Newbie
 
Registered: Apr 2009
Posts: 20

Original Poster
Rep: Reputation: 0
I have solved my problem, thanks for the answer anyway.
The problem was that i changed my IP settings
and the sql server was configured with the old IP address
of my machine, i changed it to 127.0.0.1 and it worked fine
 
  


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
Problem changing mysql uid,gid: mysql start fails gjatute Linux - Newbie 7 02-25-2010 02:38 AM
Bugzilla - MySQL - perl - DBD::mysql install problem amchargue Linux - Software 3 09-10-2008 01:01 AM
Problem Starting MySQL on Fresh Fedora 8 Install w/ Yum'd MySQL blong4life Linux - Server 2 07-04-2008 08:44 PM
Bugzilla - MySQL - perl - DBD::mysql install problem Runningonair Linux - Software 8 10-12-2007 01:42 AM
php-mysql dependancy problem after nitemare mysql upgrade. RHEL4 andrewc Red Hat 1 01-03-2006 05:16 PM


All times are GMT -5. The time now is 08:37 PM.

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