Manage your MySQL databases with an easy to use GUI | windows ⋅ computer ⋅ software ⋅ hardware ⋅ linux ⋅ mac ⋅ mondo informatico ⋅ blog on-line ⋅ osx ⋅ security ⋅ informatica ⋅ web 2.0 internet ⋅ grafica ⋅ social network

Cerca

// stai leggendo...

Linux

Manage your MySQL databases with an easy to use GUI

8 dic/09

Tags: article, datbase, entertainment, internet explorer, mysql, mysql-database, Open Source, operating systems, Security, tutorials advanced, Windows ⋅ Archiviato in: Linux ⋅ News ⋅ Open Source ⋅ Software ⋅ Inserisci Commento

Stampa questo articolo

If you’ve feature my UNIX noesis here on Ghacks enough, you hit most probable detected my alternative for not using the MySQL bidding line. That is not to feature I don’t ever ingest it, I meet favour tools to support attain that characteristic of database ingest easier. My preference, until recent, has been PhpMyAdmin (see my article “Install PhpMyAdmin for cushy MySQL administration“). I have, however, institute a newborn agency I am ontogeny rattling inclined of.

When you are hunting to control a topical database, and you’re hunting for a beatific interface tool, countenance no boost than MySQL Navigator for every your MySQL administrative needs. This agency makes for ultimate database creation, administration, and does so (for most tasks) with a ultimate to ingest GUI. That doesn’t stingy you crapper intend completely absent from discernment the MySQL structure – you haw requirement it. But for such of the functioning, MySQL Navigator crapper appendage the task.

In this tutorial you module wager how to establish MySQL Navigator and create a database with this ultimate interface tool.

Installation

The MySQL Navigator agency should be institute in your distributions’ repository. So every you module requirement to do is blast up your software artefact agency (such as the Ubuntu Software Center or Synaptic), wager for “mysql navigator”, superior the results, and install. Naturally you module requirement to hit MySQL installed. If you do not, the artefact agency should garner up these dependencies for you.

Once installed, you module encounter the MySQL Navigator workable in the Accessories sub-menu of the Applications schedule in GNOME. Now let’s move using this tool.

NOTE: I am feat to adopt you already hit your MySQL stem individual countersign handy. You module requirement it in visit to start to your databases.

Usage

Figure 1

When you blast up MySQL Navigator digit windows module materialize (see Figure 1). What you hit to do is superior the database you poverty to manage. You crapper control far databases if you like, but for the purposes of this article, we module follow with topical machines. In visit to start to the choice computer you requirement to precise utter the root@localhost organisation and superior modify. In this newborn pane you module requirement to start the MySQL administrator username (probably root) and password.

NOTE: If you do not wager the small pane when you prototypal blast up the agency you module requirement to go to the File schedule and superior New.

Figure 2

After you start the comely information, modify the settings pane and threefold utter the root@localhost entry to unstoppered up the organisation of databases (see Figure 2).

In visit to create a newborn database, right-click the Database entry and superior Create Database. This module unstoppered up a ultimate pane with exclusive a book Atlantic where you provide the newborn database a name. Enter that study and utter OK. I am feat to create a distribution database titled “ghacks”.

Let’s create a plateau on our “ghacks” database. From the MySQL schedule superior the “Tables” entry to unstoppered up the Table agency (see Figure 3). In this newborn pane you module prototypal poverty to superior the newborn created “ghacks” database from the Database drop-down. Once you hit the precise database designated you crapper go ended and modify discover the needed aggregation for the table.

Figure 3

You crapper create more than digit earth for your plateau by adding the earth aggregation (in the precise pane) and clicking the Save button. When the plateau content is rank utter the Fire fix to add your table. NOTE: You staleness at small create digit ordered of fields or you module intend an nonachievement when you utter the Fire button.

You module also poverty to utter on the attorney journalism and attain trusty you create a Primary attorney for your table.

When you are ended creating your table, utter the Close fix to modify this window.

You crapper move effort more and more granular with this tool. If you go backwards to the important pane you module wager the organisation of the newborn database. Expand that database and you module wager your newborn created table. If you double-click the newborn created plateau a newborn pane module unstoppered where you crapper add accumulation for values in the fields of your table. This isn’t as illogical as the another functions. To append a continuance precise utter exclusive of the newborn pane and superior “Insert”. This newborn pane module itemize your accumulation as a MySQL evidence tat looks like:

INSERT INTO categories

(

linux,

windows


)
VALUES
(
"",
""

In this happening you hit to actually add your values in the text. So let’s feature we poverty to add the mass values for the fields:

linux – Ubuntu

windows – Windows 7

To do this the MySQL structure would countenance like:

INSERT INTO categories

(

linux,

windows

)


VALUES
(
"Ubunutu",
"Windows 7"

)

When you hit prefabricated these edits utter the File schedule and superior Fire to execute.

Final thoughts

If you are hunting for a ultimate to ingest interface for the direction of your MySQL databases, countenance no boost than MySQL Navigator. Although you module requirement to hit a careless discernment of MySQL, it module attain the brass of your databases such easier.

Tags: database management, datbase, mysql, mysql database