Index: lams_common/db/sql/create_lams_11_db.sql =================================================================== RCS file: /usr/local/cvsroot/lams_common/db/sql/create_lams_11_db.sql,v diff -u -r1.4 -r1.5 --- lams_common/db/sql/create_lams_11_db.sql 27 Mar 2005 14:32:51 -0000 1.4 +++ lams_common/db/sql/create_lams_11_db.sql 14 Mar 2006 06:02:27 -0000 1.5 @@ -9,33 +9,33 @@ CREATE DATABASE lams DEFAULT CHARACTER SET utf8; SET FOREIGN_KEY_CHECKS=1; -USE mysql; +--USE mysql; -DELETE FROM user WHERE user=''; +--DELETE FROM user WHERE user=''; -- DELETE FROM user WHERE user IS NULL; -DELETE FROM db WHERE user=''; +--DELETE FROM db WHERE user=''; -- DELETE FROM db WHERE user IS NULL; -GRANT ALL PRIVILEGES ON *.* TO lams@localhost IDENTIFIED BY 'lamsdemo'; -REVOKE PROCESS,SUPER ON *.* from lams@localhost; +--GRANT ALL PRIVILEGES ON *.* TO lams@localhost IDENTIFIED BY 'lamsdemo'; +--REVOKE PROCESS,SUPER ON *.* from lams@localhost; --The hostname below should be replaced with the actual host name -GRANT ALL PRIVILEGES ON *.* TO lams@'mams-yoichi' IDENTIFIED BY 'lamsdemo'; -REVOKE PROCESS,SUPER ON *.* from lams@'mams-yoichi'; +--GRANT ALL PRIVILEGES ON *.* TO lams@'mams-yoichi' IDENTIFIED BY 'lamsdemo'; +--REVOKE PROCESS,SUPER ON *.* from lams@'mams-yoichi'; -GRANT ALL PRIVILEGES ON *.* TO lams@'%' IDENTIFIED BY 'lamsdemo'; -REVOKE PROCESS,SUPER ON *.* from lams@'%'; +--GRANT ALL PRIVILEGES ON *.* TO lams@'%' IDENTIFIED BY 'lamsdemo'; +--REVOKE PROCESS,SUPER ON *.* from lams@'%'; -FLUSH PRIVILEGES; +--FLUSH PRIVILEGES; -GRANT ALL PRIVILEGES ON lams.* TO lams@localhost IDENTIFIED BY 'lamsdemo' WITH GRANT OPTION; +--GRANT ALL PRIVILEGES ON lams.* TO lams@localhost IDENTIFIED BY 'lamsdemo' WITH GRANT OPTION; --The hostname below should be replaced with the actual host name -GRANT ALL PRIVILEGES ON lams.* TO lams@'mams-yoichi' IDENTIFIED BY 'lamsdemo' WITH GRANT OPTION; -GRANT ALL PRIVILEGES ON lams.* TO lams@'%' IDENTIFIED BY 'lamsdemo' WITH GRANT OPTION; +--GRANT ALL PRIVILEGES ON lams.* TO lams@'mams-yoichi' IDENTIFIED BY 'lamsdemo' WITH GRANT OPTION; +--GRANT ALL PRIVILEGES ON lams.* TO lams@'%' IDENTIFIED BY 'lamsdemo' WITH GRANT OPTION; -FLUSH PRIVILEGES; +--FLUSH PRIVILEGES; +USE lams; - SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file