[mysql5 0005318]: mysql5d will not start after upgrade

[Mantis Bug Tracker]

The following issue has been SUBMITTED. 
====================================================================== 
https://www.opencsw.org/mantis/view.php?id=5318 
====================================================================== 
Reported By:                schwindt
Assigned To:                
====================================================================== 
Project:                    mysql5
Issue ID:                   5318
Category:                   packaging
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     new
====================================================================== 
Date Submitted:             2018-06-24 10:18 CEST
Last Modified:              2018-06-24 10:18 CEST
====================================================================== 
Summary:                    mysql5d will not start after upgrade
Description: 
Just upgraded to CSWmysql5  5.5.54,REV=2017.01.26 comping from an older
version. mysqld enters maintainance mode after this.

Looking closer at the daemon one finds 
180624  9:45:10 [ERROR] Failed to access directory for --secure-file-priv.
Please make sure that directory exists and is accessible by MySQL Server.
Supplied value : /var/lib/mysql-files
180624  9:45:10 [ERROR] Aborting

You can bring back the service by :

mkdir /var/lib/mysql-files
chown mysql:mysql /var/lib/mysql-files
chmod o-rwx /var/lib/mysql-files

======================================================================