10 of the best MySQL database Client GUI management tools

10 of the best MySQL database Client GUI management tools

MySQL has become the most popular open-source database in the past because of its high performance, low cost, and good reliability. Therefore, MySQL is widely used in small and medium websites on the Internet. As MySQL continues to mature, it is gradually used for more large-scale websites and applications, such as Wikipedia, Google and Facebook. The "M" in LAMP, a popular open-source software combination, refers to MySQL.

MySQL was initially a database software developed by MySQL AB in Sweden. Sun Microsystems acquired it in 2008. In 2009, Oracle acquired Sun Microsystem, and MySQL became a product of Oracle.

However, after being acquired by Oracle, Oracle significantly increased the price for the MySQL commercial version, and Oracle no longer supported the development of another free software project OpenSolaris, as a result, the Free Software Community is worried about whether Oracle will continue to support the MySQL Community edition (the only free version in MySQL, therefore, some open-source software using MySQL has gradually switched to other databases.

The MySQL database itself comes with a command line tool (command mysql and mysqladmin) and a graphical management tool MySQL Workbench. However, the functionality and ease-of-use of built-in tools are not comparable to those developed by third parties. The most famous example is phpMyAdmin, which allows you to perform almost any management tasks for MySQL. But it is a Web interface management tool. The 10 MySQL database client graphical interface management tools (including phpMyAdmin) We will introduce below are all very good software with their respective strengths. Most of them are open-source and free, and several are commercial software, but you can try it out.

MyDB Studio

DBTools Manager

DbForge Studio

SQLWave

PhpMyAdmin

Sequel Pro

SQL Maestro MySQL Tools Family

HeidiSQL

Navicat

Workbench

From: netsmell.com

Example of LAMP architecture collaborative application-phpMyAdmin

PhpMyAdmin and Wordpress for LAMP applications

PhpMyAdmin logon timeout Solution

Install phpMyAdmin and Adminer in Ubuntu

Implement SSL functions based on LAMP and install phpMyAdmin

Configure the LAMP + phpMyAdmin PHP (5.5.9) development environment in Ubuntu 14.04

This article permanently updates the link address: