{"id":1507,"date":"2017-02-01T05:50:07","date_gmt":"2017-02-01T05:50:07","guid":{"rendered":"http:\/\/www.fastwebhost.in\/blog\/?p=1507"},"modified":"2019-01-22T12:30:14","modified_gmt":"2019-01-22T12:30:14","slug":"how-to-select-mysql-database-linux-via-command-line","status":"publish","type":"post","link":"https:\/\/www.fastwebhost.in\/blog\/how-to-select-mysql-database-linux-via-command-line\/","title":{"rendered":"How to Select a MySQL Database on Linux via Command Line"},"content":{"rendered":"

In this tutorial you are going to learn how to select a MySQL database via command line on Linux server. Also, you’ll learn basic MySQL database operations through below steps.<\/p>\n

Let’s get straight to the point.<\/p>\n

How to access MySQL command line or shell?<\/h4>\n

If MySQL server already installed on your server, then you can access it through shell or command line.<\/p>\n

First, login to the server as a root and then enter below command to access MySQL shell interface.<\/p>\n

You can use any of the below commands to access MySQL command line.<\/p>\n

mysqlmysql -u root -p<\/p>\n

In the above command u<\/span> flag indicates root user, and -p<\/span> flag for password authentication.<\/p>\n

You have to enter password to access MySQL.<\/p>\n

mysql><\/p>\n

Now, you are ready to select a database and work on it!<\/p>\n

MySQL Database Command Line Basics<\/h3>\n

<\/span><\/p>\n