lohaonline.blogg.se - Ssh tunnel mysql

Within the SSH Host and SSH User fields, enter in your SSH credentials that you would normally use when connecting over SSH.

Next, fill in the MySQL Host, Username, Password, and Database settings with the settings that you obtained in the previous section of this article.

For your Connection Method, be sure that SSH is selected.

The settings will be the same across most clients, although the UI reflected in the screenshots will vary between MySQL clients. You can use any MySQL client, as long as it has the ability to utilize an SSH tunnel. Note: In this example, we will be using Sequel Pro. You're now ready to continue on with configuring your MySQL client. You now have your MySQL database credentials for your WordPress site.

Be sure to make note of these values as you'll need them later when configuring your MySQL client. Inside the wp-config-hosting.php file, you'll see your database settings as DB_NAME, DB_USER, DB_PASSWORD, and DB_HOST.This can be done using SFTP or by running the following command over SSH:Ĭat ~/sites//wp-config-hosting.php Locate the wp-config-hosting.php file for the site that you want to manage the database on.To configure your MySQL client, you'll need to get your database settings such as host, username, and password. Getting Your WordPress Database Credentials If not, take a look at one of the following articles for more information: Before continuing, be sure that you have already configured SSH access. To use an SSH tunnel, you'll first need to have SSH access.

If you need a GUI interface for database management, you can use SSH tunneling to connect to the database.