CREATE DATABASE onpub CHARACTER SET=latin1 COLLATE=latin1_general_ci;
GRANT ALL ON onpub.* TO 'user'@'localhost' IDENTIFIED BY 'password';