{"id":4290,"date":"2022-10-17T05:57:57","date_gmt":"2022-10-16T20:57:57","guid":{"rendered":"https:\/\/blog.wsd.sh\/?p=4290"},"modified":"2022-10-19T05:35:07","modified_gmt":"2022-10-18T20:35:07","slug":"4290","status":"publish","type":"post","link":"https:\/\/blog.wsd.sh\/?p=4290","title":{"rendered":" Docker and Mariadb container install and connect HeidiSQL<\/small>"},"content":{"rendered":"

1. Step
\n(1) Install docker
\n(2) Mariadb container install
\n(3) connect HeidiSQL<\/p>\n

2. Prerequisites<\/strong>
\n(1) Install gnome-terminal<\/p>\n

\r\n$ sudo apt install gnome-terminal\r\n<\/pre>\n
(2) Uninstall old versions<\/p>\n
\r\n$ sudo apt-get remove docker docker-engine docker.io containerd runc\r\n<\/pre>\n
3. Install Docker<\/strong>
\n(1) Set up the repository<\/p>\n
\r\n $ sudo apt-get update\r\n\r\n $ sudo apt-get install \\\r\n    ca-certificates \\\r\n    curl \\\r\n    gnupg \\\r\n    lsb-release\r\n<\/pre>\n
(2) Add Docker\u2019s official GPG key:<\/p>\n
\r\n$ sudo mkdir -p \/etc\/apt\/keyrings\r\n\r\n$ curl -fsSL https:\/\/download.docker.com\/linux\/ubuntu\/gpg | sudo gpg --dearmor -o \/etc\/apt\/keyrings\/docker.gpg\r\n<\/pre>\n
(3) Use the following command to set up the repository:<\/p>\n
\r\nsudo add-apt-repository \"deb [arch=amd64] https:\/\/download.docker.com\/linux\/ubuntu $(lsb_release -cs) stable\"\r\n<\/pre>\n
(4) Install Docker Engine<\/p>\n
\r\n$ sudo apt-get update\r\n\r\n$ sudo apt-get install docker-ce docker-ce-cli containerd.io docker-compose-plugin\r\n<\/pre>\n
(5) List the versions available in your repo:<\/p>\n
\r\n$ apt-cache madison docker-ce\r\n<\/pre>\n
(6) comfirm docker status<\/p>\n
 \r\n$ sudo systemctl status docker\r\n<\/pre>\n
4. Run Docker commands without sudo<\/strong>
\n(1) Check for docker group existence<\/p>\n
\r\n$ cat \/etc\/group |grep docker\r\n<\/pre>\n
(2) Add username to docker group<\/p>\n
\r\n$ sudo usermod -aG docker ${USER}\r\n<\/pre>\n
(3) Apply new group membership<\/p>\n
\r\n$ su - ${USER}\r\n<\/pre>\n
(4) Confirm added to docker group<\/p>\n
\r\n$ id -nG\r\n$ cat \/etc\/group |grep docker\r\n<\/pre>\n
5. Using Docker commands<\/strong><\/p>\n
\r\n$ docker info\r\n<\/pre>\n
6. Verify that Docker Engine is installed correctly by running the hello-world image<\/strong><\/p>\n
\r\n$ service docker start\r\n$ docker run hello-world\r\n<\/pre>\n
7. Download image to computer<\/strong>
\n(1) Search image<\/p>\n
\r\n$ docker search ubuntu\r\n<\/pre>\n
(2) Download image to computer<\/p>\n
\r\n$ docker pull ubuntu\r\n<\/pre>\n
(3) View image list<\/p>\n
\r\n$ docker images\r\nREPOSITORY            TAG       IMAGE ID       CREATED              SIZE\r\nubuntu                latest    216c552ea5ba   11 days ago          77.8MB\r\nhello-world           latest    feb5d9fea6a5   12 months ago        13.3kB\r\n<\/pre>\n
(4) Confirm CONTAINER ID <\/p>\n
\r\n$ docker ps -a\r\nCONTAINER ID   IMAGE         COMMAND                  CREATED          STATUS                       PORTS     NAMES\r\n45dfc14c1dc9   ubuntu        \"bash\"                   13 minutes ago   Exited (137) 5 minutes ago             crazy_curie\r\nc1670baef172   hello-world   \"\/hello\"                 59 minutes ago   Exited (0) 59 minutes ago              vigorous_nash\r\n<\/pre>\n
8. Run Docker container<\/strong>
\n(1) docker run <\/p>\n
\r\n$ docker run -it ubuntu\r\nroot@ad90866c9f1b:\/# \r\nroot@ad90866c9f1b:\/# exit\r\n<\/pre>\n
(2) check CONTAINER ID  and NAMES<\/p>\n
\r\n$ docker ps -l\r\nCONTAINER ID   IMAGE     COMMAND   CREATED         STATUS         PORTS     NAMES\r\n45dfc14c1dc9   ubuntu    \"bash\"    7 minutes ago   Up 7 minutes             crazy_curie\r\n<\/pre>\n
9.  How to save container state as new Docker image <\/strong>
\n(1) new Docker image<\/p>\n
\r\n$ docker commit -m \"added Node.js\" -a \"wsd01\" 45dfc14c1dc9 wsd01\/ubuntu-nodejs\r\nsha256:f2930c27c1455fdcb3abd1b05547ae22724bc19bca32b24bb3f51ea0e36c0d10\r\n<\/pre>\n
10.  Install docker-mariadb image<\/strong>
\n(1) Search image<\/p>\n
\r\n$ docker search mariadb\r\n<\/pre>\n
(2) Download image to computer<\/p>\n
\r\n$ docker pull mariacb\r\n<\/pre>\n
(3) Initirize a mariadb server instance & start
\n– name mariadb_1 (docker NAMES)
\n– MARIADB_USER=admin
\n– MARIADB_PASSWORD=123456
\n– MARIADB_ROOT_PASSWORD=12345678
\n\u2013 dp 3307:3306 ( Local side port number : Container side port number)<\/p>\n
\r\n$ docker run --detach --name mariadb_1 --env MARIADB_USER=admin --env MARIADB_PASSWORD=123456 --env MARIADB_ROOT_PASSWORD=12345678  -dp 3307:3306 mariadb:latest\r\n<\/pre>\n
(4) check CONTAINER ID  and NAMES
\n$ docker ps -a<\/p>\n
\r\nCONTAINER ID   IMAGE            COMMAND                  CREATED          STATUS                     PORTS                                       NAMES\r\nb83838cded47   mariadb:latest   \"docker-entrypoint.s\u2026\"   32 minutes ago   Up 15 minutes              0.0.0.0:3307->3306\/tcp, :::3307->3306\/tcp   mariadb_1\r\n45dfc14c1dc9   ubuntu           \"bash\"                   5 hours ago      Exited (137) 4 hours ago                                               crazy_curie\r\nc1670baef172   hello-world      \"\/hello\"                 5 hours ago      Exited (0) 5 hours ago                                                 vigorous_nash\r\n<\/pre>\n
(5) Start mariadb_1<\/p>\n
\r\n$ docker start mariadb_1\r\n<\/pre>\n
(6) Show container list<\/p>\n
\r\n$ docker container ls\r\nCONTAINER ID   IMAGE            COMMAND                  CREATED        STATUS         PORTS                                       NAMES\r\nb83838cded47   mariadb:latest   \"docker-entrypoint.s\u2026\"   28 hours ago   Up 2 seconds   0.0.0.0:3307->3306\/tcp, :::3307->3306\/tcp   mariadb_1\r\n<\/pre>\n
(7) HeidiSQL session manager
\n– Session name:docker-mariadb_1
\n– user : admin
\n– port 3307
\n– Host : 127.0.0.1
\n\"\"<\/p>\n
(8) Connect mariadb_1
\n\"\"<\/p>\n
(9) Stop mariadb_1<\/p>\n
\r\n$ docker stop mariadb_1\r\n<\/pre>\n
(10) Show container list<\/p>\n
\r\n$ docker container ls\r\nCONTAINER ID   IMAGE     COMMAND   CREATED   STATUS    PORTS     NAMES\r\n<\/pre>\n
(11) Container shell access and update and exit<\/p>\n
\r\n$ docker start mariadb_1\r\n$ docker exec -it mariadb_1 bash\r\nroot@700724a54424:\/# apt-get update\r\nroot@700724a54424:\/# exit\r\n<\/pre>\n
(13) Viewing MariaDB logs<\/p>\n
\r\n$ docker logs mariadb_1\r\n<\/pre>\n
11.  Mariadb permissions <\/strong>
\n(1) exec mariadb<\/p>\n
\r\n$ docker exec -it mariadb_1 bash\r\n<\/pre>\n
(2) login mysql<\/p>\n
\r\nroot@700724a54424:\/# mysql -u root -p\r\nEnter password: \r\nWelcome to the MariaDB monitor.  Commands end with ; or \\g.\r\nYour MariaDB connection id is 12\r\nServer version: 10.9.3-MariaDB-1:10.9.3+maria~ubu2204 mariadb.org binary distribution\r\n\r\nCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.\r\n\r\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\r\n\r\nMariaDB [(none)]> \r\n<\/pre>\n
(3)<\/p>\n
\r\nMariaDB [(none)]>  create user 'admin'@'localhost' identified by '123456';\r\n<\/pre>\n
(4) grant admin<\/p>\n
\r\nMariaDB [(none)]>  grant all privileges on *.* to 'admin'@'%' identified by '123456' WITH GRANT OPTION;\r\n<\/pre>\n
(5) show user<\/p>\n
\r\nMariaDB [(none)]>  SELECT Host, User FROM mysql.user;\r\n+-----------+-------------+\r\n| Host      | User        |\r\n+-----------+-------------+\r\n| %         | admin       |\r\n| %         | root        |\r\n| localhost | admin       |\r\n| localhost | mariadb.sys |\r\n| localhost | root        |\r\n+-----------+-------------+\r\n5 rows in set (0.010 sec)\r\n<\/pre>\n
(4) exit<\/p>\n
\r\nMariaDB [(none)]> Ctrl-C -- exit!\r\nAborted\r\nroot@b83838cded47:\/# exit\r\n$ \r\n<\/pre>\n
12.  pip install <\/strong>
\n(1) Force install pip<\/p>\n
\r\n$ mkdir mariadb\r\n$ cd  mariadb\r\n$ python3 -m pip install mysql-connector-python\r\n\/usr\/bin\/python3: No module named pip\r\n$ curl https:\/\/bootstrap.pypa.io\/get-pip.py -o get-pip.py\r\n  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current\r\n                                 Dload  Upload   Total   Spent    Left  Speed\r\n100 2509k  100 2509k    0     0  4950k      0 --:--:-- --:--:-- --:--:-- 4959k\r\n\/Mariadb$ sudo python3 get-pip.py --force-reinstall\r\nCollecting pip\r\n  Downloading pip-22.3-py3-none-any.whl (2.1 MB)\r\n     \u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501 2.1\/2.1 MB 9.1 MB\/s eta 0:00:00\r\nCollecting setuptools\r\n  Downloading setuptools-65.5.0-py3-none-any.whl (1.2 MB)\r\n     \u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501 1.2\/1.2 MB 10.4 MB\/s eta 0:00:00\r\nCollecting wheel\r\n  Downloading wheel-0.37.1-py2.py3-none-any.whl (35 kB)\r\nInstalling collected packages: wheel, setuptools, pip\r\nSuccessfully installed pip-22.3 setuptools-65.5.0 wheel-0.37.1\r\nWARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https:\/\/pip.pypa.io\/warnings\/venv\r\n$ python3 -m pip install mysql-connector-python\r\nDefaulting to user installation because normal site-packages is not writeable\r\nCollecting mysql-connector-python\r\n  Downloading mysql_connector_python-8.0.31-cp310-cp310-manylinux1_x86_64.whl (23.5 MB)\r\n     \u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501 23.5\/23.5 MB 10.1 MB\/s eta 0:00:00\r\nRequirement already satisfied: protobuf<=3.20.1,>=3.11.0 in \/usr\/lib\/python3\/dist-packages (from mysql-connector-python) (3.12.4)\r\nInstalling collected packages: mysql-connector-python\r\nSuccessfully installed mysql-connector-python-8.0.31\r\n$ \r\n<\/pre>\n
13.  Create Data <\/strong>
\n(1) Create Data<\/p>\n
\r\n$ docker exec -it mariadb_1 bash\r\n# mysql -u root -p\r\nMariaDB [(none)]> CREATE DATABASE sample;\r\nMariaDB [(none)]> USE sample;\r\nMariaDB [sample]> CREATE TABLE table_sample (id INT AUTO_INCREMENT NOT NULL PRIMARY KEY, name VARCHAR(10));\r\nMariaDB [sample]> INSERT INTO table_sample (name) VALUES ('example_0'), ('example_1'), ('example_2');\r\nMariaDB [sample]> SELECT * FROM table_sample;\r\n+----+-----------+\r\n| id | name      |\r\n+----+-----------+\r\n|  1 | example_0  |\r\n|  2 | example_1  |\r\n|  3 | example_2  |\r\n+----+-----------+\r\n3 rows in set (0.001 sec)\r\n\r\nMariaDB [sample]> exit\r\nBye\r\nroot@b83838cded47:\/# exit\r\nexit\r\n$\r\n<\/pre>\n
(2) Confirm with HeidiSQL
\n\"\"<\/p>\n
14.  Exec query <\/strong>
\n(1) connect.py <\/p>\n
\r\n$ cat connect.py\r\nimport mysql.connector\r\n\r\ncon = mysql.connector.connect(db=\"sample\",\r\n                              host=\"localhost\",\r\n                              port=3307,\r\n                              user=\"admin\",\r\n                              password=\"123456\")\r\ncur = con.cursor()\r\nquery = \"SELECT id, name FROM table_sample\"\r\n\r\ncur.execute(query)\r\nrows = cur.fetchall()\r\nprint(rows)\r\ncur.close()\r\ncon.close()\r\n<\/pre>\n
(2) exec connect.py<\/p>\n
\r\n$ python3 connect.py \r\n[(1, 'example_0'), (2, 'example_1'), (3, 'example_2')]\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
1. Step (1) Install docker (2) Mariadb container install (3) connect HeidiSQL 2. Prerequisites (1) Install gno…<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts\/4290"}],"collection":[{"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4290"}],"version-history":[{"count":81,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts\/4290\/revisions"}],"predecessor-version":[{"id":4292,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts\/4290\/revisions\/4292"}],"wp:attachment":[{"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4290"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4290"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4290"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}