[{"_1":2,"_155":-5,"_156":-5},"loaderData",{"_3":4,"_13":14,"_21":22,"_134":135},"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,"_84":-5,"_85":86,"_125":-5,"_126":11,"_127":17,"_128":11,"_129":-5,"_130":11,"_131":-5,"_132":133},"canonicalUrl","https://hub.docker.com/r/n0bility6/mysql/tags","mcpServer","canSeeDockerfile","canSeeAutobuilds","namespace","n0bility6","reponame","mysql","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":40,"_57":58,"_59":60,"_61":62,"_63":-5,"_64":58,"_65":66,"_67":11,"_68":29,"_69":70,"_75":11,"_76":77,"_81":29,"_82":83},"categories",[],"content_types",[40],"image","date_registered","2022-05-02T06:40:10.585564Z","description","Mysql 5.7.38 in Debian Linux with cronjob and nano editor","is_private","last_updated","2022-05-04T07:15:35.191197Z","last_modified","2024-10-16T13:48:34.145251Z","media_types",[52],"application/vnd.docker.container.image.v1+json","name","pull_count",1278,"repository_type","star_count",0,"status",1,"status_description","active","source","collaborator_count","full_description","

Source

\nLatest update of original mysql 5.7 repository using the Dockerfile.debian and docker-entrypoint.sh\n\n```\nhttps://github.com/docker-library/mysql/tree/7c4eca3ee491d62d3aa5442c864c43355ab34f1b/5.7\n```\n

Usage

\n\nStandalone\n\nSimple deployment with root password. Root password can be configured to secret.\n```\n docker run --name some-mysql -e MYSQL_ROOT_PASSWORD=my-secret-pw -d n0bility6/mysql:5.7\n```\nThis command deploy your mysql with credentials and persistent volume.\n```\ndocker run -dit -e MYSQL_ROOT_PASSWORD=root -e MYSQL_USER=sample_user -e MYSQL_PASSWORD=secret_password -e MYSQL_DATABASE=sampledb -v /mysql/data:/var/lib/mysql -v /cronjob/backup/:/etc/cron.d/ n0bility6/mysql:5.7\n```\nRestore .sql Backup to new database. \n```\ncat backupname.sql | docker exec -i CONTAINERID /usr/bin/mysql -u root --password=root DATABASENAME\n```\n1. CONTAINERID is the new MySQL database server container.\n2. DATABASENAME is the newly created database in the new MySQL container \n\nStack\n```\nversion: '3.7'\n\nservices:\n #MySQL Service\n database:\n image: n0bility6/mysql:5.7\n command: --default-authentication-plugin=mysql_native_password\n environment:\n - MYSQL_ROOT_PASSWORD=root \n - MYSQL_USER=sample_user\n - MYSQL_PASSWORD=sample_password\n - MYSQL_DATABASE=sampledb\n volumes:\n - ./mysql/data:/var/lib/mysql #Persistent Data\n - ./backupscript/:/etc/cron.d/ #Cronjob location\n restart: always\n```\nSample backup script cron job with filename script, place it inside backupscript folder and mount it to ./backupscript/:/etc/cron.d/\n```\n# m h dom mon dow user command\n58 23 * * 1 root mysqldump databasename --user=root --password=root > /var/lib/mysql/Backup/monday.sql\n58 23 * * 2 root mysqldump databasename --user=root --password=root > /var/lib/mysql/Backup/tuesday.sql\n58 23 * * 3 root mysqldump databasename --user=root --password=root > /var/lib/mysql/Backup/wednesday.sql\n58 23 * * 4 root mysqldump databasename --user=root --password=root > /var/lib/mysql/Backup/thursday.sql\n58 23 * * 5 root mysqldump databasename --user=root --password=root > /var/lib/mysql/Backup/friday.sql\n58 23 * * 6 root mysqldump databasename --user=root --password=root > /var/lib/mysql/Backup/saturday.sql\n58 23 * * 7 root mysqldump databasename --user=root --password=root > /var/lib/mysql/Backup/sunday.sql\n```\n\n

Changes

\n\nAdd cron and nano in Dockerfile RUN command\n\nOriginal\n```\nRUN apt-get update && apt-get install -y --no-install-recommends gnupg dirmngr && rm -rf /var/lib/apt/lists/*\n````\nUpdated\n```\nRUN apt-get update && apt-get install -y --no-install-recommends gnupg dirmngr cron nano && rm -rf /var/lib/apt/lists/*\n```\nAdd custom command in docker-entrypoint.sh inside _main() function.\n```\n_main() {\n # if command starts with an option, prepend mysqld\n if [ \"${1:0:1}\" = '-' ]; then\n set -- mysqld \"$@\"\n fi\n # skip setup if they aren't running mysqld or want an option that stops mysqld\n if [ \"$1\" = 'mysqld' ] && ! _mysql_want_help \"$@\"; then\n mysql_note \"Entrypoint script for MySQL Server ${MYSQL_VERSION} started.\"\n\n mysql_check_config \"$@\"\n # Load various environment variables\n docker_setup_env \"$@\"\n docker_create_db_directories\n\n # If container is started as root user, restart as dedicated mysql user\n if [ \"$(id -u)\" = \"0\" ]; then\n\n #====================Custom command======================\n #Start Cron service first as root user\n service cron start\n echo \"Starting periodic command scheduler: cron started!\"\n chown root /etc/cron.d/* /etc/cron.daily/* /etc/cron.hourly/* /etc/cron.monthly/* /etc/cron.weekly/*\n chmod 644 /etc/cron.d/* /etc/cron.daily/* /etc/cron.hourly/* /etc/cron.monthly/* /etc/cron.weekly/*\n echo \"Starting periodic command scheduler: Changed ownership of /etc/cron.d/ /etc/cron.daily/ /etc/cron.hourly/ /etc/cron.monthly/ /etc/cron.weekly/ files to root user.\"\n #====================Custom command======================\n\n mysql_note \"Switching to dedicated user 'mysql'\"\n exec gosu mysql \"$BASH_SOURCE\" \"$@\"\n fi\n\n # there's no database, so it needs to be initialized\n if [ -z \"$DATABASE_ALREADY_EXISTS\" ]; then\n docker_verify_minimum_env\n\n # check dir permissions to reduce likelihood of half-initialized database\n ls /docker-entrypoint-initdb.d/ > /dev/null\n\n docker_init_database_dir \"$@\"\n\n mysql_note \"Starting temporary server\"\n docker_temp_server_start \"$@\"\n mysql_note \"Temporary server started.\"\n\n mysql_socket_fix\n docker_setup_db\n docker_process_init_files /docker-entrypoint-initdb.d/*\n\n mysql_expire_root_user\n\n mysql_note \"Stopping temporary server\"\n docker_temp_server_stop\n mysql_note \"Temporary server stopped\"\n\n echo\n mysql_note \"MySQL init process done. Ready for start up.\"\n echo\n else\n mysql_socket_fix\n fi\n fi\n exec \"$@\"\n\n}\n\n# If we are sourced from elsewhere, don't perform any further actions\nif ! _is_sourced; then\n _main \"$@\"\nfi\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",621007471,"orgData","recentTags",[87],{"_88":40,"_89":90,"_91":92,"_93":94,"_95":96,"_46":114,"_115":90,"_116":29,"_117":52,"_53":118,"_119":120,"_121":105,"_122":114,"_123":62,"_124":17},"content_type","creator",2510226,"full_size",162670978,"id",206057434,"images",[97],{"_98":99,"_100":101,"_102":103,"_104":105,"_106":107,"_108":109,"_110":103,"_111":-5,"_112":92,"_59":62,"_113":-5},"architecture","amd64","digest","sha256:94f1dc2a17174d1a1f7429f4c47e23f1b895e45eb8173a9cf18c5e05dd648ac3","features","","last_pulled","2026-09-18T14:10:37.894974267Z","last_pushed","2022-05-04T07:15:36Z","os","linux","os_features","os_version","size","variant","2022-05-04T07:15:35.084004Z","last_updater","last_updater_username","media_type","5.7","repository",17037688,"tag_last_pulled","tag_last_pushed","tag_status","v2","sbxKitMetadata","isPotentialSpam","isHubSbxKitsEnabled","showSbxLogoOverride","sbxTrademarkText","displaySecurityMetadata","tagAttestations","tagsHaveAttestations",[],"routes/_layout.r.$namespace.$reponame.tags",{"_34":136,"_143":144,"_132":153,"_154":11},{"_36":137,"_38":138,"_41":42,"_43":44,"_45":11,"_46":47,"_48":49,"_50":139,"_53":31,"_28":29,"_54":55,"_56":40,"_57":58,"_59":60,"_61":62,"_63":-5,"_64":58,"_65":66,"_67":11,"_68":29,"_69":140,"_75":11,"_76":142,"_81":29,"_82":83},[],[40],[52],{"_71":11,"_72":141},[74],{"_78":17,"_79":11,"_80":11},"tags",{"_145":60,"_146":-5,"_147":-5,"_148":149},"count","next","previous","results",[150],{"_88":40,"_89":90,"_91":92,"_93":94,"_95":151,"_46":114,"_115":90,"_116":29,"_117":52,"_53":118,"_119":120,"_121":105,"_122":114,"_123":62,"_124":17},[152],{"_98":99,"_100":101,"_102":103,"_104":105,"_106":107,"_108":109,"_110":103,"_111":-5,"_112":92,"_59":62,"_113":-5},[],"canDeleteTags","actionData","errors"]

n0bility6/mysql

Tags for n0bility6/mysql