how to configure Phpmyadmin and use mysql on terminal in UBUNTU/LINUX

To configure phpmyadmin, use synaptic Package manager.

To run mysql on terminal, simply go to terminal and write command as below:

aanand@aanand-desktop:~$ mysql --user=root --password=root
Here, you can user the user and password as you have supplied during installation.

Now, you will see messages as below:


Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 26
Server version: 5.0.51a-3ubuntu5.7 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

Your system is ready to run mysql commands and execute queries.
To test, you can write commands like
mysql>show databases;
mysql>use test;
mysql>show tables;
To get the help, use help command as below:
mysql>\h;
mysql>\help;