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 192.168.0.50.
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.
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."
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."