Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 17th July 2009, 00:37
shruti shruti is offline
Junior Member
 
Join Date: Jul 2009
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Unhappy mysql not starting - improper shutdown

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.
Reply With Quote
Sponsored Links
  #2  
Old 17th July 2009, 11:26
Mark_NL Mark_NL is offline
Senior Member
 
Join Date: Sep 2008
Location: The Netherlands
Posts: 912
Thanks: 12
Thanked 100 Times in 96 Posts
Default

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.
Reply With Quote
  #3  
Old 17th July 2009, 20:25
shruti shruti is offline
Junior Member
 
Join Date: Jul 2009
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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
Reply With Quote
  #4  
Old 18th July 2009, 12:10
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,751 Times in 2,581 Posts
Default

Quote:
Originally Posted by shruti View Post
090717 9:52:13 [ERROR] /home/shruti/mysql/bin/mysqld: unknown variable 'password=shruti'
Take a look at
Code:
man mysqld_safe
to find out what the correct option is.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 20th July 2009, 20:17
shruti shruti is offline
Junior Member
 
Join Date: Jul 2009
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default 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.
Reply With Quote
Reply

Bookmarks

Tags
mysql, replication, restart services

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
High on Lenny - Lvm Mount Problem Serverman Technical 1 23rd June 2009 17:26
Problem installing MySQL on suse 10.3 Txchaser Installation/Configuration 20 18th April 2008 02:05
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 10:11
Messed up ISPConfig-2.2.8 Upgrade Morons Installation/Configuration 4 29th November 2006 13:17
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 17:04


All times are GMT +2. The time now is 20:47.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.