Run CUBRID Manager on Mac OS X
It is really the great news that CUBRID Manager is now available for Mac users. In this guide you will see how to establish a remote database connection from the CUBRID Manager to the CUBRID Server. The steps are quite easy.
The CUBRID Manager does not depend on anything other than the Java Runtime Environment as it is implemented in Java, the cross platform programming language. So, you basically do not need to perform any preparations. JRE is usually installed on Mac OS X by default.
- The CUBRID Manager
Download the CUBRID Manager for your Mac OS X from http://www.cubrid.org/cubrid_manager.
- The CUBRID Database
You can connect to the CUBRID Database installed on your remote physical machine or on a virtual machine. You can download the latest version of CUBRID from http://www.cubrid.org/downloads. For the Installation Instructions refer to http://www.cubrid.org/tutorials#getting-started.
Install the CUBRID Manager
The CUBRID Manager does not require any installations. It is distributed in an archived file with an extension .tar.gz. What you have to do is to just extract the contents of the archive to the desired location (e.g. Desktop).
Start the CM
Once you extract the CUBRID Manager you will see two directories (/configuration and /plugins) and an executable file (cubridmanager). To start the CUBRID Manager, double click on cubridmanager. You should see the CM's splash screen at this moment.
Once the CM is launched, the main window will look like this.
Add a Host
By default the CM provides the default database host named localhost. You can see on the Hosts panel on the left. You can add any number of hosts you want. For that just right click on Hosts panel and click Add Host... menu.
Alternatively, select the File menu and choose Add Host... from there.
When you choose to add a new host to the CUBRID Manager, a pop-up window will appear.
- Host name: give this host a descriptive name.
- Address: this can be an IP address of a remote physical server or a VM instance within your LAN network. In those cases when you have CUBRID installed on the same machine as the CM (Windows and Linux case), you can enter localhost in this field.
- Port: the port which is specifically opened by your CUBRID Server. The default port for CUBRID is 8001. Sometimes 30000, or 33000.
- User name: the administrator's user name to connect to this host. Do not confuse it with the database user name. They are different. Refer to CUBRID Security Guidelines if you want to learn more about it. Briefly host user name is like root user in MySQL. When you first time connect to a particular host (first time ever), the CUBRID host has a default user name and a password: admin for both. Once you first time login to the host, it will prompt you to change the password.
- JDBC version: normally, you leave this option as Auto Detect. However, if you need to connect to the CUBRID database which has a different version than the CUBRID Manager, they you have to indicate the JDBC driver for that exact CUBRID database.
For example, if your CM has version 3.1 and you want to connect to CUBRID 3.1, you can select Auto Detect or CUBRID-JDBC-8.3.1.0038.
If your CM has version 3.1 and you want to connect to CUBRID 3.0, you have to select CUBRID-JDBC-8.3.0.0337. When you download the CM, it has only one version of the JDBC driver. So, in case you need to connect to another version, download the necessary JDBC driver from JDBC & Java Programming with CUBRID, and place it to the /plugins directory where your CM is located. As you can see in the above image, I have added the second JDBC driver to connect to CUBRID 3.0.
Once you fill out all the fields, press the Add button to add the host, or press the Connect button to add the host and automatically establish the connection.
Connect to a Host
To connect to a host, double click on its name.
Alternatively, right click on the host name and select the Connect Host... menu.
Or you can do the same by selecting File menu and choosing the Connect Host... menu.
The following window should pop up. Press the Connect button.
As mentioned before, when you establish the connection for the very first time, you enter the default admin user name and admin password. After that you will be prompted to change the password. Type the desired password and click OK.
After you change the password it will ask you if you wish to login again with new credentials. Press Yes.
Login to a Database
When you login to a host you will see a list of available databases. By default CUBRID creates a demo database called demodb.
To connect to a demodb database, double click on the database name.
Alternatively right click on the database name and choose Login Database...
Or Action ⇒ Login Database...
A popup window will appear which will prompt to enter the database user name and a password. The demodb database has no password defined for the user dba, so leave it blank.
Start the Database
Once you login to a database, you will see the list of items it contains.
However, when you try to click on the Tables item to view the list of tables the database has, you will not be able to see it, because the database has not been started. In CUBRID, first, you login to a database, then you start it. This is done with the performance in mind. You do not unused databases consume the system resources, so you start the database you will work with. To start the database, right click on the database name and click on the Start Database.
Alternatively, select Action ⇒ Start Database.
Once you start the database, you will be able to see all the tables, view, etc., it has.
Now you can perform all the database operations you need such as SELECT or INSERT queries. The CUBRID Manager has a powerful built-in Query Editor with a syntax highlighter and auto-complete feature. To open the Query Editor, right click on the database name and select New Query menu.
Or, Action ⇒ New Query.
When you launch you will see the Query Editor which is divided into two panels. The upper panel is the query editor, while the lower panel displays the results of the query and also provides the Query Explanation.
Once you start typing your query the Query Editor will show auto-complete options for the current word. Hit ENTER to accept the provided option. Try to execute some queries to get acquainted with the Query Editor.
For your convenience there are a shortcut for SELECT * FROM ... or Select Count(*) queries. If you want to see all the results from a particular table, right click on that table and choose Select All. If you want to see the number of records in that table, right click on the table and choose Select Count(*).
Below is the output for the SELECT * FROM 'game'; query.
The CM comes with the complete CUBRID Manual. To see the manual and learn more about the CUBRID Manager and CUBRID, select Help menu and again Help as shown in the image below.
The CM will open your default Web browser and open the CUBRID Manual page which is located in the /plugins directory.
If you like the PDF version, you can download the same CUBRID Manual from http://www.cubrid.org/documentation.
For other CM related guides see http://www.cubrid.org/cubrid_manager#tutorials.
The complete list of CUBRID Tutorials can be found at http://www.cubrid.org/tutorials.
If you need our administrators' attention, leave your message on CUBRID Manager forum at http://forum.cubrid.org/.
Sometimes we need to import large data files to CUBRID tables which can go over several GB. In this article we will cover different ways to perfo...