5+ Free MySQL Admin Tools

7447

dbForge Studio is a universal MySQL client for Windows that enables MySQL developers and administrators to create and execute queries, develop and debug MySQL routines, automate MySQL database object management in the convenient environment, and many others. This MySQL frontend GUI tool provides utilities to compare, synchronize, and backup MySQL databases with scheduling, and gives possibility to analyze and report MySQL tables data.

dbForge Studio for MySQL works with any MariaDB database servers, and supports all MariaDB objects types. You can visually design database structures, execute SQL queries and scripts, and manage MariaDB users and their privileges. Express Edition is free.

DBManager has builtin support for MySQL, PostgreSQL, Interbase/Firebird, SQLite, DBF tables, MSAccess, MSSQL Server, Sybase, Oracle and ODBC database engines. Manages databases, tables (including indexes, triggers), query editor, import and export wizards, database comparer, form and report builder, task builder to automate tasks, server, database and table activity monitor. Standard version is free for personal use.

HeidiSQL is designed for web developers using MySQL server, Microsoft SQL databases and PostgreSQL. It enables you to browse and edit data, create and edit tables, views, procedures, triggers and scheduled events. Also, you can export structure and data either to SQL file, clipboard or to other servers.

MySQL WorkBench – provides DBAs and developers an integrated tools environment for: Database Design & Modeling, SQL Development, Database Administration, Database Migration.

MyDB Studio is a complete collection of powerful tools for MySQL Server administration. Create/modify/delete database, backup and restore, export to XML, Excel and Word, synchronize database, foreign key support, table optimization, create queries, create php scripts etc. Now supports SSH tunneling.

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, MariaDB and Drizzle. 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.

Sequel Pro for Mac gives direct access to your MySQL databases on local and remote servers. Lots of functionality including bubdles to add functionality, filter and paginate table content, query editor, connection management, CSV import, full table management including indexes, table triggers, database creation, deletion and renaming.