execute denied error

[Dormilich]

Hi,

has anyone an idea, how I can get over this access denied error?

#1370 - execute command denied to user 'kulturbeutel-lei'@'localhost ' for routine 'kulturbeutel2. set_visits'

CREATE DEFINER=`kulturbeutel-lei`@`localhost` PROCEDURE set_visits(
		IN  par_ip   VARCHAR(40),
		IN  par_type VARCHAR(10)
	)
BEGIN
		CALL count_timeout_ip(@num, par_ip, par_type);
		IF
			@num = 0
		THEN
			CALL new_ip_timeout(par_ip, par_type);
			UPDATE
				`myphpgb_statistic`
			SET
				`visits` = `visits`+1
			WHERE
				`date` = CURDATE();
		END IF;
END

thanks

[Atli]

Hi.

Perhaps an obvious question, but does this user have the permission to use the EXECUTE command on this database?

Try:
[code=mysql]GRANT EXECUTE
ON kulturbeutel2.*
TO 'kulturbeutel-lei'@'localhost ';[/code]
This would have to be executed as root.

[Dormilich]

I'll try that.

EDIT: that seems to have done the trick, thanks Atli.

[sunkadam]

Hi Atli,

I'm facing the same prob. But i'm not able to access as root. How can i do that?

thanks

[Dormilich]

if it's is not your own host/database, ask your provider to do it for you.

[sunkadam]

yes, i am the admin. but i'm still having the "no privileges" error if i run the command on phpmyadmin

[Dormilich]

there must definitely be a root account (otherwise it would have been nearly impossible to set up the database in the first place)

[sunkadam]

i myself set up the databases. and added new users with password. and assigned them the databases.

[Dormilich]

yup, and the default user (before you set up any other) is root.

[Atli]

Only users with the EXECUTE permission can call procedures, and only root-like users can grant other users that permission.

If you can't login as root via your GUI program, have you tried just using the CLI on the server computer?
I always prefer doing admin tasks via the command line anyways. Feels a lot safer, somehow.