Starting MySQL.. ERROR! The server quit without updating PID file (/usr/local/mysql/dat
别人的解决方法并不一定适合你。。
错误显示如下:
Starting MySQL
.. ERROR! The server quit without updating PID file (/usr/local/mysql/data/B-26NNG8WN-0833.local.pid).
解决方法:
进入目录/usr/local/mysql/data,找到文件B-26NNG8WN-0833.local.pid,用cat命令打开它,查看到内容如下,发现是端口占用了。
2022-03-17T12:30:58.621722Z 0 [ERROR] [MY-010262] [Server] Can't start server: Bind on TCP/IP port: Address already in use
2022-03-17T12:30:58.621802Z 0 [ERROR] [MY-010257] [Server] Do you already have another mysqld server running on port: 3306 ?
关闭了数据库,关闭了idea,在mac上之前多次打开过navaicat和terminal,端口3306不知道怎么查被谁占用,linux的那一套查询方法没用。好,重启电脑。
然后重新在terminal里敲入命令,完工。