The following SQL script creates apache_logs database in local MySQL Server instance, and ApacheLogToDb user with 11223344 password and with permissions to write to apache_logs database. MySQL Server's default character set and collation is used.

CREATE DATABASE apache_logs;
CREATE USER 'ApacheLogToDb'@'localhost' IDENTIFIED BY '11223344';
GRANT CREATE ON apache_logs.* TO 'ApacheLogToDb'@'localhost';
GRANT INSERT ON apache_logs.* TO 'ApacheLogToDb'@'localhost';

Last edited Aug 23, 2013 at 12:04 PM by CodeDriller, version 2


No comments yet.