Phpmyadmin is a tool written over php. it is a free tool to perform administration of mysql over web.It is a Intuitive web interface, support of most of the mysql features like create, browse and drop database, crud operations on tables, manage mysql users and their privileges, manage stored procedures and triggers. Importing data from csv and sql is very easy with phpmyadmin.
To install php myadmin on ubuntu follow these steps
sudo apt-get update sudo apt-get install phpmyadmin -y
Setup phpmyadmin to work with local host
sudo ln -s /usr/share/phpmyadmin /var/www/html vim /etc/apache2/apache2.conf Include /etc/phpmyadmin/apache.conf