Shinya, (01)
Can you please install mysql 5.1 on oor-01f? I am having trouble
deleting old version of mysql. (02)
Thanks,
--Tejas (03)
On Sun, Nov 1, 2009 at 11:08 PM, Peter Yim <peter.yim@xxxxxxxx> wrote:
> Shinya & Tejas ...
>
> 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>.
>
> Is that ok with both of you?
>
> Thanks & regards. =ppy
> --
>
>
> 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
>
>
>> 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
> (04)
_________________________________________________________________
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)
|