Find the answer to your Linux question:
Results 1 to 5 of 5
Hi, I have a LAMP server running Fedora 7. I have run mysql without issue multiple times, and have built a nice DB on top of it. After a restart ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Jan 2008
    Posts
    3

    MySQL no longer starting - please help!


    Hi, I have a LAMP server running Fedora 7. I have run mysql without issue multiple times, and have built a nice DB on top of it.

    After a restart last night, I cannot get the mysql server to start up, but get a strange error that it cannot bind to the port.

    If I use the standard port:

    [root@localhost init.d]# /usr/libexec/mysqld -
    080122 20:02:44 InnoDB: Started; log sequence number 0 43705
    080122 20:02:44 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
    080122 20:02:44 [ERROR] Do you already have another mysqld server running on port: 3306 ?
    080122 20:02:44 [ERROR] Aborting

    080122 20:02:44 InnoDB: Starting shutdown...
    080122 20:02:46 InnoDB: Shutdown completed; log sequence number 0 43705
    080122 20:02:46 [Note] /usr/libexec/mysqld: Shutdown complete
    I tried finding other services on this port, but finding none tried various other random ports, all give the same message:

    [root@localhost init.d]# /usr/libexec/mysqld --port 123456
    080122 20:04:32 InnoDB: Started; log sequence number 0 43705
    080122 20:04:32 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
    080122 20:04:32 [ERROR] Do you already have another mysqld server running on port: 123456 ?
    080122 20:04:32 [ERROR] Aborting

    080122 20:04:32 InnoDB: Starting shutdown...
    080122 20:04:34 InnoDB: Shutdown completed; log sequence number 0 43705
    080122 20:04:34 [Note] /usr/libexec/mysqld: Shutdown complete
    Any ideas why this might happen? The only change I see is that a new IP was assigned on the local network, but I don't see how this should be an issue since it should be using the local host, and loopback is on.

    (And before you ask, I am not using the start up script simply because I am trying to debug the issue)

  2. #2
    Linux Newbie athlon_crazy's Avatar
    Join Date
    Sep 2007
    Location
    Malaysia
    Posts
    132
    I 'd the same prob with DSL linux last time. PID, mysql.sock could be the reason why it wont start even you properly stop mysql.

    Some how, reboot the server solved my problem.

  3. #3
    Just Joined!
    Join Date
    Jan 2008
    Posts
    3
    Yeah, I tried rebooting a couple of times, but with no effect. It's strange since it has been working fine for months.

    Though what you said did trigger one thing: I did not properly stop the DB previously, but simply rebooted the machine without executing an explicit mysqld stop command. Could this have an impact?

  4. #4
    Linux Newbie athlon_crazy's Avatar
    Join Date
    Sep 2007
    Location
    Malaysia
    Posts
    132
    not exactly! sometime when my server hang I hav to hard reboot it too & no probl with mysql..

  5. #5
    Just Joined!
    Join Date
    Jan 2008
    Posts
    3

    foolish me..

    Seems I made a foolish mistake, and had modified the my.cnf file with a bind-address of the actual IP, so when it was re-assigned after restart it couldn't find it. Changing it back to local host worked wonders.

    Now why did I set it like that in the first place?

    Thanks for the help!

    Charlie

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •