MySQL: Privileges to view Views/Stored Procedure for user Regardless of Host

MySQLmysql-5.6permissionsstored-procedures

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?

Best Answer

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.

Related Question