mysql: grant command denied for user <p>I need help regarding mysql grant command. I need to grant select command on a table to a user which is from different host.</p> <p><code>GRANT SELECT on db.table TO user@xx.xx.xxx AT password</code> (xx.xx.xxx is ip address of other server and user is username at that server)</p> <p>The above statement is giving me error:</p> <blockquote> <h1>1174 - Grant command denied to user</h1> </blockquote> <p>It is working fine in the localhost phpmyadmin. But when I do it in cpanel phpmyadmin it gives error.</p> <p>Thanks</p>