IDENTIFIED is enered when you CREATE USER.
So when GRANT you do not need to enter IDENTIFIED.
But Again if you had version 2.4.5 running and you are just upgrading
you do NOT need to touche mysql at all.
Regards
Adam
[email protected] pisze:
shouldn't it be IDENTIFIED?
Li
*"Sebastien Bory" <[email protected]>*
Sent by: [email protected]
26.03.2010 08:43
Please respond to
"User questions and discussions about OTRS." <[email protected]>
To
"'User questions and discussions about OTRS.'" <[email protected]>
cc
Subject
Re: [otrs] Upgrade 2.4.5 to 2.4.7 Windows
Dear all
I try this morning to do anothet upgrade (2.4.5 to 2.4.7) but when I
do this command line
C:\Documents and Settings\cmoi>mysql -uroot -e "GRANT all ON otrs.* TO
'otrs'@'localhost' INDENTIFIED BY 'test'" && mysql -uroot -e "FLUSH
PRIVILLEGES"
I have this messages
ERROR 1064 (42000) at line 1: 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 'INDENTIFIED BY 'test'' at line 1
* *
*Sébastien Bory*
Administrateur réseaux*
NCI-les centres d'affaires
Bienvenue chez vous - Just welcome !*
59 Rue des Petits Champs 75001 Paris
Tel 33(0) 1 73 77 53 41
Fax 33(0) 1 73 77 55 56
Port: 33(0) 6 78 93 28 66
Mail :[email protected]_ <mailto:[email protected]>
Web: _www.groupenci.com_ <http://www.groupenci.com/>
cid:[email protected]
/Ce message et toutes les pièces jointes sont établis a l'intention
exclusive de ses destinataires et sont confidentiels. Si vous recevez
ce message par erreur, merci de le détruire et d'en avertir
immédiatement l'expéditeur. Toute utilisation de ce message non
conforme à sa destination, toute diffusion ou toute publication,
totale ou partielle, est interdite, sauf autorisation expresse.
L'internet ne permettant pas d'assurer l'intégrité de ce message, NCI
décline toute responsabilité au titre de ce message, dans l'hypothèse
ou il aurait été modifié. This message and any attachments are
intended solely for the addressees and is confidential. If you receive
this message in error, please delete it and immediately notify the
sender. Any use not in accord with its purpose, any dissemination or
disclosure, either whole or partial, is prohibited except formal
approval. The internet can not guarantee the integrity of this
message. NCI shall not therefore be liable for the message if modified./
*De :* [email protected] [mailto:[email protected]] *De la
part de* Sebastien Bory*
Envoyé :* jeudi 25 mars 2010 16:33*
À :* [email protected]*
Objet :* [otrs] Upgrade 2.4.5 to 2.4.7 Windows
Dear all
Does anyone have a simple procedure to upgrade OTRS 2.4.5 to 2.4.7 on
Windows Server?
I watch the video on YouTube but that not work and I don’t understand
all.
I have poor knowledge about mysql.
Can you help me
Thanks
* *
*Sébastien Bory*
Administrateur réseaux*
NCI-les centres d'affaires
Bienvenue chez vous - Just welcome !*
59 Rue des Petits Champs 75001 Paris
Tel 33(0) 1 73 77 53 41
Fax 33(0) 1 73 77 55 56
Port: 33(0) 6 78 93 28 66
Mail :[email protected]_ <mailto:[email protected]>
Web: _www.groupenci.com_ <http://www.groupenci.com/>
cid:[email protected]
/Ce message et toutes les pièces jointes sont établis a l'intention
exclusive de ses destinataires et sont confidentiels. Si vous recevez
ce message par erreur, merci de le détruire et d'en avertir
immédiatement l'expéditeur. Toute utilisation de ce message non
conforme à sa destination, toute diffusion ou toute publication,
totale ou partielle, est interdite, sauf autorisation expresse.
L'internet ne permettant pas d'assurer l'intégrité de ce message, NCI
décline toute responsabilité au titre de ce message, dans l'hypothèse
ou il aurait été modifié. This message and any attachments are
intended solely for the addressees and is confidential. If you receive
this message in error, please delete it and immediately notify the
sender. Any use not in accord with its purpose, any dissemination or
disclosure, either whole or partial, is prohibited except formal
approval. The internet can not guarantee the integrity of this
message. NCI shall not therefore be liable for the message if modified./
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/
Privileged/Confidential Information may be contained in this message. If you
are not the addressee indicated in this message (or responsible for delivery
of the message to such person), you may not copy or deliver this message to
anyone. In such case, you should destroy this message and kindly notify the
sender by reply email. Please advise immediately if you or your employer
does not consent to email for messages of this kind. Opinions, conclusions
and other information in this message that do not relate to the official
business of the GroupM companies shall be understood as neither given nor
endorsed by it. GroupM companies are a member of WPP plc. For more
information on our business ethical standards and Corporate Responsibility
policies please refer to our website at
http://www.wpp.com/WPP/About/
------------------------------------------------------------------------
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/
