国产xxxx99真实实拍_久久不雅视频_高清韩国a级特黄毛片_嗯老师别我我受不了了小说

資訊專欄INFORMATION COLUMN

Macosx 下如何使用docker/mysql

ygyooo / 3059人閱讀

摘要:問題描述在下如果指定本地目錄替換,運行時會出現文件權限的錯誤,導致無法正常運行解決方案創建在目錄下啟動腳本創建,指定腳本為容器入口運行命令,啟動容器

問題描述

在macosx下如果指定本地目錄替換/var/lib/mysql,運行時會出現文件權限的錯誤,導致mysqld無法正常運行

Creating mysql_test-mysql_1
Attaching to mysql_test-mysql_1
test-mysql_1 | Initializing database
test-mysql_1 | 2016-03-23T04:32:37.437789Z 0 [Warning] Setting lower_case_table_names=2 because file system for /var/lib/mysql/ is case insensitive
test-mysql_1 | 2016-03-23T04:32:37.466955Z 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
test-mysql_1 | 2016-03-23T04:32:37.467828Z 0 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.
test-mysql_1 | 2016-03-23T04:32:37.468824Z 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
test-mysql_1 | 2016-03-23T04:32:37.468912Z 0 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.
test-mysql_1 | 2016-03-23T04:32:37.470280Z 0 [ERROR] InnoDB: Cannot open datafile "./ibdata1"
test-mysql_1 | 2016-03-23T04:32:37.470309Z 0 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
test-mysql_1 | 2016-03-23T04:32:37.470317Z 0 [ERROR] InnoDB: InnoDB Database creation was aborted with error Cannot open a file. You may need to delete the ibdata1 file before trying to start up again.
test-mysql_1 | 2016-03-23T04:32:38.073222Z 0 [ERROR] Plugin "InnoDB" init function returned error.
test-mysql_1 | 2016-03-23T04:32:38.073268Z 0 [ERROR] Plugin "InnoDB" registration as a STORAGE ENGINE failed.
test-mysql_1 | 2016-03-23T04:32:38.073283Z 0 [ERROR] Failed to initialize plugins.
test-mysql_1 | 2016-03-23T04:32:38.073289Z 0 [ERROR] Aborting
test-mysql_1 | 
mysql_test-mysql_1 exited with code 1
解決方案

創建在scripts目錄下mysqld啟動腳本

#!/bin/bash
# From https://github.com/docker-library/mysql/issues/99
set -e # fail on any error

echo "* Working around permission errors in Docker on Mac locally by making sure that "mysql" uses the same uid and gid as the host volume"
TARGET_UID=$(stat -c "%u" /var/lib/mysql)
echo "-- Setting mysql user to use uid "$TARGET_UID
usermod -o -u $TARGET_UID mysql || true
TARGET_GID=$(stat -c "%g" /var/lib/mysql)
echo "-- Setting mysql group to use gid "$TARGET_GID
groupmod -o -g $TARGET_GID mysql || true
echo
echo "* Starting MySQL"
chown -R mysql:root /var/run/mysqld/
/entrypoint.sh mysqld --user=mysql --console

創建docker-compose.py,指定run-mysqld.sh腳本為容器入口

test-mysql:
    image: mysql 
    ports:
        - "3306:3306"
    volumes:   
        - /localhost/mysql/data:/var/lib/mysql 
        - ./scripts/run-mysqld.sh:/run-mysqld.sh
    environment:
        - MYSQL_DATABASE=play
        - MYSQL_USER=play
        - MYSQL_PASSWORD=play
        - MYSQL_ROOT_PASSWORD=123456
    entrypoint: /run-mysqld.sh

運行docker-compose up命令,啟動容器

文章版權歸作者所有,未經允許請勿轉載,若此文章存在違規行為,您可以聯系管理員刪除。

轉載請注明本文地址:http://specialneedsforspecialkids.com/yun/26552.html

相關文章

  • PhantomJS 安裝

    摘要:變量如果用戶目錄下存在,比如我的,則添加一行否則新建然后在添加上文在中輸入如果可以看到版本號,則安裝成功。 PhantomJS 安裝 showImg(https://segmentfault.com/img/bVL0NY?w=408&h=252); Mac OS X && Windows 1、PhantomJS下載地址 按照系統下載對應的版本, macOS 下載: phantomjs...

    tinylcy 評論0 收藏0
  • PhantomJS 安裝

    摘要:變量如果用戶目錄下存在,比如我的,則添加一行否則新建然后在添加上文在中輸入如果可以看到版本號,則安裝成功。 PhantomJS 安裝 showImg(https://segmentfault.com/img/bVL0NY?w=408&h=252); Mac OS X && Windows 1、PhantomJS下載地址 按照系統下載對應的版本, macOS 下載: phantomjs...

    MockingBird 評論0 收藏0

發表評論

0條評論

ygyooo

|高級講師

TA的文章

閱讀更多
最新活動
閱讀需要支付1元查看
<