Shinya & Tejas ... (01)
Given the dependency (as this may come up in future too), may I
suggest that Tejas (rather than Shinya) installs, and maintains mysql
as well, on <oor-01f>. (02)
Is that ok with both of you? (03)
Thanks & regards. =ppy
-- (04)
On Sun, Nov 1, 2009 at 7:58 PM, YAMADA Shinya <shinya@xxxxxxxxxxxxx> wrote:
> Tejas,
>
> 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)
>
> Let me know if i can re-install MySQL now.( will blow up all DB)
>
> Thanks,
> ___
> Shinya (05)
> 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 (06)
_________________________________________________________________
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 (07)
|