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. 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. As with creating your database, you can create your tables either programmatically or via the GUI.If you’re a DBA, chances are you do most of your database administration via the command line. You can also add code that checks for the existence of any databases that already use that name. This is as quick and easy as writing CREATE DATABASE VegeShop. You can tell when a database is the default database because its name is rendered in a bold typeface: Creating Databases ProgramaticallyĪs mentioned, you can also create your databases programmatically. You can set the new database as the default database by right-clicking on it and selecting Set as Default Schema: You will now see your new database listed under the SCHEMAS tab on the left pane: Setting the Default Database You should see the following screen once the database has been created:.To run the statement (and create the database) click Apply: You are prompted to review the SQL statement that will be run to create the database.Enter the schema name (in this case, VegeShop) and the default collation (in this case, latin1 - default collation), then click the Apply button:.Click the icon for creating a new schema (you'll find this on the Workbench toolbar):.

In the following example, we create a new database called 'VegeShop'. You can also create a database programmatically but here's how to do it via the GUI. You can use the MySQL Workbench GUI to create a database.

Creating a gui for mysql database