DBDesigner 4

 
 
DBDesigner 4 is a free available database design system that integrates database design, modelling, creation and maintenance into a single, seamless environment.

It is written for Microsoft Windows 2k/XP and Linux KDE/Gnome.

DBDesigner 4 is developed and optimized for the MySQL-Database and is made available under the GNU GPL License.

More information about DBDesigner 4 can be found at: http://www.fabforce.net/dbdesigner4/

The latest DBDesigner 4 version can be downloaded from: http://www.fabforce.net/downloads.php







Connect to a database.



Information
none

Operating system used
Windows XP Home Edition Version 5.1 SP 2

Software prerequisites
DBDesigner4

Procedure
  1. Select menu Database | Connect to Database.

    Select menu database

    Select database connection

  2. Press button New Database Connection and enter the following values:

    Connection Name
    Enter a self chosen name name for the connection, for example: mamboDB

    Hostname
    Enter the hostname where the MySQL server is installed, for example: localhost

    Database Name
    Enter the database name you want connect, for example: mambo

    Username and Password
    Enter a username and password of an account who has permission to access the database, for example username=root, password: mysecret

    Database connection editor



  3. Press OK button. The database connection is now defined. In the Select Database Connection window you can now select the defined connection name (for example mamboDB)

    Select database connection 2

  4. Press Connect button. You are now connected to the database, to verify this look at the bottom right of the window.

    Verify database connection