When you first launch it you will need to create a new connection. Step 1ĭownload Sequel Pro and install it. Connect to Database with Sequel Proīelow is an example of how to connect to your database directly using Sequel Pro. Password: SFTP/SSH password from MyKinstaĬlick Open and it should prompt you to trust the host and add the key to your registry.Username: SFTP/SSH username from MyKinsta.SSH Host: SFTP/SSH Host IP Address from MyKinsta.Then use the following information on the SSH tunnel tab. You will then need to download Plink.exe (PuTTY Link, a command-line connection tool) and specify the location under the Advanced tab in HeidiSQL. Password: Database password from MyKinsta.When you first launch it you will need to create a new session file using the following information. Connect to Database with HeidiSQLīelow is an example of how to connect to your database directly using HeidiSQL. After successfully connecting, you’ll see the SQL interface below which lets you query your remote database directly. You’ll be prompted for your database password, so be sure to have that handy. This command binds your local port 3307 to port 3306 on the remote server containing your database and performs the necessary port forwarding.Ĭopy mysqlsh -host=127.0.0.1 -port=3307 -u kinstalife -p -sql Be sure to replace “ssh_username”, “ssh_host”, and “ssh_port” with your site’s settings. In macOS, launch Terminal and run the command below. To connect to your database via SSH tunnel, you’ll need a few key pieces of information from your site’s Info tab in MyKinsta. This allows you to use local database administration tools like MySQL Shell to make changes to a MySQL database in a secure fashion. If you prefer to work exclusively in the command line, you can connect to your Kinsta database directly via an SSH tunnel. This information can be found in MyKinsta under WordPress Sites > sitename > Info.Ĭredentials for setting up SSH tunneling can be found in MyKinsta. In the connection methods shown below, you’ll need to gather SSH and database information for your site from MyKinsta. Viewing your database in phpMyAdmin.įor more information about using phpMyAdmin, refer to the official phpMyAdmin documentation. Once you’re logged in to phpMyAdmin, you can view your database tables, run queries, drop tables, import data, export your WordPress database, and more. Open phpMyAdmin from MyKinsta.Įnter your database username and password on the phpMyAdmin login page. To access the login page click the Open phpMyAdmin link. Scroll down to the Database access section, and you’ll find your database username and password, which you’ll need to log in to phpMyAdmin. To access phpMyAdmin and manage your WordPress database, log in to MyKinsta and navigate to WordPress Sites > sitename > Info. phpMyAdmin is a popular free application for managing MySQL databases. Kinsta provides quick access to phpMyAdmin on all hosting plans. If you are not comfortable doing this, please check with a developer first. Editing and manipulating tables directly with any of the methods outlined below could break your site if not done correctly.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |