Tejas, (01)
It appears the error is caused by the version of MySQL installed on the box.
5.0.86 is installed on oor-01f but according bioportal installation doc, it
required 5.1.(trigger is not supported in 5.0) (02)
Let me know if i can re-install MySQL now.( will blow up all DB) (03)
Thanks,
___
Shinya (04)
On Mon, Nov 2, 2009 at 12:26 PM, Tejas Parikh <tejas@xxxxxxxxxxxxxxx> wrote:
> I am trying to install BioPortal using the instructions emailed by Natasha.
>
> I am getting MySQL error when executing following command. User
> bioportal_prd was created in MySQL and has ALL access to BioPortal
> databases.
>
> grant SUPER, TRIGGER on *.* to 'bioportal_prd'@'localhost'
>
> MySQL error is:
>
> mysql> grant SUPER, TRIGGER on *.* to 'bioportal_prd'@'localhost';
> ERROR 1064 (42000): You have an error in your SQL syntax; check the
> manual that corresponds to your MySQL server version for the right
> syntax to use near 'TRIGGER on *.* to 'bioportal_prd'@'localhost'' at
> line 1
>
>
> Thanks,
> --Tejas
>
> _________________________________________________________________
> Message Archives: http://ontolog.cim3.net/forum/oor-dev/
> Config/Unsubscribe: http://ontolog.cim3.net/mailman/listinfo/oor-dev/
> Shared Files: http://ontolog.cim3.net/file/work/OOR/dev/
> Wiki: http://ontolog.cim3.net/cgi-bin/wiki.pl?OpenOntologyRepository
> (05)
_________________________________________________________________
Message Archives: http://ontolog.cim3.net/forum/oor-dev/
Config/Unsubscribe: http://ontolog.cim3.net/mailman/listinfo/oor-dev/
Shared Files: http://ontolog.cim3.net/file/work/OOR/dev/
Wiki: http://ontolog.cim3.net/cgi-bin/wiki.pl?OpenOntologyRepository (06)
|