In order to create a new field click below the newly created field and start all over. Once the command is finished you will see your new field in the Columns and Indices window. Click the Execute button and the command should go off smoothly. When you finish filling out the data for the first table click the Apply Changes button which will then bring up a window showing you the MySQL command to be executed. A primary key's Data Type should be Integer.You will want to have one field with a primary key. Once that is done click in the Colun and Indices area and you will then be able to start building the fields for your table.  The first thing you need to do is give your table a name. In order to create a table in your schema you need to click the Create Table button after you have selected the schema you want to work with (see Figure 4). Do this and click OK and you will have an empty schema ready for you to add tables. When you select this a small window will appear asking you to enter a name for your new schema. In order to create a new schema right-click inside of that pane and select Create Schema. ![]() In this pane you will see a listing of your current schemata. When the catalogs listing opens (see Figure 3) take a look at the lower left pane. To open up the catalogs window double click on the Catalogs listing in the left pane. The catalogs window is a listing of your current schemata (database collection). In order to create a new schemata you need to first open up the Catalogs window. This window will immediately give you plenty of information about your MySQL connection as well as all the tools you need to work with MySQL. When the connection is made you will find yourself in the MySQL Administrator main window (see Figure 2). Once you enter the information click the Connect button to establish your connection. So the information you need to enter will be similar to what you see in Figure 1. If you go for a remote login you have to make sure your remote MySQL server will allow for remote connections.įor this article we will focus on a local connection. From this window you can create a local or a remote login. When you first start up the MySQL Administrator tool the login window will appear (see Figure 1). Once installed you will find this tool located in the Programming sub-menu of the Applications menu. You should already have a running MySQL installation, but if you do not the software installer should pick up all of the dependencies. ![]() In this article you will see how to install MySQL Administrator as well as create a schema (aka database) and a table for your database.Īs you would expect, all you need to do is fire up your software installation tool (such as Synaptic or the Ubuntu Software Center), do a search for "mysql administrator", select the results, and install. And MySQL Administrator is available for both Linux and Windows, so even the non-Linux crowd can enjoy this fantastic tool. This tool will work with any MySQL installation >= 4.0 and makes the daunting task of administrating MySQL databases far easier than any other desktop GUI tool.Īnd, to make matters even easier, MySQL Administrator is found in the standard distribution repositories, so installation is a breeze. One of those tools, MySQL Administrator, is actually released by the MySQL developers. ![]() But there are better tools for managing your MySQL databases.
0 Comments
Leave a Reply. |