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 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:
For more information about the mysql command line program, please visit http://dev.mysql.com/doc/refman/5.1/en/mysql.html.
Subscribe to receive weekly cutting edge tips, strategies, and news you need to grow your web business.
No charge. Unsubscribe anytime.