How to Create a MySQL Database Using the Command Line

Learn how to create a MySQL Database using the command-line interface (CLI). This is helpful if you have a server that does not include cPanel, such as InMotion’s Unmanaged Cloud VPS plans.

00:00 Intro
00:21 Log into Your Server via SSH
00:28 Log into MySQL as the root User
00:37 Create a New Database User
00:45 Grant the User Privileges
00:57 Log out of MySQL
01:03 Log into MySQL as the New Database User
01:15 Verify Privileges
01:25 Create a MySQL Database Using the Command Line
01:34 Outro

► Read our full guide on How to Create a MySQL Database Using the Command Line:

Related Articles:
► How to Connect to your Server with SSH:

► How to Access MySQL via Command Line:

#CreateDatabase #MySQL #CLI #commandline

About Us:

InMotion Hosting was founded in 2001 and provides personal and business web hosting for everyone! For more information about our scalable unmanaged VPS plans, visit us at

[arthurl.rozieriv]

Once you've entered in your credentials, your prompt looks like this:

mysql>

I've installed MySQL 08.024, but when I connect to MySQL in the Powershell, my command prompt looks like this:

MySQL localhost:33060+ ssl JS>

... where "MySQL" and "JS" have colorful backgrounds (even in the terminal)

Do you know why this is? I have not logged in using ssh like you did at the beginning...extremely new to this, but if you have an answer, it'll help me get on track