In my previous article "Gettting Started With MySQL Database" we installed MySQL on Windows and worked with it using MySQL monitor in a DOS window. In this article, rather than work with a DOS window, we will use a free Windows Graphical Interface to MySQL.
Welcome to Bucaro TecHelp!

Bucaro TecHelp
HTTPS Encryption not required because no account numbers or
personal information is ever requested or accepted by this site

About Bucaro TecHelp About BTH User Agreement User Agreement Privacy Policy Privacy Site Map Site Map Contact Bucaro TecHelp Contact RSS News Feeds News Feeds

A Free Windows Graphical Interface to MySQL

MySQL is a powerful relational database management system used by many major organizations such as Yahoo, NASA and the U.S. Census Bureau. The best thing about MySQL is that it is open source software available free of charge for non-commercial use under the open source GNU public License.

In my previous article "Gettting Started With MySQL Database" we installed MySQL on Windows and worked with it using MySQL monitor in a DOS window. While you can perform most database tasks with MySQL monitor, it gets pretty tedious working in a DOS window.

Rather than work with a DOS window, you will want to download MySQLGUI from www.mysql.com. MySQLGUI is a graphical interface to MySQL that can do the same things as MySQL monitor. Versions of MySQLGUI are available for Windows and Linux.

MySQLGUI

For Windows, you'll need to extract the zip file. I recommend extracting it to a new subfolder of the mysql folder. Before opening MySQLGUI, make sure the mysql database server is running. To start MySQL server open a MS-DOS prompt and type the following line.

C:\mysql\bin\mysqld-max

Then double-click on the file mysqlgui.exe. When you first start MySQLGUI you are prompted for a password. Enter the password for the root user ("mysql" if you haven't changed it), and then click on the Options button.

In the "MySQLGUI client options" dialog box, click on the server tab and specify the host name for MySQL server (localhost if on the same machine). Also enter the name of a default database. In the previous article we created a database named firstdb.

RSS Feed RSS Feed

Follow Stephen Bucaro Follow @Stephen Bucaro

Fire HD
[Site User Agreement] [Privacy Policy] [Site map] [Search This Site] [Contact Form]
Copyright©2001-2018 Bucaro TecHelp 13771 N Fountain Hills Blvd Suite 114-248 Fountain Hills, AZ 85268