mysql service do not launch
Posted
by
ted
on Ask Ubuntu
See other posts from Ask Ubuntu
or by ted
Published on 2012-05-20T15:10:06Z
Indexed on
2012/09/13
3:51 UTC
Read the original article
Hit count: 448
mysql
Sorry for my English;
I was trying to create db with rake in RoR application that has been configured for MySQL(gem installed, settings changed).
After that attempt mysql-server broke:
d@calister:~$ mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
mysqld is not running at all:
d@calister:~$ ps aux | grep mysql
d 3769 0.0 0.0 4368 832 pts/0 S+ 18:03 0:00 grep --color=auto mysql
And also it doesn't seem it would like to run:
d@calister:~$ sudo service mysql start
start: Job failed to start
Any suggestions?
Thanks
EDIT:
d@calister:~$ sudo -u mysql mysqld
120520 18:45:11 [Note] Plugin 'FEDERATED' is disabled.
mysqld: Table 'mysql.plugin' doesn't exist
120520 18:45:11 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120520 18:45:11 InnoDB: The InnoDB memory heap is disabled
120520 18:45:11 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120520 18:45:11 InnoDB: Compressed tables use zlib 1.2.3.4
120520 18:45:11 InnoDB: Initializing buffer pool, size = 128.0M
120520 18:45:11 InnoDB: Completed initialization of buffer pool
120520 18:45:11 InnoDB: highest supported file format is Barracuda.
120520 18:45:12 InnoDB: Waiting for the background threads to start
120520 18:45:13 InnoDB: 1.1.8 started; log sequence number 1589459
120520 18:45:13 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
© Ask Ubuntu or respective owner