mysql not starting - improper shutdown

Discussion in 'Server Operation' started by shruti, Jul 16, 2009.

  1. shruti

    shruti New Member

    Hi, I am new to mysql.
    I was trying to setup replication.
    Made changes to my.cnf
    On the server, did grant permissions and lock tables as

    mysql>grant replication slave on *.* to 'repl'@'%' identified by 'paswd';
    mysql>flush tables with read loack;

    mysql>show master status
    This returned my an empty set

    I had not restarted mysql after changing the my.cnf
    so i shutdown mysql but forgot to unlock the tables before that.

    Now when I try to start mysql again it says:
    mysqld_safe mysqld from pid file mysql/data/shruti-lnx.pid ended

    What do i do?
    I dont want to reinstall mysql as another application is using it.
     
  2. Mark_NL

    Mark_NL New Member

    what i normally do is open up a 2nd screen/console and tail -f the mysql.err file,

    then start mysql and you see what goes wrong .. most of the time mysql gives you pretty clear error msgs with references to websites where you should go see on how to solve the specified problem.
     
  3. shruti

    shruti New Member

    still can't figure out

    I was in the process of setting up replication.
    show master status - returned an empty set so cudnt configure the slave.

    ON COMMAND PROMPT:
    $ bin/mysqld_safe --defaults-file=/home/shruti/mysql/my.cnf -u root --password=shruti &
    [1] 16790
    090717 09:52:13 mysqld_safe Logging to '/home/shruti/mysql/data/shruti-lnx.err'.
    090717 09:52:13 mysqld_safe Starting mysqld daemon with databases from /home/shruti/mysql/data
    090717 09:52:15 mysqld_safe mysqld from pid file /home/shruti/mysql/data/shruti-lnx.pid ended

    [1]+ Done bin/mysqld_safe --defaults-file=/home/shruti/mysql/my.cnf -u root --password=shruti


    Here's the ERROR LOG AT THE MASTER WHEN I TRY TO START MYSQL USING mysqld_safe:


    090717 09:52:13 mysqld_safe Starting mysqld daemon with databases from /home/shruti/mysql/data
    090717 9:52:13 [Warning] One can only use the --user switch if running as root

    090717 9:52:13 [Note] Plugin 'FEDERATED' is disabled.
    090717 9:52:13 InnoDB: Started; log sequence number 0 998191
    090717 9:52:13 [ERROR] /home/shruti/mysql/bin/mysqld: unknown variable 'password=shruti'
    090717 9:52:13 [ERROR] Aborting

    090717 9:52:13 InnoDB: Starting shutdown...
    090717 9:52:15 InnoDB: Shutdown completed; log sequence number 0 998191
    090717 9:52:15 [Warning] Forcing shutdown of 1 plugins
    090717 9:52:15 [Note] /home/shruti/mysql/bin/mysqld: Shutdown complete

    090717 09:52:15 mysqld_safe mysqld from pid file /home/shruti/mysql/data/shruti-lnx.pid ended
     
  4. falko

    falko Super Moderator ISPConfig Developer

    Take a look at
    Code:
    man mysqld_safe
    to find out what the correct option is.
     
  5. shruti

    shruti New Member

    Thanks..

    Thanks.
    I guess that was the problem. I was giving the wrong command. Just got panicked with the locking and unlocking thing!

    I had already reinstalled mysql by the time u replied but I tried the same command again and it gave exactly the same error.
     

Share This Page