gSupport

Welcome!

This community is for professionals and enthusiasts of our products and services.
Share and discuss the best content and new marketing ideas, build your professional profile and become a better marketer together.

Hide Intro Register

Shorten code to run a old MySQL database on Docker

MySQL Docker Database

as sudo role, and at CLI, just run below code:

> sudo apt install apt-transport-https ca-certificates curl software-properties-common 

> curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo gpg --dearmor -o /usr/share/keyrings/docker-archive-keyring.gpg 

> echo "deb [arch=$(dpkg --print-architecture) signed-by=/usr/share/keyrings/docker-archive-keyring.gpg] https://download.docker.com/linux/ubuntu $(lsb_release -cs) stable" | sudo tee /etc/apt/sources.list.d/docker.list > /dev/null 

> sudo apt update apt-get update && apt-get full-upgrade -y && apt-get autoremove -y && sudo apt-get clean 

> sudo apt install docker-ce -y 

> docker run --name mysql -d -p 3309:3306 -e MYSQL_ROOT_PASSWORD=gimitec --restart unless-stopped mysql:5.6

> docker ps

> cd /home

> cat gimitec.sql | docker exec -i mysql /usr/bin/mysql -u root --password=gimitec mysql

1 Comment

GiMiTEC

- 13 August 2025

With this code you will get database not available to connect after restart Docker or reboot your server,

==> because root password will be changed during Docker reboot

1 Answer

Best Answer

To solved the MySQL user password changed on Docker need to change root user password on Docker manual:

- on CLI enter below code to access your MySQL Docker CLI and change MySQL root password or create new MySQL user and assign this user to your database on this:

> root@mal:/home# docker exec -it mysql bash

> root@cea3f1316bb2:/# mysql -u root -p 
Enter password: 

> MariaDB [(none)]> USE mysql; 

> MariaDB [mysql]> UPDATE user SET Password=PASSWORD('PASSWORD') WHERE User='root';

Query OK, 2 rows affected (0.00 sec)
Rows matched: 2  Changed: 2  Warnings: 0

> MariaDB [mysql]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)
 
> root@mal:/home# cat gimitec.sql | docker exec -i mysql /usr/bin/mysql -u root --password=PASSWORD mysql

Buy GiMiTEC a Coffee

If you feel happiness with these code just buy us a coffee by

Paypal https://paypal.me/gimitec .
Or by Crypto at: 0x420Dabe69626278f464e8eC215987c4d9A8De437
Or Order GiMiTEC mini IT service jobs at our shop: https://gimitec.com/shop

GiMiTEC MINI Jobs

GiMiTEC provide system administrator service mini jobs to help you solve your VPS or server as fast as you need with low cost as you can willing to pay.

What we provide by our work under remote or on side as list but no limit to these job:

Install and configuration Open Source business app: SuiteCRM, Dolibarr CRM/ERP, Erpnext, Flectra, Odoo, Idempiere.
Build new open source email server base on Postfix and Dovecot, with customized domains and email anti-spam best practice.
Build new LAMP stack base on Virtualmin to host mini lightweight company website and email and some small app suitable for SME business with low IT resource.
Upgrade your Idempiere ERP to new version.
Design .odt office template (such as quotation or sale contract, and so more) for your Odoo or Flectra system at version 11 to 13.
Upgrade or install your ERPNEXT version.
Rebuild new VPS server base on https://contabo.com/en/ and install what software you need, transfer full control to you.
Contract to managed you VPS time to time for upgrade, backup and secure best practice
....

Just drop some words on chat or contact to talk more detailing with our team

Legal Notice

Trademarks of Other Manufactures mentioned herein are the property of their (Other Manufactures). or their respective owners.

GiMiTEC.com™ is not affiliated with or licensed by any of these companies. All product names, logos, and brands are property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, logos, and brands does not imply endorsement.

Other trademarks and trade names may be used in this document to refer to either the entities claiming the marks and/or names or their products and are the property of their respective owners. We disclaims proprietary interest in the marks and names of others.

GiMiTEC.com™ and other GiMiTEC™ brand name mentioned herein are the property of the Gimium™ Ecosystem.

gSupport

Welcome!

1 Answer

Gimium™ Ecosystem

GiMiTEC.com™

CHRATEC.com™