LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   Mysql Problem (https://www.linuxquestions.org/questions/linux-newbie-8/mysql-problem-859220/)

Vcepelin 01-28-2011 07:50 AM

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.

AlucardZero 01-28-2011 08:41 AM

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.

Vcepelin 02-03-2011 10:31 AM

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


All times are GMT -5. The time now is 05:43 AM.