Container de mysql não sobe
[Finalizado Pelo Aluno]
![Matheus Gomes](https://academy.especializati.com.br/assets/site/imgs/no-image.png)
Meu container de mysql só da esse erro:
2024-07-22 15:52:11 2024-07-22 18:52:11+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 9.0.0-1.el9 started.
2024-07-22 15:52:11 2024-07-22 18:52:11+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-07-22 15:52:11 2024-07-22 18:52:11+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 9.0.0-1.el9 started.
2024-07-22 15:52:11 '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2024-07-22 15:52:11 2024-07-22T18:52:11.747920Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-07-22 15:52:11 2024-07-22T18:52:11.986292Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2024-07-22 15:52:11 2024-07-22T18:52:11.989733Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 9.0.0) starting as process 1
2024-07-22 15:52:11 2024-07-22T18:52:11.990681Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2024-07-22 15:52:11 2024-07-22T18:52:11.992559Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /var/lib/mysql/ is case insensitive
2024-07-22 15:52:12 2024-07-22T18:52:12.008264Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-07-22 15:52:13 2024-07-22T18:52:13.290095Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-07-22 15:52:13 mysqld: Table 'mysql.plugin' doesn't exist
2024-07-22 15:52:13 2024-07-22T18:52:13.571452Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure.
2024-07-22 15:52:13 2024-07-22T18:52:13.571583Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-07-22 15:52:13 2024-07-22T18:52:13.571724Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-07-22 15:52:13 2024-07-22T18:52:13.571845Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-07-22 15:52:13 2024-07-22T18:52:13.571966Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-07-22 15:52:13 2024-07-22T18:52:13.572054Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-07-22 15:52:13 2024-07-22T18:52:13.572138Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-07-22 15:52:13 2024-07-22T18:52:13.572241Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-07-22 15:52:13 2024-07-22T18:52:13.793080Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2024-07-22 15:52:14 2024-07-22T18:52:14.128262Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2024-07-22 15:52:14 2024-07-22T18:52:14.162157Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-07-22 15:52:14 2024-07-22T18:52:14.162373Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-07-22 15:52:14 2024-07-22T18:52:14.175738Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2024-07-22 15:52:14 2024-07-22T18:52:14.187046Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-07-22 15:52:14 2024-07-22T18:52:14.187304Z 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-22 15:52:14 2024-07-22T18:52:14.187333Z 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-22 15:52:14 2024-07-22T18:52:14.187452Z 0 [ERROR] [MY-000067] [Server] unknown variable 'mysql_native_password=on'.
2024-07-22 15:52:14 2024-07-22T18:52:14.187915Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-07-22 15:52:15 2024-07-22T18:52:15.206336Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 9.0.0) MySQL Community Server - GPL.
2024-07-22 15:52:15 2024-07-22T18:52:15.206363Z 0 [System] [MY-015016] [Server] MySQL Server - end.
Já mudei de versão, já comentei a linha mysql_native_password=on e nada funciona, alguém consegue me ajudar?
Olá, Matheus! Tudo bem?
Qual o seu sistema operacional?
Como está o seu arquivo docker-compose.yaml?
Use esse daqui: https://github.com/especializati/curso-laravel-11/blob/main/docker-compose.yml#L31
![Carlos Ferreira](https://storage.googleapis.com/eti-academy/users/carlos-ferreira.jpg)
Olá, é windows 10.
Eu devo substituir o trecho atual pelo trecho que mandou?
![Matheus Gomes](https://academy.especializati.com.br/assets/site/imgs/no-image.png)
Esqueci de mencionar, mas estou fazendo o curso de "Fundamentos da Programação com PHP" E estou usando o laradock, o link que me enviou talvez seja de outro curso.
![Matheus Gomes](https://academy.especializati.com.br/assets/site/imgs/no-image.png)
Ah sim, achei que era com Docker.
Está usando o MySQL do Laradock?
![Carlos Ferreira](https://storage.googleapis.com/eti-academy/users/carlos-ferreira.jpg)
Estou usando o docker conforme o setup do curso, mas ao subir o container com mysql ele da esse erro. Tem como resolver?
![Matheus Gomes](https://academy.especializati.com.br/assets/site/imgs/no-image.png)
Usa esse ambiente com Docker aqui, ele é mais simples e já com o PHP 8: https://academy.especializati.com.br/aula/como-rodar-o-laravel-11
![Carlos Ferreira](https://storage.googleapis.com/eti-academy/users/carlos-ferreira.jpg)
Beleza. Posso usar ele durante todo o curso de fundamentos de php? Já que no curso usa o laradock
![Matheus Gomes](https://academy.especializati.com.br/assets/site/imgs/no-image.png)
Pode sim, é até melhor! :)
![Carlos Ferreira](https://storage.googleapis.com/eti-academy/users/carlos-ferreira.jpg)
Beleza Carlos, obrigado por enquanto.
![Matheus Gomes](https://academy.especializati.com.br/assets/site/imgs/no-image.png)
Precisa estar logado para conseguir responder a este ticket!
Clique Aqui Para Entrar!