WordPress MySql Statement To Delete All Pending Comments

I have over 1800+ pending comments and most of them are spams in WordPress based blog. How do I delete all (mass delete) the pending comments using sql statements?   You can delete all pending…

HowTo: Reinstall MySQL v5.x On Linux

M y MySQL database installation has been corrupted. I would like to delete old mysql server. How do I reinstall MySQL database server version 5.x on Linux or Unix-like oses? A software upgrade broke my…

HowTo: Uninstall MySQL Server in Ubuntu Linux

I ‘m a new Ubuntu Linux user and my cloud hosting company installed MySQL server by default. I need to remove it and delete it from my server as I have no use of MySQL…

CentOS and RHEL 7: Install Linux, Apache, MariaDB, PHP (LAMP) Stack

I am new Red Hat Enterprise Linux version 7 user/sysadmin/developer. This version made the big number change for RHEL 7/CentOS 7. How can I install LAMP (Linux, Apache, MariaDB, PHP) stack on a RHEL version…

Install LEMP (Linux, Nginx, MySQL and PHP) Stack on Ubuntu Linux 14.04 LTS

I ‘m a new Ubuntu Linux user. How do I install the LEMP stack on an Ubuntu Linux 14.04 LTS server using command line options to serve dynamic web apps?   As one of the…

Check The Number Of MySQL Open Database Connections on Linux Or Unix-like Server

I ‘m a new MySQL server user. My server is running on a CentOS Linux. How can I check the number of active MySQL connections on Linux based system?   You can use the following…

How To Install Apache, MySQL, PHP stack on FreeBSD Unix Server

I ‘m a new FreeBSD Unix system users. How can I setup and install Apache, MySQL, PHP stack on a FreeBSD 10 based Unix server?   FAMP stack is nothing but group of source software…

How To Install MariaDB Databases on a FreeBSD v10/11 Unix Server

I ‘m a new FreeBSD unix user. How can I install MariaDB database server on a FreeBSD unix based system?   MySQL is a very fast, multi-threaded, multi-user and robust SQL database server. The latest…

How To Setup a LAMP Server on Debian Linux 8 (Jessie)

H ow can I setup up a LAMP (Linux, Apache, MySql, PHP) stack on Debian Linux version 8 (Jessie) using command line options?   Setting up a LAMP stack on your Debian 8 server will…

How to install mysql server 5.7 on Ubuntu 16.04 LTS ( Xenial Xerus )

M ySQL is a popular database management system used for my web applications. How do I install MySQL server version 5.7 on Ubuntu Linux 16.04 LTS ( Xenial Xerus )?   This tutorial will introduce…