Monthly Archives: June 2012

MySQL Secure Installation Set (Change) root password Remove anonymous users Disallow root login remotely Remove test database and access to it Reload privilege tables Start MySQL Secure Installation with following command /usr/bin/mysql_secure_installation Output: NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL SERVERS IN PRODUCTION USE! PLEASE […]

MySQL Secure Installation

For downloading csv files using php. <?php   header("Pragma: public");   header("Expires: 0");   header("Cache-Control: must-revalidate, post-check=0, pre-check=0");   header("Cache-Control: private",false);   header("Content-Type: application/csv");   header("Content-Disposition: attachment; filename=\"output.csv\";" );  readfile("path to output.csv");   ?>

Download as CSV – PHP