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
Related Articles
How do I connect to my MySQL database using PHP?
Added on Thu, Feb 26, 2015
What is MySQL and what does it do?
Added on Thu, Feb 26, 2015
How do I connect to my MySQL database from my Perl script?
Added on Thu, Feb 26, 2015
How do I connect to MySQL with ASP?
Added on Thu, Feb 26, 2015
How do I set up a MySQL connection in Dreamweaver?
Added on Thu, Feb 26, 2015