在進(jìn)行MySQL8的安裝過程中,可能會(huì)出現(xiàn)各種錯(cuò)誤提示,以下是一些常見的錯(cuò)誤及其解決方案。
錯(cuò)誤1:Installation of server failed
The following packages have unmet dependencies: mysql-server : Depends: mysql-server-8.0 but it is not going to be installed E: Unable to correct problems, you have held broken packages.
解決方案:
執(zhí)行以下命令更新apt-get: sudo apt-get update 然后安裝MySQL Server: sudo apt-get install mysql-server
錯(cuò)誤2:Unable to locate package mysql-server-8.0
E: Unable to locate package mysql-server-8.0
解決方案:
執(zhí)行以下命令添加MySQL的apt-get repository: sudo wget https://repo.mysql.com//mysql-apt-config_0.8.13-1_all.deb sudo dpkg -i mysql-apt-config_0.8.13-1_all.deb 然后再更新apt-get并安裝MySQL Server: sudo apt-get update sudo apt-get install mysql-server
錯(cuò)誤3:mysqld: Can't create directory '/var/lib/mysql/' (Errcode: 13 - Permission denied)
2018-12-25T14:38:40.908515Z 0 [ERROR] [MY-010299] [Server] Could not initialize DD Storage Engine: 13 - Permission denied 2018-12-25T14:38:40.908633Z 0 [ERROR] [MY-010316] [Server] Aborting 2018-12-25T14:38:40.908893Z 0 [ERROR] [MY-010119] [Server] Unknown error 13 "Permission denied" 2018-12-25T14:38:40.909381Z 0 [ERROR] [MY-010008] [Server] Plugin mysqlx reported: 'Failed to initialize DD Storage' 2018-12-25T14:38:40.909570Z 0 [ERROR] [MY-010303] [Server] Plugin initialization aborted with error Generic error. 2018-12-25T14:38:40.909761Z 0 [ERROR] [MY-010103] [Server] Failed to initialize DD Storage Engine. 2018-12-25T14:38:40.909934Z 0 [ERROR] [MY-010119] [Server] Unknown error 13 "Permission denied" 2018-12-25T14:38:40.910099Z 0 [ERROR] [MY-010902] [Server] Can't create directory '/var/lib/mysql/' (Errcode: 13 - Permission denied) 2018-12-25T14:38:40.910232Z 0 [ERROR] [MY-010119] [Server] Unknown error 13 "Permission denied" 2018-12-25T14:38:40.910417Z 0 [ERROR] [MY-010119] [Server] Unknown error 13 "Permission denied" 2018-12-25T14:38:40.910581Z 0 [ERROR] [MY-010929] [Server] Unable to initialize DD Storage Engine 2018-12-25T14:38:40.910746Z 0 [ERROR] [MY-010065] [Server] Failed to shutdown DD Storage Engine
解決方案:
執(zhí)行以下命令修改/var/lib/mysql/文件夾的權(quán)限: sudo chown -R mysql:mysql /var/lib/mysql/ sudo chmod -R 755 /var/lib/mysql/
這些錯(cuò)誤是MySQL8安裝過程中可能遇到的一些問題,通過以上的解決方案,可以輕松地克服這些問題,完成MySQL8的安裝。