Failed to Start Mysqld

[canifer]

Hello, I'm using Fedora 17 and installed MySQL 5.5.23 by executing #yum install mysql mysql-server about 3 months ago.
Recently, I have a problem to start MySQL in my school server, when I execute

#service mysqld start

The output said:

Redirecting to /bin/systemctl  start mysqld.service
Job failed. See system journal and 'systemctl status' for details.

so, I sxecuted:

#systemctl status mysqld.service

resulting

mysqld.service - MySQL database server
	  Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled)
	  Active: activating (start-post) since Tue, 02 Oct 2012 02:15:25 +0700; 357ms ago
	 Process: 14803 ExecStart=/usr/bin/mysqld_safe --nowatch --basedir=/usr (code=exited, status=0/SUCCESS)
	 Process: 14787 ExecStartPre=/usr/libexec/mysqld-prepare-db-dir (code=exited, status=0/SUCCESS)
	Main PID: 15015 (mysqld); Control: 15016 (mysqld-wait-rea)
	  CGroup: name=systemd:/system/mysqld.service
		  ├ 15015 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys...
		  ├ 15016 /bin/sh /usr/libexec/mysqld-wait-ready 15015
		  └ 15035 sleep 1

Oct 02 02:15:25 devel-ptiik.xx.xx.xx mysqld_safe[14803]: 121002 02:15:25 mysqld_safe...
Oct 02 02:15:25 devel-ptiik.xx.xx.xx mysqld_safe[14803]: 121002 02:15:25 mysqld_safe...

and this is what I get from /var/log/mysql.log

121002 02:04:20 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
121002  2:04:20 [Note] Plugin 'FEDERATED' is disabled.
121002  2:04:20 InnoDB: The InnoDB memory heap is disabled
121002  2:04:20 InnoDB: Mutexes and rw_locks use GCC atomic builtins
121002  2:04:20 InnoDB: Compressed tables use zlib 1.2.5
121002  2:04:20 InnoDB: Using Linux native AIO
121002  2:04:20 InnoDB: Initializing buffer pool, size = 128.0M
121002  2:04:20 InnoDB: Completed initialization of buffer pool
121002  2:04:20 InnoDB: highest supported file format is Barracuda.
121002  2:04:20  InnoDB: Waiting for the background threads to start
121002  2:04:21 InnoDB: 1.1.8 started; log sequence number 164218417
121002  2:04:21 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
121002  2:04:21 [ERROR] Do you already have another mysqld server running on port: 3306 ?
121002  2:04:21 [ERROR] Aborting

121002  2:04:21  InnoDB: Starting shutdown...
121002  2:04:22  InnoDB: Shutdown completed; log sequence number 164218417
121002  2:04:22 [Note] /usr/libexec/mysqld: Shutdown complete

please help to solve this problem, I'm still confused. what's going on?
I appreciate any answers
sorry for my English

[6e617a696d]

Do 'ps -elf|grep mysql' and 'netstat -tulpn|grep LISTEN' see if mysql is listed.

121002 2:04:21 [ERROR] Do you already have another mysqld server running on port: 3306 ?

Says that something is listening port 3306.

Also check /etc/my.cnf.

[canifer]

Originally Posted by 6e617a696d

Do 'ps -elf|grep mysql' and 'netstat -tulpn|grep LISTEN' see if mysql is listed.



Says that something is listening port 3306.

Also check /etc/my.cnf.

Hello, thanks for your response.
here is what I get from 'ps -elf|grep mysqld'

0 S mysql    28292     1  6  80   0 - 103047 poll_s 06:38 ?       00:00:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock --port=3306
4 S mysql    28293     1  0  80   0 - 28538 wait   06:38 ?        00:00:00 /bin/sh /usr/libexec/mysqld-wait-ready 28292
0 S mysql    28312 28293  0  80   0 - 26711 hrtime 06:38 ?        00:00:00 sleep 1
0 S ivan     28329 22878  0  80   0 - 27350 pipe_w 06:38 pts/0    00:00:00 grep --color=auto mysql

looking from that output, I think the mySQL process is stuck waiting state. Then after execute 'netstat -tulpn|grep LISTEN' I got this output:

tcp        0      0 0.0.0.0:111             0.0.0.0:*               LISTEN      804/rpcbind         
tcp        0      0 0.0.0.0:80              0.0.0.0:*               LISTEN      831/httpd           
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      803/sshd            
tcp        0      0 127.0.0.1:25            0.0.0.0:*               LISTEN      818/sendmail: accep 
tcp        0      0 0.0.0.0:443             0.0.0.0:*               LISTEN      831/httpd           
tcp        0      0 0.0.0.0:44350           0.0.0.0:*               LISTEN      816/rpc.statd       
tcp6       0      0 :::43149                :::*                    LISTEN      816/rpc.statd       
tcp6       0      0 :::111                  :::*                    LISTEN      804/rpcbind         
tcp6       0      0 :::22                   :::*                    LISTEN      803/sshd

There is no single process listening from port 3306

[jpollard]

Does it run if you restart it after a manual restart?