I have a server (Centos 7) that was running with the default MySQL installation.
I´ve removed MySQL and installed it again (5.7.12) using the Centos Repository. It all went well, but after that I can´t backup or restore virtual servers. I get the errors:
Backup: Saving mail and FTP users .. SQL select user.user,user.password from user,db where db.user = user.user and (db.db = 'plugpecgame' or db.db = 'plugpecgame') failed : Unknown column 'user.password' in 'field list' at ../web-lib-funcs.pl line 1427, line 1.
Restore: Restoring allowed MySQL hosts .. Restore failed : SQL insert into user (host, user, password, ssl_type, ssl_cipher, x509_issuer, x509_subject) values ('%', '*****', password('*******'), '', '', '', '') failed : Unknown column 'password' in 'field list'
Please help Thanks