Home arrow MySQL arrow Page 2 - MySQL Made Easy With MySQL Front

MySQL Made Easy With MySQL Front

MySQL Front allows anyone to easily create and manage their MySQL databases. In this tutorial Ryan shows us how to get up and running with MySQL Front.

Author Info:
By: Ryan Schwiebert
Rating: 5 stars5 stars5 stars5 stars5 stars / 55
May 30, 2002
  1. · MySQL Made Easy With MySQL Front
  2. · Connecting to the database
  3. · Adding Tables
  4. · Conclusion

print this article

MySQL Made Easy With MySQL Front - Connecting to the database
(Page 2 of 4 )

In order to properly connect to the MySQL server, the first thing you need to have is an account with adequate rights. This account must have at least read access from a specific remote host. It would be advisable, however to set up an admin account with the following privileges: select, insert, update, delete, create, and drop. You can set up such an account by running the following SQL at the MySQL console:

grant select,insert,update,delete,create,drop on *.* to admin@"%" identified by 'passwrd';

When MySQL Front is first launched, a Host Connection dialog box, similar to the one below will greet you. This dialog box asks for the information required to make the connection to the MySQL server. Let's begin by pressing "New." This creates a favorite to our new connection. Next, fill in the information pertaining to your MySQL server.

The fields are defined as follows:
  • Description: A logical name for your MySQL Server.
  • Hostname/IP: The server you wish to connect to. Valid entries include the domain name or IP address of the server, such as MYSERVER or
  • User: The MySQL user account you wish to use.
  • Password: A valid MySQL user password.
  • Port: The port that the MySQL server is using. The default port is 3306, however many hosting companies change this port number to increase server security.
  • Database(s): The databases you wish to connect to. If this field is left blank, you will be connected to all of the databases for which you have the permissions to access on this server.
Connecting to your MySQL database

After you have entered all of the pertinent information, click the "Save" button to store this information as a favorite. For added security, it is highly advisable not to save the password information as part of the favorite.

To connect to the server, press the "Connect" button. With a little luck, you should now be connected to your MySQL server.

Creating a Database
Notice that MySQL Front lists the databases that you are connected to along the left hand side of the screen, and gives information about the server on the right. The first logical step is to use MySQL Front to create a new database. As with any program, there are several methods of accomplishing this. Two common ways are to either click the "Create Database" button, or to right click the database listing area and choose "Create Database."

Creating a database

In the dialog that follows, fill in the database name you wish to use and click "OK" to complete the process. Notice that your new database now appears in the menu tree along the left. For this tutorial, we will continue to use this database. If you wish to delete this database later, simply right click on it and choose "DROP DATABASE."
blog comments powered by Disqus

- MySQL and BLOBs
- Two Lessons in ASP and MySQL
- Lord Of The Strings Part 2
- Lord Of The Strings Part 1
- Importing Data into MySQL with Navicat
- Building a Sustainable Web Site
- Creating An Online Photo Album with PHP and ...
- Creating An Online Photo Album with PHP and ...
- PhpED 3.2 More Features Than You Can Poke ...
- Creating An Online Photo Album with PHP and ...
- Creating An Online Photo Album with PHP and ...
- Security and Sessions in PHP
- Setup Your Personal Reminder System Using PHP
- Create a IP-Country Database Using PERL and ...
- Developing a Dynamic Document Search in PHP ...

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 

Developer Shed Affiliates


© 2003-2019 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials