Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
Install MySQL on New Droplet Question Question
How can I solve error "SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)" Question Question

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 963 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

Add a comment
3165769583
By:
3165769583

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
Install MySQL on New Droplet Question Question
How can I solve error "SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)" Question Question
Add a comment
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.

×
Submit an Answer
1 answer
3165769583 December 1, 2018

sudo /etc/init.d/mysql restart

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

Reply Report

Related

Looking for something else?

Ask a new question Search for more help