80
edits
Changes
Jump to navigation
Jump to search
Line 62:
Line 62: − + Line 79:
Line 79: − + + + + + + + + +
no edit summary
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 */;
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;