Mysql-8.0.12-macos10.13-x86_64 failed to start, how to solve it?

problem description

I installed mysql on mac last year, and it was no problem to use it. Later, it may be due to system updates and running errors, so I deleted the previous files according to the online tutorials and re-downloaded the latest version of mysql-8.0.12-macos10.13-x86_64

on the official website.

the platform version of the problem and what methods you have tried

attempt to launch in system preferences:

clipboard.png

clipboard.png

Start MySQL Server

terminal:

clipboard.png

:

clipboard.png

:

clipboard.png

related codes

error log code:
1 2018-08-14T07:50:43.420590Z 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.12) starting as process       1107
2 2018-08-14T07:50:43.424350Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/l      ocal/mysql/data/ is case insensitive
3 2018-08-14T07:50:43.430795Z 0 [ERROR] [MY-011370] [Server] Plugin keyring_file reported: "File "/usr/local/mysql/keyring/key      ring" not found (OS errno 13 - Permission denied)"
4 2018-08-14T07:50:43.430844Z 0 [ERROR] [MY-011355] [Server] Plugin keyring_file reported: "keyring_file initialization failur      e. Please check if the keyring_file_data points to readable keyring file or keyring file can be created in the specified loc      ation. The keyring_file will stay unusable until correct path to the keyring file gets provided"
5 2018-08-14T07:50:43.433896Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
6 2018-08-14T07:50:43.434078Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
7 2018-08-14T07:50:43.434100Z 0 [ERROR] [MY-010119] [Server] Aborting
8 2018-08-14T07:50:43.435367Z 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.12)        MySQL Community Server - GPL.

what result do you expect? What is the error message actually seen?

error result:
. ERROR! The server quit without updating PID file (/usr/local/mysql/data/zhuliwendeMacBook-Pro.local.pid).
expected result:

looking at stackoverflow and codeshelper did not solve my problem (perhaps because of my own low level). I hope someone can give specific countermeasures to my situation

Apr.09,2021

8.0.13 also encountered the same problem


the same abnormal information as you. After more than a day of twists and turns, I finally solved
using tar.gz to install
wow is really happy to help people with the same problems

.
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b3ab31-2c216.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b3ab31-2c216.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?