目前我正在尝试设置一个数据库用于我的一个项目rn,并在此之前设置一个...但是我忘记了我是如何运行/设置它的
从我当前的docker-compose文件到我的另一个项目,我已经准备好可以使用它了
version: '2.1'
services:
project-mariadb:
image: mariadb:10.3.16
stop_grace_period: 45s
volumes:
- projectdb-1:/var/lib/mysql/
- projectsocket-1:/var/run/mysqld/
- ./src/database/conf/mysql/:/etc/mysql/conf.d/:ro
environment:
- MYSQL_ROOT_PASSWORD=stackrootpassword
- MYSQL_DATABASE=projectdb
- MYSQL_USER=projectadmin
- MYSQL_PASSWORD=stackpassword
restart: always
ports:
- "13362:3306"
networks:
default:
external:
name: my_external_network
volumes:
projectdb-1:
projectsocket-1:但是在运行docker-compose build/ docker -compose up -d时,当我将exec停靠到实例中并进入mysql时,我的用户或数据库没有被创建
我用docker-compose down -v docker volume rm <volume> docker-compose up -d做了什么尝试
这些操作的结果是在docker中得到这个日志
project-mariadb_1 | 2020-12-02 0:33:14 0 [Note] mysqld (mysqld 10.3.16-MariaDB-1:10.3.16+maria~bionic) starting as process 1 ...
project-mariadb_1 | 2020-12-02 0:33:14 0 [Note] InnoDB: Using Linux native AIO
project-mariadb_1 | 2020-12-02 0:33:14 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
project-mariadb_1 | 2020-12-02 0:33:14 0 [Note] InnoDB: Uses event mutexes
project-mariadb_1 | 2020-12-02 0:33:14 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
project-mariadb_1 | 2020-12-02 0:33:14 0 [Note] InnoDB: Number of pools: 1
project-mariadb_1 | 2020-12-02 0:33:14 0 [Note] InnoDB: Using SSE2 crc32 instructions
project-mariadb_1 | 2020-12-02 0:33:14 0 [Note] InnoDB: Initializing buffer pool, total size = 24M, instances = 1, chunk size = 24M
project-mariadb_1 | 2020-12-02 0:33:14 0 [Note] InnoDB: Completed initialization of buffer pool
project-mariadb_1 | 2020-12-02 0:33:14 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
project-mariadb_1 | 2020-12-02 0:33:14 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
project-mariadb_1 | 2020-12-02 0:33:14 0 [Note] InnoDB: Creating shared tablespace for temporary tables
project-mariadb_1 | 2020-12-02 0:33:14 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
project-mariadb_1 | 2020-12-02 0:33:14 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
project-mariadb_1 | 2020-12-02 0:33:15 0 [Note] InnoDB: 10.3.16 started; log sequence number 1630860; transaction id 21
project-mariadb_1 | 2020-12-02 0:33:15 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
project-mariadb_1 | 2020-12-02 0:33:15 0 [Note] Server socket created on IP: '::'.
project-mariadb_1 | 2020-12-02 0:33:15 0 [Note] InnoDB: Buffer pool(s) load completed at 201202 0:33:15
project-mariadb_1 | 2020-12-02 0:33:15 0 [Warning] 'proxies_priv' entry '@% root@volume' ignored in --skip-name-resolve mode.
project-mariadb_1 | 2020-12-02 0:33:15 6 [Note] Event Scheduler: scheduler thread started with id 6
project-mariadb_1 | 2020-12-02 0:33:15 0 [Note] mysqld: ready for connections.
project-mariadb_1 | Version: '10.3.16-MariaDB-1:10.3.16+maria~bionic' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution我试过mariadb:最新的/10.4/10.4.8/10.3.16都给了我同样的问题。
希望我在这方面给出了足够的细节
亲切的问候,菲尔
发布于 2020-12-02 11:02:17
我使用的密码可能搞乱了mysql/mariadb设置,还有一个奇怪的管理员用户名!
https://stackoverflow.com/questions/65100717
复制相似问题