明明已经用docker start mysql启动了容器但是使用docker ps 发现没有容器正在运行时可以试用以下方法:
先用sudo docker logs mysql 命令查看日志,报错为以下内容就继续看,不是就复制报错内容再自行百度解决方案:
mysqld: Error on realpath() on '/var/lib/mysql-files' (Error 2 - No such file or directory)
2021-04-18T08:43:44.910489Z 0 [ERROR] [MY-010095] [Server] Failed to access directory for --secure-file-priv. Please make sure that directory exists and is accessible by MySQL Server. Supplied value : /var/lib/mysql-files
2021-04-18T08:43:44.910506Z 0 [ERROR] [MY-010119] [Server] Aborting
cd /mydata/mysql/conf 进入conf文件夹,编辑my.cnf文件
在[mysqld]内加入secure_file_priv=/var/lib/mysql 重新docker start mysql即可;
my.cnf文件为空的话就直接复制下面的所有内容保存即可;
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
init_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake
secure_file_priv=/var/lib/mysql