I am trying to install a php package that requires a database where the db user has permission to SELECT, CREATE, UPDATE, INSERT and DELETE. When I use the GoDaddy tool to create the database, the SCHEMA_PRIVILAGES show these all set to NO. Trying to execute the installer script to address this fails:
GRANT ALL on dbUserName.* to 'dbUserName'@'dbUserName.db.#######.hostedresource.com' identified by 'password'
Error Code: 1044
Error Text: Access denied for user 'dbUserName'@'%' to database 'dbUserName'
GoDaddy tech support advised that I needed to recreate the database with direct access enabled, which I did, but get the same results. Then they suggested that I needed to change my hosting plan, which ain't going to happen. Any help on this would be appreciated.