From the course: Red Hat Enterprise Linux 8 Essential Training

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

Create a database with tables

From the course: Red Hat Enterprise Linux 8 Essential Training

Start my 1-month free trial

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 Maria DB as the root database user, using the My SQL command. Type in My SQL, space dash U, space root, space dash P and hit enter, and then hit enter again for your password. Type in show space databases, semi-colon, and hit enter. We see that we have four databases, information schema, My SQL, performance schema, and test. We can also see from our prompts that we have not selected a database using the use command. Now let's create a database called Linux devs. Type in create, space database, space Linux devs, semi-colon, and hit enter. Now type in show, space databases, semi-colon to verify. If it's not there, look for an error message saying it wasn't created in troubleshooter…

Contents