MySQL

From Got Opinion Wiki
Jump to navigation Jump to search

I've switched to MariaDB vs Oracle MySQL.

MySQL Notes

MySQL basics

Free MySQL Tools

ORBADA is an excellent tool for database developers, SQL developers, DBA administrators, as well as for users who wish to broaden their knowledge and skills in SQL.

Advanced functionally and intuitive and clear graphical interface makes it easier to administer the database. By using JDBC libraries allows you to connect to multiple databases. Dedicated plug-ins for databases such as Oracle, SQLite, Firebird, HSQLDB, DerbyDB allow even better use of their possibilities. Well-rounded graphic interface that allows to perform simple tasks as well and advanced operations DBA too. A clear menu system and multiple tabs makes browsing, searching and modifying objects in a database easy for each user.

HeidiSQL is a lightweight, Windows based interface for MySQL databases. 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.

Bear SQL is a free web interface to your MySQL Database. It aims to make managing your database easy. If you're someone with no SQL skills or just want to get the job done simply and easily, Bear SQL is for you.

SQL ICE is a comprehensive tool to manage all your queries for all your databases in one place - including scheduled batch updates and even reports that are e-mailed to users.

MyDB Studio is a complete collection of powerful tools for MySQL Server administration.

Free & Commercial MySQL Tools

The free version of commercial software is usually gutted of features. I don't recommend these software packages unless you want to try before you buy.

MySQL Workbench

SQLyog is the most powerful MySQL manager and admin tool, combining the features of MySQL Workbench, phpMyAdmin and other MySQL Front Ends and MySQL GUI tools.

dbForge Studio is a powerful and comprehensive MySQL GUI tool that provides a complete set of instruments for server management and administration.

Jet Profiler for MySQL is a real-time query performance and diagnostics tool for the MySQL database server.

MySQL Links

MySQL Intro

How to set hostname

To Computing area