GUI Tools for managing MySQL databases server

Q. I am new to both Linux and MySQL database server. Can you provide any name og GUI tools for managing MySQL databases server remotely as well as locally?

ADVERTISEMENTS

A. MySQL has various GUI tools for managing MySQL databases server remotely as well as locally. However not all software are free. Here are two best free tools:

  1. MySQL Administrator – It is a powerful visual administration console that enables you to easily administer your MySQL environment and gain significantly better visibility into how your databases are operating. MySQL Administrator now integrates database management and maintenance into a single, seamless environment, with a clear and intuitive graphical user interface. Works with Windows XP, Mac OS X and Linux oses. You can download this tool here.
    Image is courtesy of MySQL.COM.
  2. phpMyAdmin – a Very popular and runs over Web. phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges,export data into various formats. You can download this tool here


🐧 Get the latest tutorials on SysAdmin, Linux/Unix, Open Source/DevOps topics:
CategoryList of Unix and Linux commands
File Managementcat
FirewallCentOS 8 OpenSUSE RHEL 8 Ubuntu 16.04 Ubuntu 18.04 Ubuntu 20.04
Network Utilitiesdig host ip nmap
OpenVPNCentOS 7 CentOS 8 Debian 10 Debian 8/9 Ubuntu 18.04 Ubuntu 20.04
Package Managerapk apt
Processes Managementbg chroot cron disown fg jobs killall kill pidof pstree pwdx time
Searchinggrep whereis which
User Informationgroups id lastcomm last lid/libuser-lid logname members users whoami who w
WireGuard VPNCentOS 8 Debian 10 Firewall Ubuntu 20.04

ADVERTISEMENTS
1 comment… add one
  • Hideo Dec 28, 2009 @ 22:30

    On KDE enviroment you have Knoda that maybe can connect to remote servers, but I’m not shure. Surely is easier than Mysql Administrator

Leave a Reply

Your email address will not be published.

Use HTML <pre>...</pre>, <code>...</code> and <kbd>...</kbd> for code samples.