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.

Using the MySQL shell

Using the MySQL shell

From the course: Linux System Engineer: Database Servers Using MariaDB

Start my 1-month free trial

Using the MySQL shell

“

- [Instructor] To gain access to the Maria DB database we'll use a MySQL shell program. To run it we'll provide the user name and password. The default admin user name for Maria DB is root and the default password is blank. We'll be changing the password later. Type in MySQL space U space root space dash P and hit enter and hit enter for your password. This should give you a prompt. If we look at the prompt we can see that there's no current connection to a database. Please take note of this. Now let's take a look at the available sub-commands by typing in help. Here we can see a list of sub-commands. In the left column we have the complete command that we can type in such as help. In the next column inside parenthesis we have a shortcut preceded by a backslash. Typing backslash H is the same as typing help. It's worth nothing that these sub-commands are relative to the tasks that are being carried out. This is called our active mode because we're not connected to a database we have…

Contents