Home » Categories » Multiple Categories

Is there a graphical interface available 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
  5. You should now be able to connect to your database
1 (1)
Article Rating (1 Votes)
Rate this article
  • Icon PDFExport to PDF