Help upgrading to mysql 8.0.19 error


  • | 1186 points

    OK so I've been trying for a while now searching for a solution, I did the tutorial on how to change MySQL on laragon but every time I try to start it I get this on the log, would really appreciate some help since I don't know what to do.

    2020-03-10T18:29:30.782819Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
    2020-03-10T18:29:30.782867Z 0 [System] [MY-010116] [Server] D:\Programs\laragon\bin\mysql\mysql-8.0.19-winx64\bin\mysqld (mysqld 8.0.19) starting as process 15356
    mysqld: Table 'mysql.plugin' doesn't exist
    2020-03-10T18:29:32.764867Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure.
    2020-03-10T18:29:33.157903Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
    2020-03-10T18:29:33.383635Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
    2020-03-10T18:29:33.430283Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
    2020-03-10T18:29:33.435916Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
    2020-03-10T18:29:33.436967Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001146 - Table 'mysql.component' doesn't exist
    2020-03-10T18:29:33.438165Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-003543 - The mysql.component table is missing or has an incorrect definition.
    2020-03-10T18:29:33.441701Z 0 [ERROR] [MY-010326] [Server] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
    2020-03-10T18:29:33.442386Z 0 [ERROR] [MY-010952] [Server] The privilege system failed to initialize correctly. For complete instructions on how to upgrade MySQL to a new version please see the 'Upgrading MySQL' section from the MySQL manual.
    2020-03-10T18:29:33.443785Z 0 [ERROR] [MY-010119] [Server] Aborting
    2020-03-10T18:29:34.323920Z 0 [System] [MY-010910] [Server] D:\Programs\laragon\bin\mysql\mysql-8.0.19-winx64\bin\mysqld: Shutdown complete (mysqld 8.0.19) MySQL Community Server - GPL.
    2020-03-10T18:29:40.793771Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
    2020-03-10T18:29:40.793825Z 0 [System] [MY-010116] [Server] D:\Programs\laragon\bin\mysql\mysql-8.0.19-winx64\bin\mysqld (mysqld 8.0.19) starting as process 15972
    mysqld: Table 'mysql.plugin' doesn't exist
    2020-03-10T18:29:43.179042Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure.
    2020-03-10T18:29:43.329795Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
    2020-03-10T18:29:43.559894Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
    2020-03-10T18:29:43.834902Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
    2020-03-10T18:29:43.841159Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
    2020-03-10T18:29:43.841924Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001146 - Table 'mysql.component' doesn't exist
    2020-03-10T18:29:43.842974Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-003543 - The mysql.component table is missing or has an incorrect definition.
    2020-03-10T18:29:43.846441Z 0 [ERROR] [MY-010326] [Server] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
    2020-03-10T18:29:43.847234Z 0 [ERROR] [MY-010952] [Server] The privilege system failed to initialize correctly. For complete instructions on how to upgrade MySQL to a new version please see the 'Upgrading MySQL' section from the MySQL manual.
    2020-03-10T18:29:43.848622Z 0 [ERROR] [MY-010119] [Server] Aborting
    2020-03-10T18:29:44.751951Z 0 [System] [MY-010910] [Server] D:\Programs\laragon\bin\mysql\mysql-8.0.19-winx64\bin\mysqld: Shutdown complete (mysqld 8.0.19) MySQL Community Server - GPL.


Log in to reply
 

Looks like your connection to Laragon was lost, please wait while we try to reconnect.