mysql can't start after upgrade

[m_pahlevanzadeh]

I upgrade my freebsd and all of my packages, But mysql can't start after upgrade.
How do I start it?
By the way, My MySQL doesn't create any log messages.

 

[VladiBG]

MySQL :: MySQL 5.7 Reference Manual :: 2.10.3 Changes in MySQL 5.7

dev.mysql.com

If you want more detail answer you should provide more information like error log.

 

[Alain De Vos]

Before upgrading the mysql/mariadb packages it's mostly a good idea to first make a backup/dump of the database.
After the upgrade you then do a restore.

 

[covacat]

by default it logs to /var/db/mysq/${hostname}.err

 

[m_pahlevanzadeh]

Now, I need to my data, What's your solution to run my mysql?

 

[Alain De Vos]

The adviced way is to revert/return to the lastest previous version which was working correctly and then make a backup of the database. Then you can upgrade at new.

 

[forquare]

IIRC, when I've had this in the past I've needed to use the mysql_upgrade(1) utility. You might want to read the documentation around it though as I may be misremembering!

 

[jbo@]

IIRC, when I've had this in the past I've needed to use the mysql_upgrade(1) utility. You might want to read the documentation around it though as I may be misremembering!

OP didn't provide any MySQL version number but mysql_upgrade(1) is deprecated since 8.0.16: https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-16.html

 

[SirDice]

And you don't need to run mysql_upgrade(1) for patch versions. Only if you updated from 5.6 to 5.7 for example. Which I assume is not the case here.