DataBase » History » Version 1
Version 1/8
-
Next ยป -
Current version
Anonymous, 10/01/2007 11:00 AM
Make sure that the MySQL daemon is running, and that it will start at boot time: {{{
/sbin/service mysqld start
/sbin/chkconfig --add mysqld
/sbin/chkconfig mysqld on
}}}
Make sure that you have access to the MySQL database management as ''root'' and login as user ''root ''with the corresponding password:
{{{
mysql -u root -p
}}}
Create new mysql users ''procksi_user ''and ''procksi_admin'':
{{{
USE mysql;
INSERT INTO user SET host='localhost', user='procksi_user', password=PASSWORD;
INSERT INTO user SET host='localhost', user='procksi_admin', password=PASSWORD;
FLUSH PRIVILEGES;
}}}
Repeat these steps analogously for ''procksi0-priv'', ''procksi1-priv'', and ''procksi2-priv.''
Create a new database:
{{{
CREATE DATABASE procksi_latest;
}}}
Give privileges to users ''procksi_user ''and ''procksi_admin'' for all compute nodes:
{{{
GRANT ALL ON procksi_latest.* TO procksi_admin@localhost WITH GRANT OPTION;
GRANT SELECT, UPDATE, INSERT, DELETE ON procksi_latest.* TO procksi_user@localhost;
GRANT ALL ON procksi_latest.* TO procksi_admin@procksi0.cs.nott.ac.uk WITH GRANT OPTION;
GRANT SELECT, UPDATE, INSERT, DELETE ON procksi_latest.* TO procksi_user@procksi0.cs.nott.ac.uk;
GRANT SELECT, UPDATE, INSERT, DELETE ON procksi_latest.* TO procksi_user@procksi1.cs.nott.ac.uk;
GRANT SELECT, UPDATE, INSERT, DELETE ON procksi_latest.* TO procksi_user@procksi2.cs.nott.ac.uk;
FLUSH PRIVILEGES;
}}}
If you change the password for ''procksi_user'', please make sure that you also change it in ''/home/procksi/latest/config/main.ini''
Import the main database ''procksi_latest'' from the backup given in ''/home/procksi/RELEASE/admin'':
{{{
msysql -u procksi_admin -p procksi_latest < procksi_latest.sql
}}}
In order to create a database ''procksi_test'' for the test version, repeat the previous steps and set the privileges accordingly.