Question

2

rated 0 times [ 2] [ 0] / answers: 1 / hits: 10361 / 3 Years ago, thu, july 1, 2021, 5:42:43

1) I have installed mysql server and mysql client through apt-get install mysql-server and apt-get install mysql-client

2) when I run sudo netstat -tap | grep mysql, I see following:

tcp        0      0 localhost:mysql         *:*                     LISTEN      15138/mysqld

I think it is running

3) now I go to usr/share/mysql and type:
show databases; it shows me following,

The program 'show' is currently not installed.  You can install it by typing:

apt-get install nmh

Can anybody please tell me what is the problem ? Am I running command from wrong directory ?

Thanks,

Only authorized users can answer the question. Please sign in first, or register a free account.

Total Points: 432

Total Questions: 115

Total Answers: 109

Location: Wallis and Futuna

Member since Tue, Mar 30, 2021

3 Years ago

answered 3 Years ago biryanrownies · Accepted Answer

You first need to login to your mysql account by this command:

mysql -u <username> -p

<username> should be replaced by your username. Then it will ask you for your password. Enter you password and run this command :

show databases;

It will be better if you also install :

sudo apt-get install mysql-common