Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I installed MySQL using webmin on Ubuntu but unable to login to MySQL using shell. I can see the MySQL process

root@host:/# service mysql start
mysql start/running, process 23730

root@host:/# ps -ef | grep mysql
mysql    21042     1  0 11:06 ?        00:00:00 /usr/sbin/mysqld

But when I try to login, it shows the below message

root@host:/# mysql
-bash: /usr/bin/mysql: No such file or directory

Here is the error log

121223 11:15:09 [Note] Plugin 'FEDERATED' is disabled.
121223 11:15:09  InnoDB: Initializing buffer pool, size = 8.0M
121223 11:15:09  InnoDB: Completed initialization of buffer pool
121223 11:15:12  InnoDB: Started; log sequence number 0 3042138
121223 11:15:13 [Note] Event Scheduler: Loaded 0 events
121223 11:15:13 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.63-0ubuntu0.11.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
share|improve this question
2  
Looks like the server is running but you don't have the client installed. Which is odd, because I was under the impression that on Ubuntu, one depended on the other. What happens if you do sudo dpkg --list | grep mysql? –  growse Dec 23 '12 at 10:32
    
Though I strongly believe you are right, but the issue seems to be something else. As if the client package wouldn't have been installed, it would have shown the error mysql: command not found, instead of this error or would have shown this suggestion The program 'mysql' can be found in the following packages:, as this shows that it is reading the file and the location but somehow something else is missing. –  GeekRide Dec 23 '12 at 16:48
    
Thanks for the replies. Surprisingly it is working fine now :(. I didn't do anything. I am on a VPS. –  newbie Dec 23 '12 at 17:50
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.