Question
I cannot restart mysql I executed mysql_upgrade -u root -p ,no works, and the mysqld.log errors become two
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
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.
sudo /etc/init.d/mysql restart