This article describes how to connect to MySQL from the command line using the mysql program. You can use the mysql program as a quick and easy way to access your databases directly.
To connect to MySQL from the command line, follow these steps:
mysql -u username -p
To display a list of databases, type the following command at the mysql> prompt:
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:
After you access a database, you can run SQL queries, list tables, and so on. Additionally:
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:
Subscribe to receive weekly cutting edge tips, strategies, and news you need to grow your web business.
No charge. Unsubscribe anytime.
Did you find this article helpful? Then you'll love our support. Experience the A2 Hosting difference today and get a pre-secured, pre-optimized website. Check out our web hosting plans today.