[{"_1":2,"_164":-5,"_165":-5},"loaderData",{"_3":4,"_13":14,"_20":21,"_139":140},"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},"username","isAskGordonEnabled",true,"isUsingNewTemplate","showMinimalLanding","routes/_layout.r.$namespace.$reponame",{"_22":23,"_24":-5,"_25":11,"_26":11,"_27":28,"_29":30,"_31":-5,"_32":11,"_33":34,"_83":-5,"_84":85,"_132":-5,"_133":11,"_134":17,"_135":11,"_136":-5,"_137":138},"canonicalUrl","https://hub.docker.com/r/aurex/mysql/tags","mcpServer","canSeeDockerfile","canSeeAutobuilds","namespace","aurex","reponame","mysql","cloudBuildSource","isAutobuildsAvailable","repo",{"_35":36,"_37":38,"_40":41,"_42":43,"_44":11,"_45":46,"_47":48,"_49":50,"_52":30,"_27":28,"_53":54,"_55":-5,"_56":57,"_58":59,"_60":61,"_62":-5,"_63":57,"_64":65,"_66":11,"_67":28,"_68":69,"_74":17,"_75":76,"_80":28,"_81":82},"categories",[],"content_types",[39],"image","date_registered","2015-05-26T00:34:47.584364Z","description","","is_private","last_updated","2015-05-27T01:51:12.885555Z","last_modified","2024-10-16T13:48:34.145251Z","media_types",[51],"application/vnd.docker.distribution.manifest.v1+prettyjws","name","pull_count",1003,"repository_type","star_count",0,"status",1,"status_description","active","source","collaborator_count","full_description","aurex-docker-mysql\n==================\n\nBase docker image to run a MySQL database server\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 `aurex/mysql`, execute the following command on the tutum-mysql folder:\n\n docker build -t aurex/mysql 5.5/\n\nTo run the image and bind to port 3306:\n\n docker run -d -p 3306:3306 aurex/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\" aurex/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\n\nCreating a database on container creation\n-------------------------------------------------\n\nIf you want a database to be created inside the container when you start it up\nfor the first time you can set the environment variable `MYSQL_DB` to string\nthat names the database.\n\n docker run -d -p 3306:3306 -e ON_CREATE_DB=\"database\" aurex/mysql\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 aurex/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 aurex/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 aurex/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 aurex/mysql /bin/bash -c \"/import_sql.sh /tmp/\"\n\nAlso, you can start the new database initializing it with the SQL file:\n\n sudo docker run -d -v /path/in/host:/var/lib/mysql -e STARTUP_SQL=\"/tmp/\" aurex/mysql\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 `true`. 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 aurex/mysql\n\n- Example on Slave MySQL:\n-\n docker run -d -e REPLICATION_SLAVE=true -p 3307:3306 --link mysql:mysql aurex/mysql\n\nNow you can access port `3306` and `3307` for the master/slave MySQL.\n\nEnvironment variables\n---------------------\n\n`MYSQL_USER`: Set a specific username for the admin account (default 'admin').\n\n`MYSQL_PASS`: Set a specific password for the admin account.\n\n`STARTUP_SQL`: Defines one or more SQL scripts separated by spaces to initialize the database. Note that the scripts must be inside the container, so you may need to mount them.\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",{"_70":11,"_71":72},"enabled","rules",[73],".*","is_automated","permissions",{"_77":17,"_78":11,"_79":11},"read","write","admin","user","storage_size",472290372,"orgData","recentTags",[86,122],{"_87":39,"_88":89,"_90":91,"_92":57,"_93":94,"_95":96,"_45":111,"_112":89,"_113":28,"_114":51,"_52":115,"_116":117,"_118":102,"_119":111,"_120":61,"_121":17},"content_type","creator",156271,"digest","sha256:eb70751990ff7e189ca2277998e358c75620bd0a07aab8cb21aeed872415815e","full_size","id",171579,"images",[97],{"_98":99,"_90":91,"_100":43,"_101":102,"_103":104,"_105":43,"_106":43,"_107":-5,"_108":109,"_58":61,"_110":-5},"architecture","amd64","features","last_pulled","2026-09-13T03:48:49.467731515Z","last_pushed","2015-05-27T01:50:50Z","os","os_features","os_version","size",116595425,"variant","2015-05-27T01:50:54Z","last_updater","last_updater_username","media_type","latest","repository",211845,"tag_last_pulled","tag_last_pushed","tag_status","v2",{"_87":39,"_88":89,"_90":123,"_92":57,"_93":124,"_95":125,"_45":130,"_112":89,"_113":28,"_114":51,"_52":131,"_116":117,"_118":127,"_119":130,"_120":61,"_121":17},"sha256:ea5c991bf357d8644c094f7bf8a46915cdb43a31feb91f4073166ecb7ae69dd2",171566,[126],{"_98":99,"_90":123,"_100":43,"_101":127,"_103":128,"_105":43,"_106":43,"_107":-5,"_108":129,"_58":61,"_110":-5},"2026-09-13T03:28:31.745560823Z","2015-05-27T01:51:09Z",116595341,"2015-05-27T01:51:13Z","5.6","sbxKitMetadata","isPotentialSpam","isHubSbxKitsEnabled","displaySecurityMetadata","tagAttestations","tagsHaveAttestations",[],"routes/_layout.r.$namespace.$reponame.tags",{"_33":141,"_148":149,"_137":162,"_163":11},{"_35":142,"_37":143,"_40":41,"_42":43,"_44":11,"_45":46,"_47":48,"_49":144,"_52":30,"_27":28,"_53":54,"_55":-5,"_56":57,"_58":59,"_60":61,"_62":-5,"_63":57,"_64":65,"_66":11,"_67":28,"_68":145,"_74":17,"_75":147,"_80":28,"_81":82},[],[39],[51],{"_70":11,"_71":146},[73],{"_77":17,"_78":11,"_79":11},"tags",{"_150":151,"_152":-5,"_153":-5,"_154":155},"count",2,"next","previous","results",[156,159],{"_87":39,"_88":89,"_90":123,"_92":57,"_93":124,"_95":157,"_45":130,"_112":89,"_113":28,"_114":51,"_52":131,"_116":117,"_118":127,"_119":130,"_120":61,"_121":17},[158],{"_98":99,"_90":123,"_100":43,"_101":127,"_103":128,"_105":43,"_106":43,"_107":-5,"_108":129,"_58":61,"_110":-5},{"_87":39,"_88":89,"_90":91,"_92":57,"_93":94,"_95":160,"_45":111,"_112":89,"_113":28,"_114":51,"_52":115,"_116":117,"_118":102,"_119":111,"_120":61,"_121":17},[161],{"_98":99,"_90":91,"_100":43,"_101":102,"_103":104,"_105":43,"_106":43,"_107":-5,"_108":109,"_58":61,"_110":-5},[],"canDeleteTags","actionData","errors"]

aurex/mysql

Tags for aurex/mysql