I want to walk you through the installation of MySQL Workbench as well as the steps necessary on your MySQL servers to enable connection from the new tool. And with MySQL Workbench, you can also migrate Microsoft SQL Server, Microsoft Access, Sybase ASE, PostreSQL, and other RDBMS tables, objects, and data to MySQL with ease. MySQL Workbench is a powerhouse tool for developers and administrators. With this tool you can get an at-a-glance for the database server’s status, client connections, and server variables manage users and privileges export/import data run queries create new schema inspect objects create tables create views create stored procedures and functions search table data and more. MySQL Workbench is a unified GUI for database architects, developers, and DBAs, that makes administering multiple databases (from multiple hosts) significantly more efficient. What if you could have a single point of entry for every MySQL database you administer? If that’s something you’re looking for, then you might want to give MySQL Workbench a try.
#MYSQL CREATE DATABASE WORKBENCH INSTALL#
Of course, you could always install phpMyAdmin on each server, but then you’re having to log into a different web interface for each machine. But when you have a number of databases to work with, running on multiple database servers, a GUI would certainly come in handy. If you’re a DBA, chances are you do most of your database administration via the command line.