ubuntu mysql innodb_ubuntu docker mysql [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11； Access...

docker mysql  忽然自动挂掉的解决方法：

创建docker 容器步骤：

docker pull mysql:5.7.17

1 . 启动 - 自定义配置

docker run --name mysql_01 -p 3306:3306 -v /home/test/docker/mysql/3306/conf:/etc/mysql/mysql.conf.d -v /home/test/docker/mysql/3306/data:/var/lib/mysql -v /home/test/docker/mysql/3306/logs:/var/log/mysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7.17

docker exec -it 7388ab22f6ca sh

mysql -uroot -p123456;

use mysql;

CREATE USER [email protected]‘%‘ IDENTIFIED BY ‘123456‘;

grant all on *.* to [email protected]‘%‘ with grant option;

flush privileges;

某一天容器忽然停掉了。

我的解决方法：

ps -ef | grep mysqld

kill -9 20189

docker rm mysql_01

docker run --name mysql_01 -p 3306:3306 -v /home/test/docker/mysql/3306/conf:/etc/mysql/mysql.conf.d -v /home/test/docker/mysql/3306/data:/var/lib/mysql -v /home/test/docker/mysql/3306/logs:/var/log/mysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7.17

----------------------------

docker logs mysql_01

执行如下操作：

docker ps -a     如果mysql_01   Exit(1) 表示有error

docker logs mysql_01   ./ibdata1 error: 11；

重新登录，报错：

docker exec -it mysql_01 sh

# mysql -uroot -p

Enter password:

ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using password: YES)

# mysql -uroot -p123456 -P3306 -h 192.168.205.122

mysql: [Warning] Using a password on the command line interface can be insecure.

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 6

Server version: 5.7.17 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type ‘help;‘ or ‘\h‘ for help. Type ‘\c‘ to clear the current input statement.

登录成功

原有的数据库配置和数据又可以使用了。

原文：https://www.cnblogs.com/xhzd/p/11038542.html