Fixing wp_termmeta doesn’t exist error
zam One day, I open my email via mail command and see bunch of error mail received by me, written something like this: Upon diving in Google ocean, I found this…
mysql
Update MySQL root password
To change your MySQL root password, first you need to connect to the sql server via terminal mysql -u root -p In my case, my root password is null/empty. So…
Install/Upgrade to MySQL 5.6 on Ubuntu 12.04 LTS
First, you need to get MySQL installers from https://dev.mysql.com/downloads/mysql/#downloads I ran following command to get MySQL 5.6.14(32bit): wget -O mysql-5.6.14.deb https://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.14-debian6.0-i686.deb/from/http://cdn.mysql.com/ Install dependency sudo apt-get install libaio1 Then install Mysql…
Check MySQL db size
If you want to find how much your database size in MySQL, you can run this command in mysql console: If you want the output in MB’s: mysql> SELECT table_schema…
Installing Nginx, MySQL & PHP5 (PHP5-FPM) on Ubuntu 12.04 LTS
Installing Nginx, MySQL & PHP5 (And PHP5-FPM) a.k.a (LEMP) On Ubuntu 12.04 LTS 1. Update & upgrade your OS first; apt-get updateapt-get upgrade Install Myssql & PHP5-FPM; apt-get install mysql-server…
Changing MySQL root user Password
Bagi sapa2 yang selalu menggunakan MySQL database, pernah tak jadi kat korang dimana korang terlupa password ‘root’ korang? Haa.. Aku dah terkena dah sekali.. Dan memang sangat tebaik.. Huhu.. Lalai…