Wordpress | Command Line Cheatsheet

wordpress-command-line-cheatsheet.txt

#Create database
create database [database name];

#Grant permissions and create users
grant select, update, insert, create, delete on [database].* to [user];

#Set password for user
set password for [user] = password('');

#Flush Privileges
flush privileges

#Update database defined URLS
update wp_options set option_value = "[url]" WHERE option_name = "home";
update wp_options set option_value = "[url]" WHERE option_name = "siteurl";

#Set blog public from commandline:
update wp_options set option_value = "1" WHERE option_name = "blog_public";

#Sweep for URLS in content
UPDATE wp_posts SET post_content = REPLACE(post_content,'find','replace');
UPDATE wp_posts SET guid = REPLACE(guid,'find','replace');

#Generic Meta Sweep - use with caution can screw up serialized data
UPDATE wp_postmeta SET meta_value = REPLACE(meta_value,'','');

#Options Sweep
UPDATE wp_options SET option_value = REPLACE(option_value,'find','replace');

#DBMAP in cPanel
/usr/local/cpanel/bin/setupdbmap

#Sweep File Permissions
find . -type d -exec chmod 755 {} \;
find . -type f -exec chmod 644 {} \;