Changes

From SME Server
Jump to navigationJump to search
172 bytes added ,  22:50, 26 November 2015
no edit summary
Line 62: Line 62:  
   PRIMARY KEY (`number`),
 
   PRIMARY KEY (`number`),
 
   KEY `index` (`number`)
 
   KEY `index` (`number`)
  ) ENGINE=MyISAM AUTO_INCREMENT=47577 DEFAULT CHARSET=latin1;
+
  ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
 
  /*!40101 SET character_set_client = @saved_cs_client */;
 
  /*!40101 SET character_set_client = @saved_cs_client */;
 
  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
 
  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
Line 79: Line 79:     
3. Create the database:
 
3. Create the database:
  #mysqladmin create apache_stats
+
  #mysql  < apache_memory_usage_show_to_database.sql
 +
 
 +
Set the user access :
 +
#mysql
 +
mysql> GRANT ALL PRIVILEGES ON apache_stats.* TO stats@localhost IDENTIFIED BY 'Your Password';
 +
 
 +
mysql> flush privileges;
 +
 
 +
 
     
80

edits

Navigation menu