ikuseiGmbH/Goldencobra

View on GitHub
lib/generators/goldencobra/templates/create_database.mysql.erb

Summary

Maintainability
Test Coverage
USE mysql;
CREATE DATABASE IF NOT EXISTS <%= db_name %>;
DELETE FROM user WHERE User = '<%= db_username %>';
INSERT INTO user (Host, User, Password, Select_priv) VALUES
   ('localhost', '<%= db_username %>', password('<%= db_password %>'), 'Y');
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON <%= db_name %>.* TO <%= db_username %>@localhost;
FLUSH PRIVILEGES;