Skip to content

Instantly share code, notes, and snippets.

cd /etc/yum.repos.d/ && wget https://letsencrypt-for-cpanel.com/static/letsencrypt.repo
SELECT * FROM `newprefix_usermeta` WHERE `meta_key` LIKE '%wp_%'
SELECT * FROM `newprefix_options` WHERE `option_name` LIKE '%wp_%'
RENAME table 'wp_blogs' TO 'newprefix_blogs' ;
RENAME table 'wp_blog-versions' TO 'newprefix_blog_versions' ;
RENAME table 'wp_registration_log' TO 'newprefix_registration_log' ;
RENAME table 'wp_site' TO 'newprefix_site' ;
RENAME table 'wp_sitemeta' TO 'newprefix_sitemeta' ;
RENAME table `wp_commentmeta` TO `newprefix_commentmeta`;
RENAME table `wp_comments` TO `newprefix_comments`;
RENAME table `wp_links` TO `newprefix_links`;
RENAME table `wp_options` TO `newprefix_options`;
RENAME table `wp_postmeta` TO `newprefix_postmeta`;
RENAME table `wp_posts` TO `newprefix_posts`;
RENAME table `wp_terms` TO `newprefix_terms`;
RENAME table `wp_term_relationships` TO `newprefix_term_relationships`;
RENAME table `wp_term_taxonomy` TO `newprefix_term_taxonomy`;
RENAME table `wp_usermeta` TO `newprefix_usermeta`;
RENAME table `wp_tablename` TO `newprefix_tablename`;
$table_prefix = 'wp_';
add_filter('site_url', 'wplogin_filter', 10, 3);
function wplogin_filter( $url, $path, $orig_scheme )
{
$old = array( "/(wp-login\.php)/");
$new = array( "myprivatelogin");
return preg_replace( $old, $new, $url, 1);
}
@jennimckinnon
jennimckinnon / .htaccess
Created August 5, 2016 01:11
Create new slug for the WordPress login page. By Leighton Sapir.
RewriteBase /
RewriteRule ^myprivatelogin$ wp-login.php
RewriteEngine On
RewriteBase /
RewriteRule ^index\.php$ - [L]