Kinsta

https://kinsta.com/docs/
Admin
Kinsta is a managed hosting provider offering high-performance WordPress, static site, application,...
Tokens:300,350
Snippets:2,621
Trust Score:10
Update:1 week ago
Show doc for...
Tokens:
Raw
### Create user with WP-CLI example

Source: https://kinsta.com/docs/wordpress-hosting/site-management/wordpress-users

Example WP-CLI command that creates a user with username 'newuser', email 'user@example.com', and role 'administrator'. This is a concrete example of the previous command.

```bash
wp user create newuser user@example.com --role=administrator
```

--------------------------------

### Install libnss3-tools with sudo apt install

Source: https://kinsta.com/docs/devkinsta/devkinsta-troubleshooting/error-codes

Manually installs the necessary certificate management packages on Linux. Combine with the update command to perform both steps in one command.

```bash
sudo apt install libnss3-tools
```

--------------------------------

### Get all pages SQL query

Source: https://kinsta.com/docs/wordpress-hosting/database-management/wordpress-database

Example SQL query to retrieve all pages from the wp_posts table.

```sql
SELECT ID, post_title FROM wp_posts WHERE post_type = 'page';
```

--------------------------------

### Install WordPress with WP-CLI

Source: https://kinsta.com/docs/wordpress-hosting/wordpress-getting-started/manually-installing-wordpress

Runs the WordPress installer. Replace example.com, title, admin user, and admin email with your site's details. Prompts for a strong admin password.

```bash
wp core install --url=example.com --title="Your New WordPress Site" --admin_user=youruser --prompt=admin_password --admin_email=yourname@yourdomain.com
```

--------------------------------

### SSH Tunnel Command Example (kinstalife)

Source: https://kinsta.com/docs/wordpress-hosting/database-management/wordpress-database-access

Example SSH tunnel command using the kinstalife site's actual credentials from the screenshot. Starts the SSH session with the specified host and port.

```bash
ssh -fN kinstalife@35.224.70.159 -p 47780 -L 3307:127.0.0.1:3306
```

--------------------------------

### Set up Git and SSH on Kinsta server

Source: https://kinsta.com/docs/wordpress-hosting/site-management/wordpress-github-cicd

Navigate to the site's live directory, then initialize a Git repository and add the GitHub remote via SSH. Verify the SSH connection with GitHub; a successful response confirms the server is ready for GitHub Actions deployments.

```bash
cd /www/your-site/public
```

```bash
git init
git remote add origin git@github.com:your-username/your-repo.git
```

```bash
ssh -T git@github.com
```

--------------------------------

### Get all approved comments SQL query

Source: https://kinsta.com/docs/wordpress-hosting/database-management/wordpress-database

Example SQL query to retrieve all approved comments from the wp_comments table.

```sql
SELECT comment_ID, comment_author, comment_content FROM wp_comments WHERE comment_approved = 1;
```

--------------------------------

### Navigate into ~/public

Source: https://kinsta.com/docs/wordpress-hosting/site-management/gitlab-ci-cd

Navigates into the ~/public folder to configure the GitLab repository.

```bash
cd ~/public
```

--------------------------------

### Get all published posts SQL query

Source: https://kinsta.com/docs/wordpress-hosting/database-management/wordpress-database

Example SQL query to retrieve all published posts from the wp_posts table.

```sql
SELECT ID, post_title, post_date FROM wp_posts WHERE post_type = 'post' AND post_status = 'publish';
```

--------------------------------

### Navigate to site folder

Source: https://kinsta.com/docs/devkinsta/wp-cli

Go to your site folder.

```bash
cd /www/kinsta/public/siteName
```

--------------------------------

### Group path purge example URLs

Source: https://kinsta.com/docs/wordpress-hosting/kinsta-mu-plugin

Example URLs that would be purged by adding a group path rule for `/custom-post-type/`. The group path purges all URLs starting with that path, useful for custom post types and their child posts.

```url
https://yourdomain.com/custom-post-type/
https://yourdomain.com/custom-post-type/post-1
https://yourdomain.com/custom-post-type/post-2
https://yourdomain.com/custom-post-type/post-3
```
Tokens:
Raw