mysql database access

web-based tool for accessing mysql database :

sudo apt-get install phpmyadmin
sudo apt-get install mysql-admin mysql-query-browser

MySQL Query Browser : sudo apt-get install mysql-query-browser

MySQL Admin UI : sudo apt-get install mysql-admin

For MySQL phpmyadmin : sudo apt-get install phpmyadmin

on browser test it :

http://localhost/phpmyadmin/

In terminal execute the command :

mysql -u root -h localhost -p

Then enter your root password and you will get the mysql prompt.

mysql>

Just for testing purpose, lets create a database. Execute the following commands -

create database test;
show databases;

Have a nice journey.