{"id":3597,"date":"2023-04-12T15:39:37","date_gmt":"2023-04-12T15:39:37","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/running-mariadb-in-a-docker-container\/"},"modified":"2026-01-15T18:12:26","modified_gmt":"2026-01-15T18:12:26","slug":"running-mariadb-in-a-docker-container","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/running-mariadb-in-a-docker-container\/","title":{"rendered":"How Do I Run MariaDB in a Docker Container for Development or Testing?"},"content":{"rendered":"

In this article a MariaDB<\/a> server image is created and run in a Docker container. A DBeaver<\/a> connection to the container is established. Next, bash commands are used to execute MySQL statements to perform various database tasks such as create a new MariaDB database, create a table, create a CSV data file and load the data from the file to the table. Finally, DBeaver is used to verify all of the MySQL work and then create a new table and view the database as an ER diagram<\/a>.<\/p>\n

Pull the mariadb image locally<\/strong><\/p>\n

Since I already have docker installed and running, I can use Windows PowerShell, to can execute the docker command to \u201cpull\u201d the a version of MariaDB locally. I entered mariadb:latest but you can also specify a particular version by saying mariadb:10.4 (for example):<\/p>\n

\"\"<\/p>\n

Create a Container and Run it<\/strong><\/p>\n

Now that we have a MariaDB image available, we can use the following docker command to create a container from that image and start it. I want to name my container (mariadb_quebit), provide a password (thebest1969) and set a port ID (3306:3306).<\/p>\n

docker run –name mariadb_quebit -e MYSQL_ROOT_PASSWORD=thebest1969 -p 3306:3306 -d docker.io\/library\/mariadb:10.3<\/p>\n

\"\"<\/p>\n

I am using Docker Desktop<\/a>, so if I peek at the desktop, I see my new container up and running:<\/p>\n

\"\"<\/p>\n

Two handy docker commands are docker ps<\/a> and docker inspect<\/a> and are shown below. You can use the first to see what docker containers you have running and, once your container is running you can always use this command to see various details about the container.<\/p>\n

\"\"<\/p>\n

Connecting to the Container<\/strong><\/p>\n

Once the container is running, it is available to connect to. To do that I will use DBeaver. To create a new connection in DBeaver<\/a> (assuming that you have already installed the MariaDB drivers) you need the Port and the password. Earlier I set the password as \u201cthebest1969\u201d and left the port as the default (3306) in the docker run command:<\/p>\n

\"\"<\/p>\n

So, we can use that when we create a new DBeaver connection (leave the database name blank):<\/p>\n

\"\"<\/p>\n

You can click the Test Connection button to make sure you can connect and then click Finish to save the connection to DBeaver.<\/p>\n

\"\"<\/p>\n

You can see the connection showing up in the Database Navigator pane. It defaulted to \u201clocalhost\u201d since I didn\u2019t give it a name yet and there are no Databases since it is simply an \u201cempty\u201d MariaDB server. Let\u2019s right click on the connection, select rename and type the name of our container \u201cmariadb_quebit\u201d:<\/p>\n

\"\"<\/p>\n

Now that my new connection has a proper name, I want to create a new database. Rather than use DBeaver for this task (although I could) I want to try out some MySQL commands. First, to start a Bash shell in my Docker container, I execute the \u201cdocker exec\u201d command with the \u201c-it\u201d option and specify the container ID as well as the path to the bash shell:<\/p>\n

\"\"<\/p>\n

Now I am ready to do some database work on my MariaDB server. First, I want to create a new database. I can use the create database command to do that and then execute the show databases command to verify that the new database was created (note that the semi-colon is the command line delimiter):<\/p>\n

\"\"<\/p>\n

Back in DBeaver, if I click Refresh<\/strong> in the database navigator panel, my new database shows up:<\/p>\n

\"\"<\/p>\n

Now I want to add a new table and load some test data into it. The first step will be to \u201cswitch\u201d to the quebit database (since that is where I want to build by table object), then I will use the create table command to build a new table named \u201ccycles\u201d. Finally, similar to the show databases command, I can use show tables to verify that my new table exists:<\/p>\n

\"\"<\/p>\n

Now that I have a table I can do a single row insert<\/em> and then query the table:<\/p>\n

\"\"<\/p>\n

That worked but I now realize that I need an additional column in my table. Since there is only 1 row of data in my table, I will just drop the table and then recreate it with an updated create table statement:<\/p>\n

\"\"<\/p>\n

To make sure my table is correct this time, I can use the describe command as show below:<\/p>\n

\"\"<\/p>\n

The table looks good (I added the \u201ccycle_maker\u201d column) so now let\u2019s try to insert that single row again:<\/p>\n

\"\"<\/p>\n

Although that worked okay, rather than insert single rows one at a time, I want to try to upload from a file which contains multiple rows. So, to do that, I used the touch<\/a> command to create a CSV file then the cat<\/a> command to write multiple rows to the file:<\/p>\n

\"\"<\/p>\n

I can load the file into my table using the LOAD DATA INFILE<\/a> statement. If I query my table again, I see the original single-inserted row as well as the 3 rows that are in the CSV file:<\/p>\n

\"\"<\/p>\n

Again, if I go back to DBeaver and refresh my connection, my cycles table appears along with all of the data:<\/p>\n

\"\"<\/p>\n

Adding Another Table<\/strong><\/p>\n

From within DBeaver I wanted to add a new table named \u201csales\u201d and have it linked to the original cycles table, so I clicked on the Open SQL script<\/strong> icon and executed the following SQL statement:<\/p>\n

\"\"<\/p>\n

Again, refreshing the connection, we can see the new table:<\/p>\n

\"\"<\/p>\n

ER Diagrams<\/strong><\/p>\n

You can use DBeaver to create custom ER diagrams that can contain any tables, relations and notes in a database. To do that, you can right-click on the quebit database and then select View Databases<\/strong>:<\/p>\n

\"\"<\/p>\n

You\u2019ll see both a properties tab and a ER Diagram tab:<\/strong><\/p>\n

\"\"<\/p>\n

The new diagram appears in a separate editor where you can drag-n-drop tables into it. You can even add tables from different <\/em>connections as well as from different database types (for example, combine Oracle and MySQL tables in one and the same diagram). You can also add notes and custom relations (associations) using the ERD palette on the left side of diagram tab!<\/p>\n","protected":false},"excerpt":{"rendered":"

In this article a MariaDB server image is created and run in a Docker container. A DBeaver connection to the container is established. Next, bash commands are used to execute MySQL statements to perform various database tasks such as create a new MariaDB database, create a table, create a CSV data file and load the…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[27],"tags":[32],"class_list":["post-3597","post","type-post","status-publish","format-standard","hentry","category-quebit-value","tag-sql"],"acf":[],"yoast_head":"\nHow Do I Run MariaDB in a Docker Container for Development or Testing? - QueBIT<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/quebit.com\/askquebit\/running-mariadb-in-a-docker-container\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How Do I Run MariaDB in a Docker Container for Development or Testing? - QueBIT\" \/>\n<meta property=\"og:description\" content=\"In this article a MariaDB server image is created and run in a Docker container. A DBeaver connection to the container is established. Next, bash commands are used to execute MySQL statements to perform various database tasks such as create a new MariaDB database, create a table, create a CSV data file and load the…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quebit.com\/askquebit\/running-mariadb-in-a-docker-container\/\" \/>\n<meta property=\"og:site_name\" content=\"QueBIT\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-12T15:39:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-15T18:12:26+00:00\" \/>\n<meta name=\"author\" content=\"agoddard\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"agoddard\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/running-mariadb-in-a-docker-container\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/running-mariadb-in-a-docker-container\\\/\"},\"author\":{\"name\":\"agoddard\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"headline\":\"How Do I Run MariaDB in a Docker Container for Development or Testing?\",\"datePublished\":\"2023-04-12T15:39:37+00:00\",\"dateModified\":\"2026-01-15T18:12:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/running-mariadb-in-a-docker-container\\\/\"},\"wordCount\":1018,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/running-mariadb-in-a-docker-container\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/DB1-min.jpg\",\"keywords\":[\"SQL\"],\"articleSection\":[\"QueBIT Value\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/running-mariadb-in-a-docker-container\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/running-mariadb-in-a-docker-container\\\/\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/running-mariadb-in-a-docker-container\\\/\",\"name\":\"How Do I Run MariaDB in a Docker Container for Development or Testing? - QueBIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/running-mariadb-in-a-docker-container\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/running-mariadb-in-a-docker-container\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/DB1-min.jpg\",\"datePublished\":\"2023-04-12T15:39:37+00:00\",\"dateModified\":\"2026-01-15T18:12:26+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/running-mariadb-in-a-docker-container\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/running-mariadb-in-a-docker-container\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/running-mariadb-in-a-docker-container\\\/#primaryimage\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/DB1-min.jpg\",\"contentUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/DB1-min.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/running-mariadb-in-a-docker-container\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How Do I Run MariaDB in a Docker Container for Development or Testing?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\",\"name\":\"QueBIT\",\"description\":\"QueBIT\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\",\"name\":\"agoddard\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"caption\":\"agoddard\"},\"sameAs\":[\"https:\\\/\\\/quebit.com\\\/askquebit\"],\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/author\\\/agoddard\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How Do I Run MariaDB in a Docker Container for Development or Testing? - QueBIT","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/quebit.com\/askquebit\/running-mariadb-in-a-docker-container\/","og_locale":"en_US","og_type":"article","og_title":"How Do I Run MariaDB in a Docker Container for Development or Testing? - QueBIT","og_description":"In this article a MariaDB server image is created and run in a Docker container. A DBeaver connection to the container is established. Next, bash commands are used to execute MySQL statements to perform various database tasks such as create a new MariaDB database, create a table, create a CSV data file and load the…","og_url":"https:\/\/quebit.com\/askquebit\/running-mariadb-in-a-docker-container\/","og_site_name":"QueBIT","article_published_time":"2023-04-12T15:39:37+00:00","article_modified_time":"2026-01-15T18:12:26+00:00","author":"agoddard","twitter_card":"summary_large_image","twitter_misc":{"Written by":"agoddard","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quebit.com\/askquebit\/running-mariadb-in-a-docker-container\/#article","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/running-mariadb-in-a-docker-container\/"},"author":{"name":"agoddard","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"headline":"How Do I Run MariaDB in a Docker Container for Development or Testing?","datePublished":"2023-04-12T15:39:37+00:00","dateModified":"2026-01-15T18:12:26+00:00","mainEntityOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/running-mariadb-in-a-docker-container\/"},"wordCount":1018,"commentCount":0,"image":{"@id":"https:\/\/quebit.com\/askquebit\/running-mariadb-in-a-docker-container\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/03\/DB1-min.jpg","keywords":["SQL"],"articleSection":["QueBIT Value"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quebit.com\/askquebit\/running-mariadb-in-a-docker-container\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quebit.com\/askquebit\/running-mariadb-in-a-docker-container\/","url":"https:\/\/quebit.com\/askquebit\/running-mariadb-in-a-docker-container\/","name":"How Do I Run MariaDB in a Docker Container for Development or Testing? - QueBIT","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/running-mariadb-in-a-docker-container\/#primaryimage"},"image":{"@id":"https:\/\/quebit.com\/askquebit\/running-mariadb-in-a-docker-container\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/03\/DB1-min.jpg","datePublished":"2023-04-12T15:39:37+00:00","dateModified":"2026-01-15T18:12:26+00:00","author":{"@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"breadcrumb":{"@id":"https:\/\/quebit.com\/askquebit\/running-mariadb-in-a-docker-container\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quebit.com\/askquebit\/running-mariadb-in-a-docker-container\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quebit.com\/askquebit\/running-mariadb-in-a-docker-container\/#primaryimage","url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/03\/DB1-min.jpg","contentUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/03\/DB1-min.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/quebit.com\/askquebit\/running-mariadb-in-a-docker-container\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quebit.com\/askquebit\/"},{"@type":"ListItem","position":2,"name":"How Do I Run MariaDB in a Docker Container for Development or Testing?"}]},{"@type":"WebSite","@id":"https:\/\/quebit.com\/askquebit\/#website","url":"https:\/\/quebit.com\/askquebit\/","name":"QueBIT","description":"QueBIT","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/quebit.com\/askquebit\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084","name":"agoddard","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","caption":"agoddard"},"sameAs":["https:\/\/quebit.com\/askquebit"],"url":"https:\/\/quebit.com\/askquebit\/author\/agoddard\/"}]}},"_links":{"self":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3597","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/comments?post=3597"}],"version-history":[{"count":1,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3597\/revisions"}],"predecessor-version":[{"id":4913,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3597\/revisions\/4913"}],"wp:attachment":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media?parent=3597"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/categories?post=3597"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/tags?post=3597"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}