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);