MySQL command line client for Linux

Question

I just installed MySQL 5.6 in a new CentOS 7 Linux installation. I want to use the MySQL command line client that I have been used to using in Windows, but I cannot seem to find it. Is there a MySQL command line client for Linux? If so, how do I make sure that I have it? And how do I open it up in the GUI?

mysql is the MySQL client in command line. There is no GUI apart from the terminal window. — Tomasz Kowalczyk
– Tomasz Kowalczyk, Commented Nov 25, 2014 at 3:18
just issue: mysql -u mysq_user -p in the terminal. This will let you enter the mysql command line. — unixmiah
– unixmiah, Commented Nov 25, 2014 at 3:24
@unixmiah Only assuming they have a mysql server running locally. — Devon Bessemer
– Devon Bessemer, Commented Nov 25, 2014 at 3:27

Sharique · Accepted Answer · 2014-11-25 09:50:42Z

1

You can open MySql command line utility using following command

mysql -u user_name -p

It will ask for password for user_name. If password is not set call as follows

mysql -u user_name

answered Nov 25, 2014 at 9:50

Sharique

4,2296 gold badges38 silver badges54 bronze badges

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

Comments

Alexander · Accepted Answer · 2014-11-25 09:47:02Z

1

First make sure the service is running :

sudo systemctl start mysqld

Then make sure to run the security script that will remove some dangerous defaults and lock down access to our database system a little bit.

sudo mysql_secure_installation

Now you can use the command line tool

mysql --user=user_name --password=your_password db_name

answered Nov 25, 2014 at 9:47

Alexander

12.8k5 gold badges62 silver badges79 bronze badges

Collectives™ on Stack Overflow

MySQL command line client for Linux

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related