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
the platform version of the problem and what methods you have tried
attempt to launch in system preferences:
Start MySQL Server
terminal
:
:
:
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