MySQL stopped working after upgrade to 8.0

Alexander1974

Alexander1974

Verified User
Joined
Mar 28, 2017
Messages
22
Location
Rotterdam
I have a big problem. I upgraded to MySQL 8.0 in the admin panel and then MySQL stopped working.

I have been busy all night to get the production working again.

First I got
Found outdated /usr/local/directadmin/conf/my.cnf. Rewriting from / usr / local / dir ectadmin / conf / mysql.conf
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/ var / lib

Now I have messed around so much that I no longer get this message.

Downgrading is also not possible, then I get the message that I have to do this incrementally, but there is no intermediate step between 8.0 to 5.7, right?

I also tried running a new build several times, but this was also pointless.

What can I do to get this working again?

Your help is much appreciated!
 
When I now give the command mysqld, the return is:

2020-07-05T05:32:27.877759Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.20) starting as process 11123
2020-07-05T05:32:27.880747Z 0 [ERROR] [MY-010123] [Server] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
2020-07-05T05:32:27.880796Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-07-05T05:32:27.880991Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.20) MySQL Community Server - GPL.
 
This is in my error log:
2020-07-04T23:36:41.613114Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-07-04T23:36:41.613186Z 0 [ERROR] InnoDB: Cannot open '/var/lib/mysql/ib_buffer_pool' for reading: No such file or directory
2020-07-04T23:36:41.641196Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-07-04T23:36:41.688528Z 0 [Warning] System table 'plugin' is expected to be transactional.
2020-07-04T23:36:41.696218Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2020-07-04T23:36:42.748738Z 0 [Note] Auto generated SSL certificates are placed in data directory.
2020-07-04T23:36:42.749554Z 0 [Warning] CA certificate ca.pem is self signed.
2020-07-04T23:36:43.177082Z 0 [Note] Auto generated RSA key files are placed in data directory.
2020-07-04T23:36:43.177464Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2020-07-04T23:36:43.177509Z 0 [Note] IPv6 is available.
2020-07-04T23:36:43.177523Z 0 [Note] - '::' resolves to '::';
2020-07-04T23:36:43.177548Z 0 [Note] Server socket created on IP: '::'.
2020-07-04T23:36:43.247460Z 0 [Warning] Failed to open optimizer cost constant tables

2020-07-04T23:36:43.325645Z 0 [Warning] User entry 'tdomeinen_fp'@'localhost' has a deprecated pre-4.1 password. The user will be ignored and no one can login with this user anymore.
2020-07-04T23:36:43.325967Z 0 [Warning] User entry 'tdomeinen_tonia'@'localhost' has a deprecated pre-4.1 password. The user will be ignored and no one can login with this user anymore.
2020-07-04T23:36:43.325987Z 0 [Warning] User entry 'tdomeinen'@'localhost' has a deprecated pre-4.1 password. The user will be ignored and no one can login with this user anymore.
2020-07-04T23:36:43.325996Z 0 [Warning] User entry 'tdomeinen_toniaf'@'localhost' has a deprecated pre-4.1 password. The user will be ignored and no one can login with this user anymore.
2020-07-04T23:36:43.326004Z 0 [Warning] User entry 'tdomeinen_tonial'@'localhost' has a deprecated pre-4.1 password. The user will be ignored and no one can login with this user anymore.
2020-07-04T23:36:43.326012Z 0 [Warning] User entry 'tdomeinen_trav'@'localhost' has a deprecated pre-4.1 password. The user will be ignored and no one can login with this user anymore.
2020-07-04T23:36:43.326907Z 0 [Warning] User entry 'aalexmedia_bab'@'localhost' has a deprecated pre-4.1 password. The user will be ignored and no one can login with this user anymore.
2020-07-04T23:36:43.326921Z 0 [Warning] User entry 'aalexmedia'@'localhost' has a deprecated pre-4.1 password. The user will be ignored and no one can login with this user anymore.
2020-07-04T23:36:43.326929Z 0 [Warning] User entry 'aalexmedia_beurs'@'localhost' has a deprecated pre-4.1 password. The user will be ignored and no one can login with this user anymore.
2020-07-04T23:36:43.326937Z 0 [Warning] User entry 'aalexmedia_bhfm'@'localhost' has a deprecated pre-4.1 password. The user will be ignored and no one can login with this user anymore.
2020-07-04T23:36:43.326945Z 0 [Warning] User entry 'aalexmedia_compf'@'localhost' has a deprecated pre-4.1 password. The user will be ignored and no one can login with this user anymore.
2020-07-04T23:36:43.326953Z 0 [Warning] User entry 'aalexmedia_fin'@'localhost' has a deprecated pre-4.1 password. The user will be ignored and no one can login with this user anymore.
2020-07-04T23:36:43.326961Z 0 [Warning] User entry 'aalexmedia_fint'@'localhost' has a deprecated pre-4.1 password. The user will be ignored and no one can login with this user anymore.
2020-07-04T23:36:43.326969Z 0 [Warning] User entry 'aalexmedia_grat'@'localhost' has a deprecated pre-4.1 password. The user will be ignored and no one can login with this user anymore.
2020-07-04T23:36:43.326977Z 0 [Warning] User entry 'aalexmedia_ily'@'localhost' has a deprecated pre-4.1 password. The user will be ignored and no one can login with this user anymore.
2020-07-04T23:36:37.826492Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-07-04T23:36:37.828912Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.30) starting as process 21162 ...
2020-07-04T23:36:37.834907Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-07-04T23:36:37.834961Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-07-04T23:36:37.834977Z 0 [Note] InnoDB: Uses event mutexes
2020-07-04T23:36:37.835000Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2020-07-04T23:36:37.835018Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-04T23:36:37.835032Z 0 [Note] InnoDB: Using Linux native AIO
2020-07-04T23:36:37.835589Z 0 [Note] InnoDB: Number of pools: 1
 
When I now give the command mysqld, the return is:

2020-07-05T05:32:27.877759Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.20) starting as process 11123
2020-07-05T05:32:27.880747Z 0 [ERROR] [MY-010123] [Server] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
2020-07-05T05:32:27.880796Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-07-05T05:32:27.880991Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.20) MySQL Community Server - GPL.
 
You must log in or register to reply here.
Back
Top