1 message in com.mysql.lists.win32Grant syntax
FromSent OnAttachments
Bekkers, Kris18 May 2004 12:34 
Subject:Grant syntax
From:Bekkers, Kris (Kris@atosorigin.com)
Date:05/18/2004 12:34:39 PM
List:com.mysql.lists.win32

All,

I did not find in the manual if following is possible:

Grant usage on *.* to 'userX'@'hostY' identified by old_password("some_pass")

I know that I can update the mysql.user table to use the old_password syntax update mysql.user set password = old_password("some_pass") where user = "useX"
and host = "HostY"

Is my guess correct that the first syntax is incorrect (or not usable)

thx

Kris

for the list: mysql **************************************************************************** Disclaimer: This electronic transmission and any files attached to it are strictly confidential and intended solely for the addressee. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. If you have received this transmission in error, please notify the sender by return and delete the transmission. Although the sender endeavors to maintain a computer virus free network, the sender does not warrant that this transmission is virus-free and will not be liable for any damages resulting from any virus transmitted. Thank You. ****************************************************************************