mysql restart does not work

Asked Mar 13 '14 at 10:41

Active Mar 19 '14 at 18:01

Viewed 1,834 times

I have a problem with restarting mysql server. It used to restart when I run it with mysqld restart, but I don't know what happened now, it just won't restart giving me an error: you have an error in your sql syntax. I tried different restart methods:

mysql restart
mysqld restart
sudo restart mysql
service mysqld restart
/etc/init.d/mysql restart

and getting the same error. How do I restart it?

edited Mar 19 '14 at 18:01

tshepang

12,111
21
91
136

asked Mar 13 '14 at 10:41

user3344382

1,941
4
18
17

`service mysqld restart` what's your OS? – CodeBird Mar 13 '14 at 10:42
tried that one as well, mac os x – user3344382 Mar 13 '14 at 10:43
check this out: http://stackoverflow.com/questions/7927854/start-mysql-server-from-command-line-on-mac-os-lion – CodeBird Mar 13 '14 at 10:46
mysqld_safe Fatal error: Can't remove the pid file:Please remove it manually and start /usr/local/mysql/bin/mysqld_safe again; mysqld daemon not started. What is a pid file? should I remove it? – user3344382 Mar 13 '14 at 11:11
It is better to do mysql stop and then mysql start. You tried that ? – Sulthan Allaudeen Mar 13 '14 at 11:19
I need mysqld restart. It worked before. Maybe the problem now is something to do with the fact that I installed homebrew package and it affected somehow my server – user3344382 Mar 13 '14 at 11:22
Sorry, see the edit. i need you to shell> mysql.server stop shell> mysql.server start – Sulthan Allaudeen Mar 13 '14 at 11:25

mysql restart does not work

0 Answers0