{"id":530,"date":"2009-05-12T19:35:20","date_gmt":"2009-05-12T16:35:20","guid":{"rendered":"http:\/\/www.void.gr\/kargig\/blog\/?p=530"},"modified":"2009-05-12T19:35:20","modified_gmt":"2009-05-12T16:35:20","slug":"mysql-not-starting","status":"publish","type":"post","link":"https:\/\/www.void.gr\/kargig\/blog\/2009\/05\/12\/mysql-not-starting\/","title":{"rendered":"mysql not starting"},"content":{"rendered":"

comzeradd<\/a> send me an e-mail about a mysql service not starting in a server we administer. I started taking a look around…nothing seemed suspicious.
\nI tried uninstalling and re-installing mysql-server-5.0 a few times and I always got this kind of output from apt-get:<\/p>\n

Stopping MySQL database server: mysqld.
\nStarting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
\ninvoke-rc.d: initscript mysql, action “start” failed.
\ndpkg: error processing mysql-server-5.0 (–configure):
\n subprocess post-installation script returned error exit status 1
\nErrors were encountered while processing:
\n mysql-server-5.0
\nReading package lists… Done
\nBuilding dependency tree
\nReading state information… Done
\nReading extended state information
\nInitializing package states… Done
\nReading task descriptions… Done\n<\/p><\/blockquote>\n


\nReconfiguring the package just prompted me to input a new root password, still it could not start. Here’s what the syslog output looked like:<\/p>\n

May 12 16:19:56 foo mysqld_safe[24776]: started
\nMay 12 16:19:56 foo mysqld[24779]: 090512 16:19:56 InnoDB: Started; log sequence number 0 43655
\nMay 12 16:19:56 foo mysqld[24779]: 090512 16:19:56 [ERROR] Can’t start server: Bind on TCP\/IP port: Cannot assign requested addr
\ness
\nMay 12 16:19:56 foo mysqld[24779]: 090512 16:19:56 [ERROR] Do you already have another mysqld server running on port: 3306 ?
\nMay 12 16:19:56 foo mysqld[24779]: 090512 16:19:56 [ERROR] Aborting
\nMay 12 16:19:56 foo mysqld[24779]:
\nMay 12 16:19:56 foo mysqld[24779]: 090512 16:19:56 InnoDB: Starting shutdown…
\nMay 12 16:19:58 foo mysqld[24779]: 090512 16:19:58 InnoDB: Shutdown completed; log sequence number 0 43655
\nMay 12 16:19:58 foo mysqld[24779]: 090512 16:19:58 [Note] \/usr\/sbin\/mysqld: Shutdown complete
\nMay 12 16:19:58 foo mysqld[24779]:
\nMay 12 16:19:58 foo mysqld_safe[24816]: ended<\/p><\/blockquote>\n

But there was no other mysql server running. I then typed ifconfig and here’s the output:<\/p>\n

lo Link encap:Local Loopback
\n LOOPBACK MTU:16436 Metric:1
\n RX packets:0 errors:0 dropped:0 overruns:0 frame:0
\n TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
\n collisions:0 txqueuelen:0
\n RX bytes:0 (0.0 B) TX bytes:0 (0.0 B)\n<\/p><\/blockquote>\n

The loopback did not have an IP address!!!<\/strong>
\nI looked inside mysql’s my.cnf and mysqld had<\/p>\n

bind-address = 127.0.0.1<\/p><\/blockquote>\n

The command:
\nifconfig lo 127.0.0.1<\/code>
\nfixed the problem \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"

comzeradd send me an e-mail about a mysql service not starting in a server we administer. I started taking a look around…nothing seemed suspicious. I tried uninstalling and re-installing mysql-server-5.0 a few times and I always got this kind of output from apt-get: Stopping MySQL database server: mysqld. Starting MySQL database server: mysqld . . […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"footnotes":""},"categories":[3],"tags":[92,33,90,595,91,19],"class_list":["post-530","post","type-post","status-publish","format-standard","hentry","category-linux","tag-bind-address","tag-debian","tag-init","tag-linux","tag-loopback","tag-mysql"],"aioseo_notices":[],"views":5796,"_links":{"self":[{"href":"https:\/\/www.void.gr\/kargig\/blog\/wp-json\/wp\/v2\/posts\/530","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.void.gr\/kargig\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.void.gr\/kargig\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.void.gr\/kargig\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.void.gr\/kargig\/blog\/wp-json\/wp\/v2\/comments?post=530"}],"version-history":[{"count":4,"href":"https:\/\/www.void.gr\/kargig\/blog\/wp-json\/wp\/v2\/posts\/530\/revisions"}],"predecessor-version":[{"id":534,"href":"https:\/\/www.void.gr\/kargig\/blog\/wp-json\/wp\/v2\/posts\/530\/revisions\/534"}],"wp:attachment":[{"href":"https:\/\/www.void.gr\/kargig\/blog\/wp-json\/wp\/v2\/media?parent=530"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.void.gr\/kargig\/blog\/wp-json\/wp\/v2\/categories?post=530"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.void.gr\/kargig\/blog\/wp-json\/wp\/v2\/tags?post=530"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}