For SSH Password, enter the password you use for your SSH user.For SSH Username, enter the username you use to log into the server via SSH.If your server accepts SSH connections on a different port, enter the IP address, followed by a colon and port number. For SSH Hostname, enter your MySQL server’s IP address.Change the Connection Method to Standard TCP/IP over SSH.This might be something like database_for_myapp or something more descriptive. For Connection Name, enter any name you’d like that helps you identify the connection you’re making later.To create the connection, enter the following details: You’ll be presented with the Connect to Database window, which looks like the follwing figure: Create a new connection by clicking the + icon next to MySQL Connections in the main window. Once you’ve installed MySQL Workbench on your computer, launch the program. The username and password for the MySQL account you wish to use.Ĭonnecting to the Database Server With SSH.A user account with SSH access to the server, with a password or public key.The server’s SSH Port if configured differently than port 22.The public IP address of the server running MySQL.You will also need the following information about the database server you plan to use: Visit the MySQL Workbench Downloads page to download the installer for your operating system. MySQL Workbench installed on your local machine, which is available for all major platforms, including Windows, macOS, Ubuntu Linux, RedHat Linux, and Fedora.For example, you can follow the tutorial How To Install MySQL on Ubuntu 14.04 to get up and running quickly.
A server running MySQL that is accessible via SSH.To complete this tutorial, you will need: This brief tutorial will show you how to connect to a remote database using MySQL Workbench. Using tools like HeidiSQL for Windows, Sequel Pro for macOS, or the cross-platform MySQL Workbench, you can connect securely to your database over SSH, bypassing those cumbersome and potentially insecure steps. And allowing connections to MySQL directly can be a security concern. But connecting remotely to your database server usually entails configuring MySQL to listen on every interface, restricting access to port 3306 with your firewall, and configuring user and host permissions for authentication. Querying this data graphically on your local computer is the easiest way to interact with your database. In the Password text box, type your A2 Hosting (cPanel) account password.Your database server contains tables full of important data. Confirm that the MySQL Server Port text box is set to 3306.In the MySQL Hostname text box, type localhost.In the SSH Username text box, type your A2 Hosting (cPanel) account username.In the SSH Hostname text box, type :7822, where represents your domain name.In the Connection Method list box, select Standard (TCP/IP) over SSH.MySQL Workbench enables you to connect securely to your MySQL databases using an SSH tunnel. You can now run queries, create tables, and more. To open the connection, click it on the workspace page.MySQL Workbench saves the new connection on the workspace page. If you do not receive this message, check the values you specified in steps 4 to 9, and then try again. If the connection is successful, you receive a Successfully made the MySQL connection message.If you receive a connection warning about incompatible or nonstandard server versions, click Continue Anyway. Alternatively, you can leave this text box blank to select the database later.Ĭlick Test Connection, and then in the Password text box, type the password for the username you specified in step 7. In the Default Schema text box, type the name of the MySQL database that you want to access.A MySQL database username you created in cPanel: With this username, you can access all of the MySQL databases for which the specified user has been granted privileges.Your A2 Hosting (cPanel) account username: With this username, you can access all of the MySQL databases on your hosting account.In the Username text box, type one of the following usernames:.Confirm that the Port text box is set to 3306.On the Parameters tab, in the Hostname text box, type, where represents your domain name.In the Connection Method list box, select Standard (TCP/IP).In the Connection Name text box, type a name for the connection.From the workspace page, click the + icon next to MySQL Connections.To configure a direct connection to MySQL, follow these steps: SSH connection: This method uses SSH to establish a secure connection from your computer to the MySQL server.For information about how to do this, please see this article. Before you can establish this type of connection, you must enable remote MySQL access for your IP address.
0 kommentar(er)
