0 Replies Latest reply on Dec 23, 2005 9:13 AM by Matthew Purdy

    sql script to configure mysql for jboss portal

    Matthew Purdy Newbie

      here is a sql script that will create the database for jboss portal.

      ------------------------------------------------------------------------------

      use mysql;

      drop database if exists jbossportal;
      create database jbossportal;

      delete from db where db='jbossportal';
      delete from user where user='portal';

      insert into db values('%', 'jbossportal', 'portal', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y');
      insert into user values('%', 'portal', password('portalpassword'), 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', '', 0, 0, 0, 0, 0, 0);