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: That worked but I now realize that I need an additional column in my table. Now that I have a table I can do a single row insert and then query the table: Finally, similar to the show databases command, I can use show tables to verify that my new table exists: The first step will be to “switch” 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 “cycles”. Now I want to add a new table and load some test data into it. 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):īack in DBeaver, if I click Refresh in the database navigator panel, my new database shows up: Now I am ready to do some database work on my MariaDB server. First, to start a Bash shell in my Docker container, I execute the “docker exec” command with the “-it” option and specify the container ID as well as the path to the bash shell: Rather than use DBeaver for this task (although I could) I want to try out some MySQL commands. Now that my new connection has a proper name, I want to create a new database. Let’s right click on the connection, select rename and type the name of our container “mariadb_quebit”: It defaulted to “localhost” since I didn’t give it a name yet and there are no Databases since it is simply an “empty” MariaDB server. You can see the connection showing up in the Database Navigator pane. You can click the Test Connection button to make sure you can connect and then click Finish to save the connection to DBeaver. So, we can use that when we create a new DBeaver connection (leave the database name blank):
DOCKER MYSQL DROP DATABASE PASSWORD
Earlier I set the password as “thebest1969” and left the port as the default (3306) in the docker run command:
To create a new connection in DBeaver (assuming that you have already installed the MariaDB drivers) you need the Port and the password. Once the container is running, it is available to connect to. 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. Two handy docker commands are docker ps and docker inspect and are shown below. I am using Docker Desktop, so if I peek at the desktop, I see my new container up and running: I want to name my container (mariadb_quebit), provide a password (thebest1969) and set a port ID (3306:3306).ĭocker run –name mariadb_quebit -e MYSQL_ROOT_PASSWORD=thebest1969 -p 3306:3306 -d docker.io/library/mariadb:10.3 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 entered mariadb:latest but you can also specify a particular version by saying mariadb:10.4 (for example):
DOCKER MYSQL DROP DATABASE WINDOWS
Since I already have docker installed and running, I can use Windows PowerShell, to can execute the docker command to “pull” the a version of MariaDB locally. 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. 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. A DBeaver connection to the container is established. In this article a MariaDB server image is created and run in a Docker container.
0 kommentar(er)
