Install LAMP server on Ubuntu 16.10

Using following steps we can intall Apache , MySQL and PHP on Ubuntu 16.10 system. 1. First install Apache server Open Terminal and write following command

Find duplicate records in MySQL

SELECT * FROM `tablename` group by field_title having count(`id`) > 1

Exclude result from MySQL query using multiple ID’s

//set parameter in mysql query $query = “SELECT * FROM category WHERE published=1 and id not in (’11’,’22’,’33’)”; //execute the query $result = mysql_query($query);

How to disable WordPress plugin from database?

You can disable all WordPress plugin at once from a single MySQL query. This will be faster to disable all plugins through command line. You need to disable plugins if you want upgrade the WordPress site. Following MySQL command will helpful for you. UPDATE wp_options SET option_value = ” WHERE option_name = ‘active_plugins’; Above command

How to change WordPress theme directly from database?

Sometime you want to change WordPress theme without login in site backend. For example If you upgrade wordpress site and after complete upgradation of site you found that site is stop working. You may see just a blank page instead of newly updated site. This situation may happen if your old theme not support the