Mysql Server Administration Tools
Sponsored Link
We have already discussed how to install mysql in ubuntu 16.04 server this tutorial will help how to manage Mysql remotely using GUI
Phpmyadmin
phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB. Frequently used operations (managing databases, tables, columns, relations, indexes, users, permissions, etc) can be performed via the user interface, while you still have the ability to directly execute any SQL statement.
Install phpmyadmin on ubuntu
From the command prompt run the following command
sudo apt-get install phpmyadmin
Mysql Workbench
MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows, Linux and Mac OS X.
Install mysql workbench on ubuntu
From the command prompt run the following command
sudo apt-get install mysql-workbench
Emma
emma is a graphical toolkit for MySQL database developers and administrators, it is the successor of yamysqlfront.
Its main features are:
Dialogs to create/modify MySQL databases, tables and associated indexes
Result sets grouped in tabs
SQL editor: + Tabs + Built-in syntax highlighting + Table and field name tab-completion + Automatic SQL statement formatting
Export to CSV files
Multiple simultaneously opened MySQL connections
Install Emma on ubuntu
From the command prompt run the following command
sudo apt-get install emma