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';
FLUSH PRIVILEGES;



Last edited Aug 23, 2013 at 11:04 AM by CodeDriller, version 2

Comments

No comments yet.