Create a MySQL Database on Linux via Command Line


Hello! I’m Justin with Liquid Web! One of the first things a new MySQL user might wonder is, How do I create a database? In this tutorial, we are going to cover how to create a MySQL database on the command line. Before we get started, it’s important to note, I’m logged in as the root user on a Liquid Web Self-Managed CentOS 7 server. This tutorial assumes you have a working MySQL installation. Also, all of the commands used in this tutorial will be listed in the video description. First we need to get connected to MySQL: mysql -u root -p I’m utilizing the root user in this instance. Now that we have a mysql prompt it is pretty straightforward to create a database. Let’s create a database called tutorial by running the query: create database tutorial; That’s it! The database now exists. To verify that, let’s run: show databases; We can see the tutorial database in the list of databases. That’s all there is to it! You now know how to create a MySQL database on the command line! Thanks for watching! For more information, visit our Knowledge Base at liquidweb.com/kb or, our YouTube channel at youtube.com/user/liquidwebinc!

Leave a Reply

Your email address will not be published. Required fields are marked *