I can't use MySQL 9

[COD3BREAK3R]

Why is everything so difficult and complicated with Laragon? Can't they just add .exe files that install PHP, MySQL, etc. like other servers? When I try to start MySQL, I get this error:

2024-07-05T17:00:37.818375Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-07-05T17:00:38.062665Z 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.
2024-07-05T17:00:38.062745Z 0 [System] [MY-010116] [Server] C:\laragon-6.0.0\bin\mysql\mysql-9.0.0-winx64\bin\mysqld (mysqld 9.0.0) starting as process 13064
2024-07-05T17:00:38.105122Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-07-05T17:00:38.734536Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
mysqld: Table 'mysql.plugin' doesn't exist
2024-07-05T17:00:39.012545Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure.
2024-07-05T17:00:39.016345Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-07-05T17:00:39.022278Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-07-05T17:00:39.024503Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-07-05T17:00:39.027373Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-07-05T17:00:39.029408Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-07-05T17:00:39.031436Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-07-05T17:00:39.037800Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-07-05T17:00:39.155231Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2024-07-05T17:00:39.273599Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2024-07-05T17:00:39.338413Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-07-05T17:00:39.340472Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-07-05T17:00:39.355402Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-07-05T17:00:39.358490Z 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
2024-07-05T17:00:39.363186Z 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.
2024-07-05T17:00:39.373731Z 0 [ERROR] [MY-000067] [Server] unknown variable 'mysql_native_password=ON'.
2024-07-05T17:00:39.378308Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-07-05T17:00:40.283179Z 0 [System] [MY-010910] [Server] C:\laragon-6.0.0\bin\mysql\mysql-9.0.0-winx64\bin\mysqld: Shutdown complete (mysqld 9.0.0)  MySQL Community Server - GPL.
2024-07-05T17:00:40.285558Z 0 [System] [MY-015016] [Server] MySQL Server - end.
2024-07-05T17:00:47.979152Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-07-05T17:00:48.154185Z 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.
2024-07-05T17:00:48.154266Z 0 [System] [MY-010116] [Server] C:\laragon-6.0.0\bin\mysql\mysql-9.0.0-winx64\bin\mysqld (mysqld 9.0.0) starting as process 10904
2024-07-05T17:00:48.189754Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-07-05T17:00:48.509597Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
mysqld: Table 'mysql.plugin' doesn't exist
2024-07-05T17:00:48.686149Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure.
2024-07-05T17:00:48.688229Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-07-05T17:00:48.695350Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-07-05T17:00:48.697064Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-07-05T17:00:48.698750Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-07-05T17:00:48.700297Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-07-05T17:00:48.701854Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-07-05T17:00:48.703396Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-07-05T17:00:48.866634Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2024-07-05T17:00:48.978031Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2024-07-05T17:00:49.023348Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-07-05T17:00:49.024586Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-07-05T17:00:49.034234Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-07-05T17:00:49.036152Z 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
2024-07-05T17:00:49.039702Z 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.
2024-07-05T17:00:49.049102Z 0 [ERROR] [MY-000067] [Server] unknown variable 'mysql_native_password=ON'.
2024-07-05T17:00:49.053362Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-07-05T17:00:50.245319Z 0 [System] [MY-010910] [Server] C:\laragon-6.0.0\bin\mysql\mysql-9.0.0-winx64\bin\mysqld: Shutdown complete (mysqld 9.0.0)  MySQL Community Server - GPL.
2024-07-05T17:00:50.247524Z 0 [System] [MY-015016] [Server] MySQL Server - end.

Why ????

[alxndr-w]

Did you follow the instructions for MySQL 8.4? I guess this also has to be followed.

https://github.com/leokhoa/laragon/wiki/%5BTutorial%5D-How-to-add-another-MySQL-version#mysql-84

What's the reason why you need MySQL 9.0?

[COD3BREAK3R]

That's not an answer to my comment at all.

After following the steps for version 8.4 now it works version 9 but cant change password, all methods fails!!! I have phpmyadmin installed and after intitalize MySQL, heydi dont ask me for new password

[alxndr-w]

Please try these instructions:
#772 (comment)

[COD3BREAK3R]

Please try these instructions: #772 (comment)

Thank you, I discovered a simple way to do it on my own, and the solution is not in that thread. If anyone has the same problem as me, they should do the following:

1- Open HeidiMySQL
2- Select the database, check the option: ask for credentials
3- Enter the password created when running mysqld --initialize --datadir="C:\laragon-6.0.0\data\mysql-9" --basedir="C:\laragon\bin\mysql\mysql-9.0.0-winx64" --console
4- It will ask you to set a new password, and that's it!

I hope in the future it won't be necessary to go through so much work in Laragon to use MySQL 9.

Off-topic: Does anyone know if it's normal for Laravel to take 400ms to respond when making a request to the API? Could it be due to the limited resources on my computer?

[alxndr-w]

Glad to see things work now. Also thank you for sharing your solution. If you like to, I'd put this into the Wiki pages and you could check if I merged the instructions for MySQL 8.4 and your feedback / changes for MySQL correctly?

Does anyone know if it's normal for Laravel to take 400ms to respond when making a request to the API? Could it be due to the limited resources on my computer?

This could be a new thread. Did you search the discussions and issues already?

[COD3BREAK3R]

This could be a new thread. Did you search the discussions and issues already?

I was looking in the discussion forum, I don't think I'm going to worry about speed until I have more RAM or a better PC, maybe that's the reason.