2 messages in com.mysql.lists.javaMysql Prepared Statement Access Denie...
FromSent OnAttachments
manoj08 Jan 2004 01:23 
manoj08 Jan 2004 04:24 
Subject:Mysql Prepared Statement Access Denied error when accessing mysql functions
From:manoj (man@omnesysindia.com)
Date:01/08/2004 01:23:13 AM
List:com.mysql.lists.java

Hi Mark,

When i execute system level function like select last_insert_id(), it returns
access denied error. How do we update the grant table so that mysql level functions can be executed. For example if I make a
call PreparedStatement ps = currentConnection.prepareStatement("SELECT
LAST_INSERT_ID"); connection returns following error. java.sql.SQLException: Syntax error or access violation message from server: "Access denied for user: 'manoj'@'145.137.43.9/255.255.255.0' to database

Thanks in advance, Manoj