[Patmwaniki]

Hello,

I have CentOs 7 as server . Recently did some update and it also updated MySQL 5.7 to version 8.0
suddenly i have run-time error.

Kindly assist on the attachment.

[amosbatto]

ProcessMaker is not compatible with MySQL 8.

Before you do anything, make a backup of your MySQL files, which are usually located at: /var/lib/mysql, so you don't screw them up any further.

Then, you need to delete MySQL 8 and reinstall MySQL 5.7.

I have no idea what changes CentOS makes to MySQL databases when upgrading to version 8. You have to hope that CentOS didn't touch the MySQL files when it upgraded to version 8.

Do you have a backup from before you upgraded? If you run into problems, you should restore the old files from your backup in /var/lib/mysql .

[amosbatto]

I found instructions on how to downgrade from MySQL 8.0 to 5.7. Follow these instructions:
https://subscription.packtpub.com/book/ ... -mysql-8-0

[Patmwaniki]

Thanks I did as you instructed and all went well.

I was able to bring the system back and first thing i did is to backup the whole workspace

thanks and regards
Patrick

[amosbatto]

I'm glad to hear it. I love Linux, but it is way too easy to destroy your system with some of the commands.

[Walkera]

It work for me v.2.5 , you need to config mysql my.cnf
1 set my.cnf
[mysqld]
default-authentication-plugin=mysql_native_password
collation-server = utf8_unicode_ci
character-set-server = utf8
set sql_mode =''
2. create new user
CREATE USER 'newuser'@'%'IDENTIFIED WITH mysql_native_password BY 'xxxxx';