Question

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

Posted November 30, 2018 630 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

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
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

Submit an Answer