Month: February 2020

To reset MySQL password, you need to have root access to the machine. After logging in as root, start by shutting down MySQL: Verify that all mysql processes have been…

To restart X server, you only need to restart gdm. * Stopping GNOME Display Manager… [ ok ]* Starting GNOME Display Manager… [ ok ]

First of all make sure that you have Apache, MySQL (or PostgreSQL), and PHP installed and configured on your system. On Ubuntu, you would type the following to install these…

phpPgAdmin is a web-based administration tool for PostgreSQL written in PHP. It is a very nifty tool with a very convenient GUI interface. If you have used phpMyAdmin for MySQL,…

PHP errors are by default set to go to the apache error log. On Ubuntu, the error log is located at /var/log/apache2/error.log. If you are a PHP developer, it is…

If a default timezone is not set in your php.ini, then you get the following warning: “Warning: strtotime(): It is not safe to rely on the system’s timezone settings. Please…

Excel allows you to write a nested if statements. Following is a typical if statement: To write another condition inside the one returns true:

Sometimes Excel cells contain unwanted data. Removing this data can be a very tedious job. For example, I recently received a data file where the first column cells contained some…

Dependency Injection a big name for a very simple concept. Objects interact with other objects. A piece of data or an object that an object requires is its dependency. Objects…

The filesize limit is not defined in PhpMyAdmin. The limit is taken from php.ini file. To change this limit, you needed to edit your php.ini file: Change the following two…