openmeeting - mysql deployment

we need to export database

mysqldump -uroot -p –database edxapp > edxapp.sql

import database

mysql -uroot -p –database edxapp < edxapp.sql

or

 mysql> use db_name;
 mysql> source file_name.sql;

it's working

make sure all tables are available otherwise om not working.

datadir /var/lib/mysql/

skip granting from outside

[mysqld]
skip-grant-tables

we now create user for mysql access from the outside, we can specify ip address for the particular user. Then he only can access that ip address.

GRANT ALL ON databasename TO user@192.168.1.10 IDENTIFY BY password;

GRANT ALL ON *.*TO user@192.168.1.10 IDENTIFY BY password;

FLUSH PRIVILEGES;

modify persistence.xml

stop native mysql on om instance

restart om instance

its working