On 2013-03-29 9:57 AM, Dotan Cohen wrote:
On Thu, Mar 28, 2013 at 11:15 PM, Peter Brawley
wrote:
Can someone run the server with --skip-grant-tables to retrieve this code?
Possibly, I'll ask. However, it is highly unlikely that such a thing
was done to create the routine.
That's not the poi
On Thu, Mar 28, 2013 at 11:15 PM, Peter Brawley
wrote:
> Can someone run the server with --skip-grant-tables to retrieve this code?
>
Possibly, I'll ask. However, it is highly unlikely that such a thing
was done to create the routine.
--
Dotan Cohen
http://gibberish.co.il
http://what-is-what.c
On Wed, Mar 27, 2013 at 5:46 PM, wrote:
> 2013/03/27 08:01 +0200, Dotan Cohen
> Actually, it is the user that I am logged in as that created the
> function. That is why I find it hard to believe that one needs root /
> admin access to see its definition.
>
> And that user set DE
On 2013-03-28 3:33 PM, Dotan Cohen wrote:
On Wed, Mar 27, 2013 at 5:46 PM, wrote:
2013/03/27 08:01 +0200, Dotan Cohen
Actually, it is the user that I am logged in as that created the
function. That is why I find it hard to believe that one needs root /
admin access to see its definition.
2013/03/27 08:01 +0200, Dotan Cohen
Actually, it is the user that I am logged in as that created the
function. That is why I find it hard to believe that one needs root /
admin access to see its definition.
And that user set DEFINER other than itself, and that worked???
That tak
2013/03/25 11:28 +0200, Dotan Cohen
Thanks. I don't have the admin or root privileges on this database. Is
that the only way to see the code behind the function?
Well, you showed us "DEFINER: admin@localhost" for the function; here is a
snippet from MySQL help about "
SHOW CREAT
On 2013-03-25 4:28 AM, Dotan Cohen wrote:
On Sun, Mar 24, 2013 at 11:08 PM, Peter Brawley
wrote:
Log in as admin@localhost.
Thanks. I don't have the admin or root privileges on this database. Is
that the only way to see the code behind the function?
Ask admin to grant you the required priv.
On Sun, Mar 24, 2013 at 11:08 PM, Peter Brawley
wrote:
> Log in as admin@localhost.
>
Thanks. I don't have the admin or root privileges on this database. Is
that the only way to see the code behind the function?
--
Dotan Cohen
http://gibberish.co.il
http://what-is-what.com
--
MySQL General M
On 2013-03-24 8:25 AM, Dotan Cohen wrote:
A MySQL database is using a stored function avg_sales in some SQL
queries. I am having a hard time finding the code for this function,
in order to track down a bug that I suspect is in the function. Here
is what I get when I try to query MySQL for the fun
