[{"_1":2,"_153":-5,"_154":-5},"loaderData",{"_3":4,"_13":14,"_21":22,"_132":133},"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":11},"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,"_85":-5,"_86":87,"_125":-5,"_126":11,"_127":17,"_128":11,"_129":-5,"_130":131},"canonicalUrl","https://hub.docker.com/r/ctlc/mysql-serf/tags","mcpServer","canSeeDockerfile","canSeeAutobuilds","namespace","ctlc","reponame","mysql-serf","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":65,"_66":67,"_68":11,"_69":29,"_70":71,"_76":17,"_77":78,"_82":29,"_83":84},"categories",[],"content_types",[40],"image","date_registered","2014-03-24T22:12:55Z","description","","is_private","last_updated","2015-10-20T08:38:50.243083Z","last_modified","2024-10-16T13:48:34.145251Z","media_types",[52],"application/vnd.docker.distribution.manifest.v1+prettyjws","name","pull_count",1543,"repository_type","star_count",4,"status",1,"status_description","active","source","collaborator_count",0,"full_description","ctlc-docker-mysql\n==================\n\nBase docker image to run a MySQL database server\n\n\nUsage\n-----\n\nTo create the image `ctlc/mysql`, execute the following command on the ctlc-mysql folder:\n\n\tsudo docker build -t ctlc/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\tsudo docker logs $CONTAINER_ID\n\nYou will see an output like the following:\n\n\t========================================================================\n\tYou can now connect to this MySQL Server using:\n\n\t mysql -uadmin -p47nnf4FweaKu -h -P\n\n\tPlease remember to change the above password as soon as possible!\n\tMySQL user 'root' has no password but only allows local connections\n\t========================================================================\n\nIn this case, `47nnf4FweaKu` is the password allocated to the `admin` user. To get\nthe allocated port to MySQL, execute:\n\n\tsudo docker port $CONTAINER_ID 3306\n\nIt will print the allocated port (like 4751). You can then connect to MySQL:\n\n\t mysql -uadmin -p47nnf4FweaKu -h127.0.0.1 -P4751\n\nRemember that the `root` user has no password but it's only accesible from within the container.\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 on the container to store the database files. To do so:\n\n\t$ID=$(sudo docker run -d -v /path/in/host:/var/lib/mysql ctlc/mysql-php /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\n\nInitializing the server\n-----------------------\n\nTo set your initial root password, run:\n\n\tID=$(sudo docker run -d ctlc/mysql /bin/bash -c \"/set_root_pw.sh \")\n\nWhere `` is the password to be set for the root account. It will store the new container ID (like `d35bf1374e88`) in $ID. To create an image from that, execute:\n\n\tsudo docker commit $ID ctlc/my-mysql-server\n\nTo import a SQL backup which is stored for example in the folder `/tmp/sqlbackup` in the host, run the following:\n\n\tID=$(sudo docker run -d -v /tmp/sqlbackup:/tmp ctlc/my-mysql-server /bin/bash -c \"/import_sql.sh /tmp/\")\n\nWhere `` is the root password set earlier and `` is the name of the SQL file to be imported.\n\nYou can now push your changes to the registry:\n\n\tsudo docker push ctlc/my-mysql-server\n\n\nMigrating an existing MySQL Server\n----------------------------------\n\nIn order to migrate your current MySQL server to a docker, perform the following commands from your current server:\n\nTo dump your databases structure:\n\n\tmysqldump -u -p --opt -d -B > dbserver_schema.sql\n\nTo dump your database data:\n\n\tmysqldump -u -p --quick --single-transaction -t -n -B dbserver_data.sql\n\n\nRunning the MySQL server\n------------------------\n\nRun the `/run.sh` script to start MySQL (via supervisor):\n\n\tID=$(sudo docker run -d -p 3306 ctlc/my-mysql-server /run.sh)\n\n\nIt will store the new container ID (like `d35bf1374e88`) in $ID. Get the allocated external port:\n\n\tsudo docker port $ID 3306\n\n\nIt will print the allocated port (like 4751). Test your deployment:\n\n\tmysql -uroot -p -h127.0.0.1 -P4751\n\nDone!","has_starred","hub_user","immutable_tags_settings",{"_72":11,"_73":74},"enabled","rules",[75],".*","is_automated","permissions",{"_79":17,"_80":11,"_81":11},"read","write","admin","user","storage_size",144986356,"orgData","recentTags",[88],{"_89":40,"_90":91,"_92":93,"_94":95,"_96":97,"_98":99,"_46":114,"_115":91,"_116":29,"_117":52,"_53":118,"_119":120,"_121":105,"_122":114,"_123":62,"_124":17},"content_type","creator",11864,"digest","sha256:f9d6e351f66ee6be8a0d3ef3688ed2aad5b4dd2749b1fec80d7d6303e9606fcd","full_size",144900530,"id",15020,"images",[100],{"_101":102,"_92":93,"_103":44,"_104":105,"_106":107,"_108":44,"_109":44,"_110":-5,"_111":112,"_59":62,"_113":-5},"architecture","amd64","features","last_pulled","2026-09-20T09:44:59.402439758Z","last_pushed","2015-10-20T08:39:36Z","os","os_features","os_version","size",144900658,"variant","2015-10-20T08:39:37Z","last_updater","last_updater_username","media_type","latest","repository",12225,"tag_last_pulled","tag_last_pushed","tag_status","v2","sbxKitMetadata","isPotentialSpam","isHubSbxKitsEnabled","displaySecurityMetadata","tagAttestations","tagsHaveAttestations",[],"routes/_layout.r.$namespace.$reponame.tags",{"_34":134,"_141":142,"_130":151,"_152":11},{"_36":135,"_38":136,"_41":42,"_43":44,"_45":11,"_46":47,"_48":49,"_50":137,"_53":31,"_28":29,"_54":55,"_56":-5,"_57":58,"_59":60,"_61":62,"_63":-5,"_64":65,"_66":67,"_68":11,"_69":29,"_70":138,"_76":17,"_77":140,"_82":29,"_83":84},[],[40],[52],{"_72":11,"_73":139},[75],{"_79":17,"_80":11,"_81":11},"tags",{"_143":60,"_144":-5,"_145":-5,"_146":147},"count","next","previous","results",[148],{"_89":40,"_90":91,"_92":93,"_94":95,"_96":97,"_98":149,"_46":114,"_115":91,"_116":29,"_117":52,"_53":118,"_119":120,"_121":105,"_122":114,"_123":62,"_124":17},[150],{"_101":102,"_92":93,"_103":44,"_104":105,"_106":107,"_108":44,"_109":44,"_110":-5,"_111":112,"_59":62,"_113":-5},[],"canDeleteTags","actionData","errors"]

ctlc/mysql-serf

Tags for ctlc/mysql-serf