How to connect to MySQL from the command line

This article explains how to use the mysql program to establish a command-line connection to MySQL. Direct database access is made quick and simple with the help of the mysql application.

Connecting to MySQL from the Command Line

To connect to MYSQL from the command line, follow these steps:

1. Log in to your Hostvento Hosting account using SSH.
2. At the command line, type the following command, replacing username with your username:Copymysql -u username -p
3. At the Enter Password prompt, type your password. When you type the correct password, the mysql> prompt appears.
4. To display a list of databases, type the following command at the mysql> prompt:
   Copyshow databases;Make sure you do not forget the semicolon at the end of the statement.
5. To access a specific database, type the following command at the mysql> prompt, replacing dbname with the name of the database that you want to access:
   Copyuse dbname;Make sure you do not forget the semicolon at the end of the statement.
6. After you access a database, you can run SQL queries, list tables, and so on. Additionally:
   • To view a list of MySQL commands, type help at the mysql> prompt.To exit the mysql program, type \q at the mysql> prompt.
   When you run a command at the mysql> prompt, you may receive a warning message if MySQL encounters a problem. For example, you may run a query and receive a message that resembles the following:Query OK, 0 rows affected, 1 warning (0.04 sec).To view the complete warning message, type the following command:CopySHOW WARNINGS;

Also Read

Using MySQL client applications

How to convert a MySQL database to UTF-8 encoding

Getting familiar with the home screen of cPanel