Stored procedure access issue in MySQL
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?
|