Create a MySQL-based DB

Print this Topic  Previous Topic Home Topic Next Topic
You are here: Globodox DB > Create a Globodox DB >Create a MySQL-based DB

MySQL (Version 5) Server must be installed on your machine or another machine on your network for you to be able to create a MySQL Server based Globodox DBs. Please note Globodox supports only version 5 and above.
 

To Create a MySQL based Globodox DB

1.In Globodox, click the Globodox button.
2.Click the New DB button. The New DB window will now be displayed.
3.Select MySQL based Globodox DB option from the DB Type drop down. The MySQL Settings window will now be launched.
4.Enter or select the name of the machine on which MySQL Server is running from the Choose or type in a machine name box. The new Globodox DB would be created on this machine. The drop-down list will display the names of all the machines on your network. You can also type the machine's IP address.
5.Enter the port number in the Port box to connect to the MySQL Server. The default port used by MySQL (port 3306) will be displayed in this box. If the MySQL instance you have chosen uses a different port number then you must enter that port number in this box.
6.In the Username box enter the user name that Globodox should use when connecting to the MySQL Server.
7.In the Password box enter the password that Globodox should use when connecting to the MySQL Server.
8.Check the Remember Password option you want Globodox to remember the user name and password and automatically apply it when the Globodox DB is opened. If this option is left unchecked then the user will be prompted for the user name and password before opening the Globodox DB.
9.Click the Test button to test the connection.
10.Click the OK button to save the settings and close the MySQL Settings window.
11.Enter a name for the DB in the DB Name box.
12.Enter a short description about the DB in the Description box.
13.The default location of the DB's File Store (folder) will be displayed in the File Store Location box. You can change the File Store location by clicking the Browse button besides the File Store Location box. Any documents you add to this Globodox DB will be stored in the File Store.
14.Click the Create button to create the MySQL based Globodox DB.

 

Notes:

Make sure that MyODBC drivers version 5.1.4 or higher is installed on all the machines on which Globodox is installed.
To open a newly created DB, click the Globodox button and select the DB from the DB list.
By default the Databases File Stores are stored in the C:\Globodox Databases folder. File Store is a normal Windows folder which is located inside a folder with the same name as the name of its related DB.
 
More information about MySQL is available at http://www.mysql.org

 


Related Topics

Create a MS Access based DB

Create a MS SQL based DB
Configure Globodox DB for multi-machine environment

 

 


Page URL: https://www.globodox.com/support/help/index.htm?create_my_sql_based_db.htm