NOTES for initially configuring mySQL for use with GridRM
-----------------------------------------------------------------------------------

1. You should be able to copy and paste the lines below.
2. Where you see <ipaddress> please replace with the IP address of the machine
3. Below you will account two user accounts: gridrm and linuxproc.
4. Where you see  PASSWORD('stupid'), please replace stupid with the password
you assign that particular user of the database. Be sure to include the ' '
around the actual password.
4.When copying and pasting, do not copy prompt> or mysql> these are just
pointers to show the command line you are using.

Here we go!:

1.
        prompt> mysql -u root mysql -p
        [you will be prompted for the root password. You will have entered this when you installed and configured the database]

        mysql>  create database GRIDRM

 2. I will be connecting from the localhost using JDBC. This requires that the localhost can access mysql using TCP/IP: An account for a local user must be created:

NOTE: ip address and localhost are specified. This is to get round some strangeness with the mysql JDBC driver

mysql> INSERT INTO user (Host,User,Password)
VALUES('<ip address>','gridrm',PASSWORD('stupid'));

mysql> INSERT INTO user (Host,User,Password)
 VALUES('localhost','gridrm',PASSWORD('stupid'));

mysql> INSERT INTO db
(Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,
Create_priv,Drop_priv)
VALUES
('<ipaddress>','GRIDRM','gridrm','Y','Y','Y','Y','Y','Y');

mysql> INSERT INTO db
(Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,
Create_priv,Drop_priv)
VALUES
('localhost','GRIDRM','gridrm','Y','Y','Y','Y','Y','Y');

mysql> FLUSH PRIVILEGES;

NOTE: The syntax is allowing the localhost to use TCP/IP to the local database.       It does not permit remote machines to connect to the database.


3.

The following database is created to allow a demo to run. It takes data from /proc on the localhost.

        i. Create a mysql database

                 shell> mysql --user=root mysql -p
                 mysql> create database GLUECE_host;

        ii.  Set permissions so that the datasource can populate simple proc data can populate data into the database:


        mysql> INSERT INTO user (Host,User,Password)
        VALUES('<ip address>','linuxproc',PASSWORD('stupid'));

        mysql> INSERT INTO user (Host,User,Password)
        VALUES('localhost','linuxproc',PASSWORD('stupid'));

        mysql> INSERT INTO db
        (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,
        Create_priv,Drop_priv)
        VALUES
        ('<ipaddress>','GLUECE_host','linuxproc','Y','Y','Y','Y','Y','Y');

        mysql> INSERT INTO db
        (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,
        Create_priv,Drop_priv)
        VALUES
        ('localhost','GLUECE_host','linuxproc','Y','Y','Y','Y','Y','Y');

        mysql> FLUSH PRIVILEGES;