How to use phpmyadmin mysql database using terminal in ubuntu 10.4?

Question

Can any one help me to use phpmyadmin mysql database through terminal.

I am using ubuntu 10.4.

I guess the command like this /opt/var/usr/ mysql. I'm not sure about it.

Answer 1

In terminal just type:

mysql -u username -p

and afterwards you'll be prompted for your password.

Normally MySQL is added to /bin/ so no need to explicitly give a path to it.

Answer 2

The Below command used to access phpmyadmin mysql database though terminal

/opt/lampp/bin/mysql -uroot -ppassword