Docker容器启动lnmp环境下的mysql服务时报

Docker容器启动lnmp环境下的mysql服务时报

我在自己的mac笔记本上装了一个docker，并在docker容器中安装了lnmp环境，经常会遇到在使用"lnmp restart"命令启动lnmp服务的时候，mysql服务启动失败，启动日志：

Stoping LNMP...Stoping nginx... nginx is ERROR! MySQL server PID file could not be found!Gracefully shutting down php-fpm /etc/init.d/php-fpm: line 82: kill: (695) - No such process................................... failed. Use force-quitStarting LNMP...Starting nginx... doneStarting MySQL... ERROR! The server quit without updating PID file (/usr/local/mysql/var/37815a453e3e.pid).-fpm done

找到mysql的数据存放目录，我的是/usr/local/mysql/var目录下(这个目录可以通过/etc/my.cnf中的innodb_data_home_dir属性查看)，找到以.err结尾对文件，根据日期查看最近对err文件：

[root@37815a453e3e bin]# cd /usr/local/mysql/var[root@37815a453e3e var]# lltotal 141556-rw-r----- 1 mysql mysql 27407 Sep 30 16:29 124dc886567c.err-rw-r----- 1 mysql mysql 6924 Sep 30 12:55 22415a597457.err-rw-r----- 1 mysql mysql 20626 Oct 1 17:02 37815a453e3e.err-rw-r----- 1 mysql mysql 41418 Sep 30 11:05 7f92c9fbcaea.err-rw-r----- 1 mysql mysql 36378 Sep 29 13:42 f25f067a6a86.err

发现错误日中有如下错误信息：

2018-10-01T14:05:29.741954Z 0 [Warning] Insecure configuration for --pid-file: 　　Location '/usr/local/mysql/var' in the path is accessible to all OS users. 　　Consider choosing a different directory.2018-10-01T14:05:29.744299Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: 　　Table storage engine for 'proxies_priv' doesn't have this option2018-10-01T14:05:29.744399Z 0

解决办法，对数据目录授权：

[root@6e1de98da6d4 var]# chown -R mysql:mysql /usr/local/mysql/var/[root@6e1de98da6d4 var]# lnmp mysql restart+-------------------------------------------+| Manager for LNMP, Written by Licess |+-------------------------------------------+| |+-------------------------------------------+ ERROR! MySQL server PID file could not be found!Starting MySQL. SUCCESS! [root@6e1de98da6d4 var]#

重启mysql服务，启动OK：

[root@37815a453e3e var]# lnmp mysql restart+-------------------------------------------+| Manager for LNMP, Written by Licess |+-------------------------------------------+| |+-------------------------------------------+Shutting down MySQL.. SUCCESS! Starting MySQL. SUCCESS!

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。