80
edits
Changes
From SME Server
Jump to navigationJump to searchno 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;
+
