docker 进入mysql容器_Docker进入mysql容器执行数据导入

落日映苍穹つ 2022-10-24 10:30 261阅读 0赞

进入mysql操作数据库前 如果数据库中，我们配置的没有env中的用户在数据库中 那么

GRANT ALL ON \*\*\*api.\* TO 'root\*\*\*'@'%' IDENTIFIED BY '7J\*\*\*\*\*\*\*\*\*\*5\*\*\*ISGAhz';

FLUSH PRIVILEGES;

然后可以退出

EXIT;

select user,host from mysql.user;

会看到

![cfa0f9a469c7d279f4e3e81493508ab8.png][]

阐释：

Host的%标示匹配任何Host的名称

可以参考

RENAME USER 'schwarzeni'@'localhost' TO'schwarzeni'@'%';

然后编辑.env填入上述设置 数据库名，用户名，数据库密码

DB\_CONNECTION=mysql

DB\_HOST=db

DB\_PORT=3306

DB\_DATABASE=laravel

DB\_USERNAME=laraveluser

DB\_PASSWORD=my\_password

然后执行

docker-compose -f docker-compose.prod.yml exec app php artisan migrate

登录可以

mysql -u schwarzeni –p

如果docker-compose.prod.yml中配置了，那用户和密码都已经设置好了的。不用再添加用户。

version: "3.7"

services:

app:

...

db:

image: mysql:5.7

container\_name: haaapi-db

restart: unless-stopped

environment:

MYSQL\_DATABASE: $\{DB\_DATABASE\}

MYSQL\_ROOT\_PASSWORD: $\{DB\_PASSWORD\}

MYSQL\_PASSWORD: $\{DB\_PASSWORD\} \#实际采用了7K\*\*\*\*u\*\*\*

MYSQL\_USER: $\{DB\_USERNAME\} \#实际采用了 roothaa

SERVICE\_TAGS: dev

SERVICE\_NAME: mysql

volumes:

\- ./docker-compose/mysql:/docker-entrypoint-initdb.d

networks:

\- haaapin

nginx:

...

networks:

haaapin:

driver: bridge

上面这个在docker build并up启动的时候，db的用户和密码就配置成了.env中设置好的值了。

![8703aee46dd81b6d6da2d8ed92696479.png][]

\*\*\*\*@laravel-docker\*\*\*\*:~/\*\*\*\*/\*\*\*-api/docker-compose/mysql$ docker ps

CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES

8b05998735cf mysql:5.7 "docker-entrypoint.s…" 12 hours ago Up 12 hours 3306/tcp, 33060/tcp \*\*\*api-db

4d50a6c67048 \*\*\*apii "docker-php-entrypoi…" 12 hours ago Up 12 hours 9000/tcp \*\*\*api-app

dc8c9e9918a0 nginx:1.19.1-alpine "/docker-entrypoint.…" 12 hours ago Up 12 hours 0.0.0.0:80->80/tcp \*\*\*api-nginx

005652ce45ac travellist "docker-php-entrypoi…" 36 hours ago Up 18 hours 9000/tcp travellist-app

69a53c064d41 nginx:1.19.1-alpine "/docker-entrypoint.…" 36 hours ago Up 18 hours 0.0.0.0:8000->80/tcp travellist-nginx

66a2c4bdeb73 mysql:5.7 "docker-entrypoint.s…" 36 hours ago Up 18 hours 3306/tcp, 33060/tcp travellist-db

\*\*\*\*@laravel-docker\*\*\*\*:~/\*\*\*\*/\*\*\*-api/docker-compose/mysql$ docker exec –it \*\*\*api-db /bin/bash

root@8b05998735cf:/\# mysql -uroot -p

Enter password:

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

Your MySQL connection id is 32

Server version: 5.7.30 MySQL Community Server (GPL)

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.

mysql> show databases;

\+--------------------+

| Database |

\+--------------------+

| information\_schema |

| mysql |

| performance\_schema |

| \*\*\*api |

| sys |

\+--------------------+

5 rows in set (0.00 sec)

mysql> use \*\*\*api;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> show tables;

\+-------------------------+

| Tables\_in\_\*\*\*api |

\+-------------------------+

| \*\*\*\*\* |

| failed\_jobs |

| images |

| jobs |

| likes |

| migrations |

| password\_resets |

| private\_messages |

| \*\*\*\*\* |

| users |

| verify\_email\_tokens |

| verify\_new\_email\_tokens |

| zip\_\*\*\*\*\* |

\+-------------------------+

14 rows in set (0.00 sec)

mysql> select \* from \*\*\*\*ls;

Empty set (0.00 sec)

mysql>

\#执行导入：

\#docker cp ./\*\*\*\*.sql \*\*\*api-db:/tmp/

\*\*\*\*@laravel-docker\*\*\*\*:~/\*\*\*\*/\*\*\*-api/docker-compose/mysql$ docker cp ./\*\*\*api.sql \*\*\*api-db:/tmp/

\*\*\*\*@laravel-docker\*\*\*\*:~/\*\*\*\*/\*\*\*-api/docker-compose/mysql$ docker exec –it \*\*\*api-db /bin/bash

root@8b05998735cf:/\# mysql -uroot -p

Enter password:

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

Your MySQL connection id is 33

Server version: 5.7.30 MySQL Community Server (GPL)

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.

mysql> use \*\*\*api;\#注意要有;号

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> show tables;

\+-------------------------+

| Tables\_in\_\*\*\*api |

\+-------------------------+

| \*\*\*\*\* |

| failed\_jobs |

| images |

| jobs |

| likes |

| migrations |

| password\_resets |

| private\_messages |

| \*\*\*\* |

| users |

| verify\_email\_tokens |

| verify\_new\_email\_tokens |

| zip\_\*\*\*\*\*s |

\+-------------------------+

14 rows in set (0.00 sec)

mysql> source /tmp/\*\*\*api.sql;

Query OK, 0 rows affected (0.00 sec)