

- #Setup mysql database server on desktop how to#
- #Setup mysql database server on desktop driver#
- #Setup mysql database server on desktop Pc#
Start Tableau and under Connect, select MySQL. Make the connection and set up the data source

#Setup mysql database server on desktop driver#
If the driver is not installed on your computer, Tableau displays a message in the connection dialog box with a link to the Driver Download (Link opens in a new window) page where you can find driver links and installation instructions. You might already have the required driver installed on your computer. This connector requires a driver to talk to the database. Note: For information about requirements and considerations when connecting to data using Prep Builder, see Connect to Data (Link opens in a new window) in the Tableau Prep Help. (Optional) Initial SQL statement to run every time Tableau connects Name of the server that hosts the database you want to connect to Before you beginīefore you begin, gather this connection information: To a MySQL database and set up the data source.
#Setup mysql database server on desktop how to#
Result: After you have confirmed your selection with OK, the selected parameters will be displayed in the editor and can be configured.Ĭlick the Test Database Connection button in order to verify whether the connection to the database can be established with the parameters configured.This article describes how to connect Tableau In order to add further parameters to the configuration of your MySQL database connection, click the Select button and activate the parameters of your choice in the Select Advanced Properties dialog box. Some MySQL tools (such as MySQL Workbench) use the term Schema to refer to the database. The Server Name list contains entries for those servers that are defined under the Database Servers node.Īfter you have selected a MySQL database server as Server Name, the configuration parameters described in this chapter are displayed.Įnter the Database Name of the MySQL database. The element wsDbConnectionName configured in the EcoStruxure Machine Expert SqlRemoteAccess library must have the identical value as the parameter Connection Name.įrom the Server Name list, select the MySQL database server that hosts the MySQL database you want to connect to. Make sure that exactly the value of the parameter Connection Name is used in the client configuration:

In the Configuration tab of the SQL Gateway, right-click the Database Connections node in the tree structure on the left-hand side and execute the command New Database Connection.Įnter a unique Connection Name in order to identify this database connection. For further information, refer to the Troubleshooting chapter. Result: A message is displayed indicating the result of the test. The default value is MYSQL.Ĭlick the Test Server Connection button in order to verify whether the connection to the database server can be established with the parameters configured. The default value is MySQL.ĭefine the Shared Memory Name for accessing the MySQL server. The default value is 3306.ĭefine the Pipe Name for accessing the MySQL server. Select the connection protocol that is used by the MySQL database server:ĭefine the Port for TCP /IP communication. Select the Connection Protocol to access the MySQL database server from the list.
#Setup mysql database server on desktop Pc#
If the MySQL server is running on a different PC, enter the computer name of the remote PC or the IP address.Īs User Name, enter the login name of the MySQL user account to be used for accessing the MySQL database.Įnter the Password of the MySQL user account to be used for accessing the MySQL database. If the MySQL server is running on the same PC as the SQL Gateway, enter localhost or a loopback IP address, such as 127.0.0.1. Result: A new subnode with a default name is created.Įnter a unique Server Name in order to identify this database server.Īfter you have selected My SQL as Server Type, the configuration parameters described in this chapter are displayed.Įnter the Server Address in order to identify the PC on which the database server is running. In the Configuration tab of the SQL Gateway, right-click the Database Servers node in the tree structure on the left-hand side and execute the command New Database Server.
