Can't create stored proc on remote MySQL 5.0 database
Posted on 2007-07-20
I am having trouble createing a stored procedure on a remote database hosted by my ISP and am getting the following error:
Access denied for user 'ABCDEF'@'%' to database 'test_db'
I can take the following script and run it locally just fine. I'm assuming it's permissions, but the database managment/configuration tool provided by my ISP for setting up MySQL does not allow me to change permissions.
DROP PROCEDURE `R_TEST`;
CREATE PROCEDURE `R_TEST`()
SELECT PLAN_ID FROM 'test_db.PLAN;
I'm new to MySql and this the first time trying to deploy to my hosting provider.