MySQL: Difference between revisions

From RadiWiki
Jump to navigation Jump to search
Line 7: Line 7:


== Configuration ==
== Configuration ==
A detailed description of the configuration of an ODBC connection to a [[Customer database]] is explained on the [[ODBC Customer database]] page. However some MySQL specific ODBC connection parameters are needed, which are:
A detailed description of the configuration of an ODBC connection to a [[Customer database]] is explained on the [[ODBC Customer database]] page. However some MySQL specific ODBC connection parameters are needed to correctly configure the MySQL ODBC connection.
 
At least the following configuration items are necessary for every MySQL connection. Your MySQL database administrator will be able to provide you with the correct values, after which they can be configured in the {{WindowTitle|MySQL Connector/ODBC Data Source Configuration}}
* server name
* server name
* server connection port (by default: 3306)
* username
* username
* password
* password
* database name
* database name
Your MySQL database administrator will be able to provide you with the correct details.
 
[[File:Mysqlconnectorodbc.png]]
 
{{ScreenElementDescription|Data Source Name|An unique name that uniquely identifies the Data Source from the other available Data Sources.}}
{{ScreenElementDescription|Description|Any additional information regarding the Data Source}}
{{ScreenElementDescription|TCP/IP Server|The name (or IP address) of the MySQL server, to which a connection should be made}}
{{ScreenElementDescription|Port|The port-number to which the which the connection should be made. By default this is port-number 3306}}
{{ScreenElementDescription|User|The name of the MySQL user that should be used to connect to the MySQL Server}}
{{ScreenElementDescription|Password|The password of the MySQL user that should be used to connect to the MySQL Server}}
{{ScreenElementDescription|Database|The name of the MySQL database that should be connected to}}
{{ScreenElementDescription|Test|Will perform a connection test to the specified MySQL server and Database}}
{{ScreenElementDescription|Details >>|Will show additional configuration details for the MySQL connection. Your MySQL database administrator can help you with setting this details.}}


== Links ==
== Links ==

Revision as of 11:21, 25 November 2010

A MySQL database can be used as a Customer database in RadiMation®. Using your company MySQL database, will simplify the selection of the customer address information into the RadiMation® EUT window.

We have tested this functionality with a MySQL version 5.0 (5.0.51b to be exact) Community server. Any newer version of the MySQL server should not give any problems.

Requirements

To enable the communication between RadiMation and the MySQL database, it is necessary that the MySQL Connector/ODBC is installed. We advise you to install the version 5.1 or higher of the MySQL Connector/ODBC. The MySQL Connector software package can be downloaded from the MySQL website (see the links below).

Configuration

A detailed description of the configuration of an ODBC connection to a Customer database is explained on the ODBC Customer database page. However some MySQL specific ODBC connection parameters are needed to correctly configure the MySQL ODBC connection.

At least the following configuration items are necessary for every MySQL connection. Your MySQL database administrator will be able to provide you with the correct values, after which they can be configured in the MySQL Connector/ODBC Data Source Configuration

  • server name
  • username
  • password
  • database name

Mysqlconnectorodbc.png

ScreenElementDescription.svg Data Source Name An unique name that uniquely identifies the Data Source from the other available Data Sources.
ScreenElementDescription.svg Description Any additional information regarding the Data Source
ScreenElementDescription.svg TCP/IP Server The name (or IP address) of the MySQL server, to which a connection should be made
ScreenElementDescription.svg Port The port-number to which the which the connection should be made. By default this is port-number 3306
ScreenElementDescription.svg User The name of the MySQL user that should be used to connect to the MySQL Server
ScreenElementDescription.svg Password The password of the MySQL user that should be used to connect to the MySQL Server
ScreenElementDescription.svg Database The name of the MySQL database that should be connected to
ScreenElementDescription.svg Test Will perform a connection test to the specified MySQL server and Database
ScreenElementDescription.svg Details >> Will show additional configuration details for the MySQL connection. Your MySQL database administrator can help you with setting this details.

Links

Retrieved from "https://wiki.radimation.com/wiki/index.php?title=MySQL&oldid=11040"