I’ve created stored procedures on a (remote hosted – DreamHost) MySQL Database using the HeidiSQL client.
One problem i seem to have is that viewing/editing the content of stored procedures is only possible when connecting from the same “host”.
For example, i connect primarily from home, via a BT connection (I’m a BT customer)
But when i try connecting in from work (a different provider/ISP) i can do everything, run queries, edit tables etc, but cannot edit/view the Views/Stored Procedure queries despite connecting with the same username.
I’m assuming the “@”) may be something to do with it?
Is there anyway i can prevent this from being a problem?
You may check grants for user and see if it differs for hosts.
In addition to
show grants for username@host
You may check grants for specific databases:
use dbname; show grants for username;
Also, there are few more places to check for extensive list of privileges:
SELECT * FROM FROM INFORMATION_SCHEMA.USER_PRIVILEGES WHERE GRANTEE LIKE '%userame%'; SELECT * FROM FROM INFORMATION_SCHEMA.TABLE_PRIVILEGES WHERE GRANTEE LIKE '%userame%'; SELECT * FROM FROM INFORMATION_SCHEMA.SCHEMA_PRIVILEGES WHERE GRANTEE LIKE '%userame%';
Most likely INFORMATION_SCHEMA.USER_PRIVILEGES will shed a light on your issue.