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
Maintain Your Computer and Use it More Effectively
to Design a Web Site and Make Money on the Web

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

Victims of Sandy Hook

Stop the Slaughter of Innocents. Congress is bought and paid for by gun lunatics and gun promotion groups. If you want to live in a safe America, help buy Congress back for America. Send a donation to Mayors Against Illegal Guns, 909 Third Avenue, 15th Floor New York, NY 10022


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-2017 Bucaro TecHelp 13771 N Fountain Hills Blvd Suite 114-248 Fountain Hills, AZ 85268