Important MySQL commands

The following tutorials are example of the essential MySQL commands and techniques needed by system administrators. Although there are people/departments that specializes on Database administration, knowing these commands will help you understand and collaborate effectively with database administrators.
Continue reading “Important MySQL commands”

Additional MySQL Commands

When you forgot the password to your MySQL server, you can reset it using the following steps. This will require a downtime since you are going to stop MySQL service. After this, remember to keep you mysql root password.

Continue reading “Additional MySQL Commands”

Return MySQL query as PHP variable

If you have a PHP built webpage and you need to save the MySQL query as a PHP variable, then you can use the following function.
The MySQL query result should be a single entry and it will be saved on the variable when the function is called.

Continue reading “Return MySQL query as PHP variable”

Install Mongo and MBString PHP module on RedHat

The following steps walks through the installation of mongo and mbstring modules for php. This is helpful when you are required to install specific versions of the modules along with your PHP package.
Installation on CentOS of php-mbstring is straightforward as you just can get the package from the Epel-repo or on the Optional Packages repo.
Continue reading “Install Mongo and MBString PHP module on RedHat”