Using PHP to Export Mysql Data to Excel

  <?php  $DB_Server = “localhost”;    $DB_Username = “put your user name here”;    $DB_Password = “put your password here”;    $DB_DBName = “put your database name here”;    $DB_TBLName = “put your table name here”;       $savename = date(“YmjHis”);  // excel file name $Connect = @mysql_connect($DB_Server, $DB_Username, $DB_Password) or die(“Couldn’t connect.”);    mysql_query(“Set Names ‘utf-8′”);

Change Hostgator MySQL Password

Sometimes we want to change hostgator mysql database user password, or we have to change when we forgot the password. How to do? Very simple infact, first delete the user name of the mysql and remake it, but make sure you use exactly the same name when remaking. then bind the old database name to […]