Portal Home > Knowledgebase > Database > MySQL > Graphical Interface for MySQL

Graphical Interface for MySQL

From the MySQL web site, you can download MySQL Workbench, a visual tool for working with MySQL, at: http://www.mysql.com/products/workbench/.

Useful for database architects, developers, and administrators, MySQL Workbench provides data modelling, SQL development, and comprehensive administrative tools for server configuration, user administration, and more.

MySQL Workbench is available for Windows, Linux, and Mac OS.

When you have downloaded and installed MySQL Workbench onto your computer, you can connect it to your MySQL database and run queries, create or edit SQL statements, manage your databases, create, modify, or delete tables, and get help and information on objects, parameters, and functions within MySQL.

To connect MySQL Workbench to your database:

1. Under ‘Hostname’, enter in your domain name or the IP address of your web server
2. Under ‘Port’, enter 3306
3. Under ‘Username’, enter in the database name
4. Under ‘Password’, enter in the database password

You should now be able to connect to your database

Print this Article

Powered by WHMCompleteSolution