Mysql Server Administration Tools

Sponsored Link

The MySQL™ software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. MySQL is a trademark of Oracle Corporation and/or its affiliates, and shall not be used by Customer without Oracle's express written authorization. Other names may be trademarks of their respective owners.

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

Sponsored Link