I keep forgetting how to do this. So, I will log it here once and for all: Log into mysql: mysql -u root -p Create a database: create database name_of_database; Create a new user: CREATE USER ‘newuser’@’localhost’ IDENTIFIED BY ‘password’; Give new user all the priviliges: GRANT ALL PRIVILEGES ON * . * TO ‘newuser’@’localhost’;
Month: October 2013
easyengine auto-installer script for Nginx, MySql, PHP and WordPress and Wp-Super Cache
I am a fan of the CentminMod auto installer. This script auto-installs Nginx, PHP, MariaDB, NSD (DNS server) and several other necessities. Also, the author (eva2000) is a very helpful person and answers most questions promptly at WHT. The Centmin Mod script works well and uses very less RAM. This comes very handy at times
Unable to create directory wp-content/uploads/2013/10. Is its parent directory writable by the server?
If you are, like me, fond of frequently shifting your websites from VPS to VPS, using Centos and Ubuntu, alternatively, you will face this problem. Suddenly, when I tried to upload an image to my WordPress site, I got the error: Unable to create directory wp-content/uploads/2013/10. Is its parent directory writable by the server? Well,
WP-PostViews Not Working/ Not Showing Post Count
WP-PostViews, one of the many plugins by the highly talented Lester Chan, is one of my favourite plugins. As the name suggests, it tells you how many times a post has been viewed. You can choose to display that information in the public or you can keep it to yourself. Either way, it is an
MicroNetVPS Review
MicroNetVPS.com had an attractive offer in WHT in which they promised a 50% recurring discount in 6 locations: UK, US, Russia, Turkey, India and Swiss. I have a penchant for discount offers though MicroNetVPS did not inspire much confidence from the look and feel. Anyway, I signed up for the lowest tier in the India
Complete Guide To Setting Up A VPS With WordPress (Centos) (Without Control Panel)
There are few things more satisfying than starting with an empty VPS and filling it with a fully functional WordPress website in just a few moments. The best thing is that we will not be using any Control Panel. This means that we don’t squander away precious RAM that would otherwise be consumed by the