I cannot restart mysql I executed mysql_upgrade -u root -p ,no works, and the mysqld.log errors become two

November 30, 2018 408 views
MySQL

I cannot restart mysql

I executed mysql_upgrade -u root -p ,no works, and the mysqld.log errors become two:

181130 8:21:21 [ERROR] Incorrect definition of table mysql.proc: expected column 'sqlmode' at position 14 to have type set('REALASFLOAT','PIPESASCONCAT','ANSIQUOTES','IGNORESPACE','NOTUSED','ONLYFULLGROUPBY','NOUNSIGNEDSUBTRACTION','NODIRINCREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NOKEYOPTIONS','NOTABLEOPTIONS','NOFIELDOPTIONS','MYSQL323','MYSQL40','ANSI','NOAUTOVALUEONZERO','NOBACKSLASHESCAPES','STRICTTRANSTABLES','STRICTALLTABLES','NOZEROINDATE','NOZERODATE','INVALIDDATES','ERRO
181130 8:21:21 [ERROR] Incorrect definition of table mysql.event: expected column 'sqlmode' at position 14 to have type set('REALASFLOAT','PIPESASCONCAT','ANSIQUOTES','IGNORESPACE','NOTUSED','ONLYFULLGROUPBY','NOUNSIGNEDSUBTRACTION','NODIRINCREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NOKEYOPTIONS','NOTABLEOPTIONS','NOFIELDOPTIONS','MYSQL323','MYSQL40','ANSI','NOAUTOVALUEONZERO','NOBACKSLASHESCAPES','STRICTTRANSTABLES','STRICTALLTABLES','NOZEROINDATE','NOZERODATE','INVALIDDATES','ERRORFORDIVISIONBYZERO','TRADITIONAL','NOAUTOCREATEUSER','HIGHNOTPRECEDENCE','NOENGINESUBSTITUTION','PADCHARTOFULLLENGTH'), found type set('REALASFLOAT','PIPESASCONCAT','ANSIQUOTES','IGNORESPACE','IGNOREBADTABLEOPTIONS','ONLYFULLGROUPBY','NOUNSIGNEDSUBTRACTION','NODIRINCREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NOKEYOPTIONS','NOTABLEOPTIONS','NOFIELDOPTIONS','MYSQL323','MYSQL40','ANSI','NOAUTOVALUEONZERO','NOBACKSLASHESCAPES','STRICTTRANSTABLES','STRICT_A

1 comment
1 Answer

sudo /etc/init.d/mysql restart

sudo: /etc/init.d/mysql: command not found
You have new mail in /var/spool/mail/root

Have another answer? Share your knowledge.