From the course: Linux System Engineer: Database Servers Using MariaDB
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Create a database with tables
From the course: Linux System Engineer: Database Servers Using MariaDB
Create a database with tables
- [Instructor] Now that we've gone over the commands needed to change databases, create databases, and insert or update records, let's walk through this process. Let's start by showing the databases that currently exist. Be sure you're logged into MariaDB as the root database user, using my SQL command. Type in mysql, space, dash u, space, root, space dash p, and hit enter, and then hit enter again for your password. Type in show, space, databases, semicolon, and hit enter. We see that we have four databases, information_schema, mysql, performance_schema, and test. We can also see from our prompt that we have not selected a database using the use command. Now, let's create a database called linuxdevs. Type in create, space, database, space, linuxdevs, semicolon, and then hit enter. Now, type in show, space, databases, semicolon, to verify. If it's not there, look for an error message saying it wasn't created, and troubleshoot it before moving on. Now, let's use the linuxdevs database.…