Stored procedure access issue in MySQL

[infinity]

Hi all

I am having a big issue trying to create stored procedures and functions on a hosted MySQL database, there is nothing wrong with the procedures as they are running on my test server (local office) fine, the issue is a connection/permission problem, heres the details as posted to support in ticket #cjk-12995-390, still awaiting resolution...

I create a database using the cPanel called 'xxxx_xxxx, assign a user 'zzzz_zzzz' to the database with all permissions the cPanel will allow.

I create a host using my 'IP address'.

When I connect to the DB using SQLyog using the zzzz_zzzz user and try to create a procedure I get this error:

Error Code : 1044
Access denied for user 'zzzz_zzzz'@'IP address' to database 'xxxx_xxxx'

I have been chasing a resolution to this for weeks now!

Anyone any ideas?

[eUKhost.com]

We added another username to the database and we could successfully connect to your database remotely. Please try from your end as there should not be access denied error if you are using correct username and password.

[infinity]

I think you are missing the issue here. I can connect with my zzzz_zzzz user and create and edit tables no problem but I cannot create or edit stored procedures and functions using either the user I created or the new user you created, I get this error:

Error Code : 1044
Access denied for user 'zzzz_zzzz'@'%' to database 'xxxx_xxxx'

The x's and z's are only to blank out the real database and user names.

I need execution permission on the database I believe to create and edit stored procedures, please, please can you sort this out it has been going on for ages now!

Thanks

[infinity]

Can you try with the user you just created to craete a stored procedure in one of my databases??

Thanks

[eUKhost.com]

I had a word with our senior developers and he said that it has to do with something on the server. There should not be any such error on MySQL 5 as stored procedures are supported on MySQL 5.

I am doing further investigation and looking at MySQL logs to see what exactly is wrong. Please provide me with your stored procedure script in reply to ticket as we would like to try same thing from our end.

[infinity]

I sent the stored procedure to the ticket number #CJK-12995-390

Can you let me know what you find?

Thanks

[eUKhost.com]

Our developers have left for the day so we will need to wait till tomorrow morning. I will get your ticket updated as soon as we sort this problem.

[hijacker]

Hello, what's the status of this mysql stored procedures creation in CPanel problem?

Cheers,
-Nik

[eUKhost.com]

Originally Posted by hijacker

Hello, what's the status of this mysql stored procedures creation in CPanel problem?

Cheers,
-Nik

You will need contact our support team from http://support.eukhost.com for more information on this.