[{"_1":2,"_154":-5,"_155":-5},"loaderData",{"_3":4,"_13":14,"_21":22,"_133":134},"root",{"_5":-5,"_6":-7,"_7":8,"_9":-7,"_10":11,"_12":-7},"currentUser","primaryEmail","siteVerification","6LeIxAcTAAAAAJcZVRqyHh71UMIEGNQ_MXjiZKhI","toast","enableDev",false,"incidentStatus","routes/_layout",{"_15":-5,"_16":17,"_18":17,"_19":11,"_20":17},"username","isAskGordonEnabled",true,"isUsingNewTemplate","showMinimalLanding","showHoneypotTrap","routes/_layout.r.$namespace.$reponame",{"_23":24,"_25":-5,"_26":11,"_27":11,"_28":29,"_30":31,"_32":-5,"_33":11,"_34":35,"_84":-5,"_85":86,"_124":-5,"_125":11,"_126":17,"_127":11,"_128":-5,"_129":11,"_130":-5,"_131":132},"canonicalUrl","https://hub.docker.com/r/gman/docker-mysql-database/tags","mcpServer","canSeeDockerfile","canSeeAutobuilds","namespace","gman","reponame","docker-mysql-database","cloudBuildSource","isAutobuildsAvailable","repo",{"_36":37,"_38":39,"_41":42,"_43":44,"_45":11,"_46":47,"_48":49,"_50":51,"_53":31,"_28":29,"_54":55,"_56":-5,"_57":58,"_59":60,"_61":62,"_63":-5,"_64":58,"_65":66,"_67":11,"_68":29,"_69":70,"_75":17,"_76":77,"_81":29,"_82":83},"categories",[],"content_types",[40],"image","date_registered","2014-09-17T22:18:48.961034Z","description","","is_private","last_updated","2015-11-13T09:39:16.910215Z","last_modified","2024-10-16T13:48:34.145251Z","media_types",[52],"application/vnd.docker.distribution.manifest.v1+prettyjws","name","pull_count",946,"repository_type","star_count",0,"status",1,"status_description","active","source","collaborator_count","full_description","docker-mysql-database\n==================\n\nBase docker image to run a MySQL database server with a empty database\n\n\nMySQL version\n-------------\n\nDifferent versions are built from different folders. If you want to use MariaDB, please check our `tutum/mariadb` image: https://github.com/tutumcloud/tutum-docker-mariadb\n\n\nUsage\n-----\n\nTo create the image `tutum/mysql`, execute the following command on the tutum-mysql folder:\n\n docker build -t tutum/mysql 5.5/\n\nTo run the image and bind to port 3306:\n\n docker run -d -p 3306:3306 tutum/mysql\n\nThe first time that you run your container, a new user `admin` with all privileges\nwill be created in MySQL with a random password. To get the password, check the logs\nof the container by running:\n\n docker logs \n\nYou will see an output like the following:\n\n ========================================================================\n You can now connect to this MySQL Server using:\n\n mysql -uadmin -p47nnf4FweaKu -h -P\n\n Please remember to change the above password as soon as possible!\n MySQL user 'root' has no password but only allows local connections\n ========================================================================\n\nIn this case, `47nnf4FweaKu` is the password allocated to the `admin` user.\n\nRemember that the `root` user has no password but it's only accessible from within the container.\n\nYou can now test your deployment:\n\n mysql -uadmin -p\n\nDone!\n\n\nSetting a specific password for the admin account\n-------------------------------------------------\n\nIf you want to use a preset password instead of a random generated one, you can\nset the environment variable `MYSQL_PASS` to your specific password when running the container:\n\n docker run -d -p 3306:3306 -e MYSQL_PASS=\"mypass\" tutum/mysql\n\nYou can now test your deployment:\n\n mysql -uadmin -p\"mypass\"\n\nThe admin username can also be set via the `MYSQL_USER` environment variable.\n\n\nMounting the database file volume\n---------------------------------\n\nIn order to persist the database data, you can mount a local folder from the host\non the container to store the database files. To do so:\n\n docker run -d -v /path/in/host:/var/lib/mysql tutum/mysql /bin/bash -c \"/usr/bin/mysql_install_db\"\n\nThis will mount the local folder `/path/in/host` inside the docker in `/var/lib/mysql` (where MySQL will store the database files by default). `mysql_install_db` creates the initial database structure.\n\nRemember that this will mean that your host must have `/path/in/host` available when you run your docker image!\n\nAfter this you can start your mysql image but this time using `/path/in/host` as the database folder:\n\n docker run -d -p 3306:3306 -v /path/in/host:/var/lib/mysql tutum/mysql\n\n\nMounting the database file volume from other containers\n------------------------------------------------------\n\nAnother way to persist the database data is to store database files in another container.\nTo do so, first create a container that holds database files:\n\n docker run -d -v /var/lib/mysql --name db_vol -p 22:22 tutum/ubuntu-trusty\n\nThis will create a new ssh-enabled container and use its folder `/var/lib/mysql` to store MySQL database files.\nYou can specify any name of the container by using `--name` option, which will be used in next step.\n\nAfter this you can start your MySQL image using volumes in the container created above (put the name of container in `--volumes-from`)\n\n docker run -d --volumes-from db_vol -p 3306:3306 tutum/mysql\n\n\nMigrating an existing MySQL Server\n----------------------------------\n\nIn order to migrate your current MySQL server, perform the following commands from your current server:\n\nTo dump your databases structure:\n\n mysqldump -u -p --opt -d -B > /tmp/dbserver_schema.sql\n\nTo dump your database data:\n\n mysqldump -u -p --quick --single-transaction -t -n -B > /tmp/dbserver_data.sql\n\nTo import a SQL backup which is stored for example in the folder `/tmp` in the host, run the following:\n\n sudo docker run -d -v /tmp:/tmp tutum/mysql /bin/bash -c \"/import_sql.sh /tmp/\"\n\nWhere `` and `` are the database username and password set earlier and `` is the name of the SQL file to be imported.\n\n\nReplication - Master/Slave\n-------------------------\nTo use MySQL replication, please set environment variable `REPLICATION_MASTER`/`REPLICATION_SLAVE` to `ture`. Also, on master side, you may want to specify `REPLICATION_USER` and `REPLICATION_PASS` for the account to perform replication, the default value is `replica:replica`\n\nExamples:\n- Master MySQL\n-\n docker run -d -e REPLICATION_MASTER=true -e REPLICATION_PASS=mypass -p 3306:3306 --name mysql tutum/mysql\n\n- Example on Slave MySQL:\n-\n docker run -d -e REPLICATION_SLAVE=true -p 3307:3306 --link mysql:mysql tutum/mysql\n\nNow, you can access port `3306` and `3307` for the master/slave mysql\nEnvironment variables\n---------------------\n\n`MYSQL_USER`: Set a specific username for the admin account (default 'admin')\n`MYSQL_PASS`: Set a specific password for the admin account.\n\nCompatibility Issues\n--------------------\n\n- Volume created by MySQL 5.6 cannot be used in MySQL 5.5 Images or MariaDB images\n","has_starred","hub_user","immutable_tags_settings",{"_71":11,"_72":73},"enabled","rules",[74],".*","is_automated","permissions",{"_78":17,"_79":11,"_80":11},"read","write","admin","user","storage_size",291551490,"orgData","recentTags",[87],{"_88":40,"_89":90,"_91":92,"_93":94,"_95":96,"_97":98,"_46":113,"_114":90,"_115":29,"_116":52,"_53":117,"_118":119,"_120":104,"_121":113,"_122":62,"_123":17},"content_type","creator",67018,"digest","sha256:f3d72e3122b7c2ad2249635d200d49bed786e6477fec2bb54c4eeaca27c35c35","full_size",291465592,"id",49693,"images",[99],{"_100":101,"_91":92,"_102":44,"_103":104,"_105":106,"_107":44,"_108":44,"_109":-5,"_110":111,"_59":62,"_112":-5},"architecture","amd64","features","last_pulled","2026-09-21T22:14:34.994569729Z","last_pushed","2015-11-13T09:39:16Z","os","os_features","os_version","size",291466104,"variant","2015-11-13T09:39:25.252423Z","last_updater","last_updater_username","media_type","latest","repository",56348,"tag_last_pulled","tag_last_pushed","tag_status","v2","sbxKitMetadata","isPotentialSpam","isHubSbxKitsEnabled","showSbxLogoOverride","sbxTrademarkText","displaySecurityMetadata","tagAttestations","tagsHaveAttestations",[],"routes/_layout.r.$namespace.$reponame.tags",{"_34":135,"_142":143,"_131":152,"_153":11},{"_36":136,"_38":137,"_41":42,"_43":44,"_45":11,"_46":47,"_48":49,"_50":138,"_53":31,"_28":29,"_54":55,"_56":-5,"_57":58,"_59":60,"_61":62,"_63":-5,"_64":58,"_65":66,"_67":11,"_68":29,"_69":139,"_75":17,"_76":141,"_81":29,"_82":83},[],[40],[52],{"_71":11,"_72":140},[74],{"_78":17,"_79":11,"_80":11},"tags",{"_144":60,"_145":-5,"_146":-5,"_147":148},"count","next","previous","results",[149],{"_88":40,"_89":90,"_91":92,"_93":94,"_95":96,"_97":150,"_46":113,"_114":90,"_115":29,"_116":52,"_53":117,"_118":119,"_120":104,"_121":113,"_122":62,"_123":17},[151],{"_100":101,"_91":92,"_102":44,"_103":104,"_105":106,"_107":44,"_108":44,"_109":-5,"_110":111,"_59":62,"_112":-5},[],"canDeleteTags","actionData","errors"]

gman/docker-mysql-database

Tags for gman/docker-mysql-database