 
 
   # backupDatabase : (options,callback)->
-  # 
+  #
   #   #
   #   # this method will create backup of mysql database to the /Users/<username>/Backups/
   #   #
-  # 
+  #
   #   #
   #   # options =
   #   #   username : String # Kodingen username
   #   #   dbName   : String # database name
   #   #   dbUser   : String # database username
   #   #   dbPass   : String # database name
-  # 
+  #
   #   {username,dbName,dbUser,dbPass} = options
-  # 
+  #
   #   d = new Date()
   #   timeStamp = "#{d.getFullYear()}-#{d.getMonth()+1}-#{d.getDay()}-#{d.getHours()}-#{d.getMinutes()}-#{d.getSeconds()}"
   #   @checkBackupDir options,(error,backupDir)=>


    # -------------------------------
    # SECURITY/SANITY FEATURE - NEVER REMOVE
    #  
    unless dbUser.substr(0,username.length+1) is username+"_"
      return callback new KodingError "You can only change password of a database user that you own."
    # -------------------------------
    
    # update user set password=PASSWORD("NEW-PASSWORD-HERE") where User='tom'
    sql = "USE mysql; update user set password=PASSWORD('#{newPassword}') where User='#{dbUser}'; flush privileges"
    @mysqlClient.query sql,(err)=>



  # checkBackupDir : (options,callback)->
  #
  #   #
  #   # this method will check backupDir
  #   # if doesn't exists  - create it
  #   #
  #
  #   #
  #   # options =
  #   #   username : String # Kodingen username
  #   #   dbName   : String # database name
  #   #   dbUser   : String # database username
  #   #   dbPass   : String # database name
  #
  #   {username,dbName} = options
  #
  #   # first check /Users/<username>/Backups/mysql/<dbName>
  #   backupDir = path.join @config.usersPath,username,@config.backupDir,dbName
  #   fs.stat backupDir,(err,stats)->
