| 37 |
|
|
| 38 |
|
echo "+++ Start up CMS MySQL daemon on port ${MYSQL_PORT} ..." |
| 39 |
|
$MYSQL_ROOT/bin/mysqld_safe --datadir=$MYSQL_PATH --port=$MYSQL_PORT \ |
| 40 |
< |
--socket=$MYSQL_SOCK --log-error=$MYSQL_ERR --pid-file=$MYSQL_PID & |
| 41 |
< |
# --socket=$MYSQL_SOCK --log-error=$MYSQL_ERR --skip-networking --pid-file=$MYSQL_PID & |
| 42 |
< |
sleep 7 |
| 40 |
> |
--socket=$MYSQL_SOCK --log-error=$MYSQL_ERR --skip-networking --pid-file=$MYSQL_PID & |
| 41 |
> |
sleep 10 |
| 42 |
|
|
| 43 |
|
# create CMS MySQL root account |
| 44 |
|
echo "+++ Creating MySQL default root account ..." |
| 45 |
|
$MYSQL_ROOT/bin/mysqladmin --port=$MYSQL_PORT --socket=$MYSQL_SOCK -u root password "cms" |
| 46 |
< |
$MYSQL_ROOT/bin/mysqladmin --port=$MYSQL_PORT --socket=$MYSQL_SOCK -u root -h `hostname` password "cms" |
| 46 |
> |
# $MYSQL_ROOT/bin/mysqladmin --port=$MYSQL_PORT --socket=$MYSQL_SOCK -u root -h `hostname` password "cms" |
| 47 |
|
|
| 48 |
|
# create CMS MySQL DBS account |
| 49 |
|
echo "+++ Creating MySQL default dbs account ..." |
| 50 |
|
$MYSQL_ROOT/bin/mysql --socket=$MYSQL_SOCK -uroot -pcms mysql -e "CREATE USER dbs@localhost IDENTIFIED BY 'cmsdbs'" |
| 51 |
+ |
$MYSQL_ROOT/bin/mysql --socket=$MYSQL_SOCK -uroot -pcms mysql -e "UPDATE user set Select_priv='Y',Insert_priv='Y',Update_priv='Y',Delete_priv='Y',Create_priv='Y',Drop_priv='Y',References_priv='Y',Index_priv='Y',Alter_priv='Y',Create_tmp_table_priv='Y',Lock_tables_priv='Y',Execute_priv='Y',Create_view_priv='Y',Show_view_priv='Y',Create_routine_priv='Y',Alter_routine_priv='Y' where User='dbs';" |
| 52 |
|
fi |
| 53 |
|
|
| 54 |
|
EOF |
