Create DB Tables

From UFP-UV Sakai Wiki

Jump to: navigation, search
CREATE DATABASE EASUV DEFAULT character SET utf8;
GRANT ALL ON EASUV.* TO sakaiuser@'localhost' IDENTIFIED BY 'a_password';
GRANT ALL ON EASUV.* TO sakaiuser@'127.0.0.1' IDENTIFIED BY 'a_password';
GRANT ALL ON EASUV.* TO sakaiuser@'10.11.2.38' IDENTIFIED BY 'a_password';
 
CREATE DATABASE GEPUV DEFAULT character SET utf8;
GRANT ALL ON GEPUV.* TO sakaiuser@'localhost' IDENTIFIED BY 'a_password';
GRANT ALL ON GEPUV.* TO sakaiuser@'127.0.0.1' IDENTIFIED BY 'a_password';
GRANT ALL ON GEPUV.* TO sakaiuser@'10.11.2.38' IDENTIFIED BY 'a_password';
GRANT ALL ON GEPUV.* TO sakaiuser@'10.11.4.14' IDENTIFIED BY 'a_password';
 
CREATE DATABASE SISUV DEFAULT character SET utf8;
GRANT ALL ON SISUV.* TO sakaiuser@'localhost' IDENTIFIED BY 'a_password';
GRANT ALL ON SISUV.* TO sakaiuser@'127.0.0.1' IDENTIFIED BY 'a_password';
GRANT ALL ON SISUV.* TO sakaiuser@'10.11.2.38' IDENTIFIED BY 'a_password';
GRANT ALL ON SISUV.* TO sakaiuser@'10.11.4.14' IDENTIFIED BY 'a_password';
 
CREATE DATABASE sakai_preproduction DEFAULT character SET utf8;
GRANT ALL ON sakai_preproduction.* TO sakaiuser@'localhost' IDENTIFIED BY 'a_password';
GRANT ALL ON sakai_preproduction.* TO sakaiuser@'127.0.0.1' IDENTIFIED BY 'a_password';
GRANT ALL ON sakai_preproduction.* TO sakaiuser@'10.11.2.38' IDENTIFIED BY 'a_password';
Personal tools