Connect to database through MySql command line client

Question

I am following this tutorial: http://dev.mysql.com/doc/refman/5.7/en/connecting-disconnecting.html

However when I run MySql command line client I automatically get asked for a password when I enter it I get connected automatically to a localhost database, how do I access other database's using something like the following as shown in the tutorial example?

shell> mysql -h host -u user -p
Enter password: ********

Do you mean other databases on the same host, or other database hosts? — Jericon
– Jericon, Commented Feb 4, 2014 at 2:51

Jim Wharton · Accepted Answer · 2014-02-17 18:51:00Z

3

shell> mysql nameofdatabase -uusername -ppassword

You can put a space in between -u username but not between the -p and password.

edited Feb 17, 2014 at 18:51

answered Feb 3, 2014 at 19:47

Jim Wharton

1,4154 gold badges21 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user3199791 Over a year ago

Thanks for the reply. I do not have shell> on my command line, as soon as I type in my password (which is initially asked for when I load the terminal) I get it starting with mysql>

Jericon Over a year ago

Actually, this is not correct. If you leave a space between -p and password it will prompt you to enter the password interactively and use "password" as the database that you wish to use.

Jim Wharton Over a year ago

I'm editing my answer as the ability to leave a space after -p is NOT possible. I apologize for the error.

Jericon · Accepted Answer · 2014-02-04 02:55:49Z

There are multiple ways to access mysql on the command line. If you wish to connect to another database server, you need to add -h <hostname> to your mysql command. Without this, mysql assumes you want to connect to the local mysql server.

If you mean that you want to connect to another database on a host, just specify that database at the end of your command line.

$ mysql -u username -ppassword second_database

Note, there is NO space between -p and password. If -p is followed by a space, mysql will prompt you to enter a password interactively. Which you can do, if that is what you want.

$ mysql -u username -p third_database
Enter password: *********

Another way to connect would be to create a file in your home directory named .my.cnf. This file should contain the following:

[client]
user=username
password=yourpassword

If you have any special characters in your password, you will need to quote it. Having this file allows you to not need to enter any username or password on your command line:

$ mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
....
mysql>

Collectives™ on Stack Overflow

Connect to database through MySql command line client

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related