ensure that MySQL workbench is installed in the same machine as Power BI Desktop. You can now simply click the connection in the MySQL WorkBench dashboard to open the SSH tunnel and connect to the remote database. Before you can connect to a MySQL database, you need to install MySQL. If you are connecting to your hostname you may see a certificate warning that you'll need to accept. Password: Click the Store in Keychain (Mac) or Store in Vault (PC) button and enter your MySQL user's password.Īll other settings should remain as shown in the screenshot.Ĭlick Test Connection to confirm the settings are correct. SSH Password: Click the Store in Keychain (Mac) or Store in Vault (PC) button and enter your cPanel password. Now you can see a fresh page on the screen as below, then you can authorize the connecting computer in the Remote MySQL section by filling the mentioned IP. SSH Username: This is your cPanel username.
Name the connection (CData SQL Gateway for Google. SSH Hostname: This can usually be your domain name or your Home Server name followed by 722 which is the SSH port number. Connect to Google Drive through the SQL Gateway In MySQL Workbench, click to add a new MySQL connection. This is a brief guide to connecting to MySQL using an SSH Tunnel within the MySQL WorkBench application provided by the MySQL website - external link opens in a new window.Ĭreate a new connection within MySQL WordBench using the following details:Ĭonnection Name: Enter a name to identify this connection.Ĭonnection Method: Select Standard TCP/IP over SSH. Connecting from MySQL Workbench Stored Connection Enter a name for the connection, such as MyDB.
#CONNECT TO MYSQL DATABASE WORKBENCH ON MY COMPUTER HOW TO#
How to connect to MySQL using MySQL WorkBench