Hi,

On Tue, Mar 18, 2008 at 8:49 AM, Malka Cymbalista
<Malki.Cymbalista@weizmann.ac.il> wrote:
> We are currently running MySQL 4.0.15a on a Sun Solaris server. We are moving to a Linux machine running MySQL 5.0.45.
> I am having a problem with permissions in MySQL.
>
> On the current machine running 4.0.15a, when I connect to MySQL as the user super and give the command:
> select lname from hr where fname = "shlomit";
> I get the expected result.
>
> On the new machine running MySQL 5.0.45, when I connect as the user super and give the same command, I get the following error:
> ERROR 1142 (42000): SELECT command denied to user 'super'@'localhost' for table 'hr'
>
> The MySQL permissions are the same on both machines. When I give the following command:
> select * from tables_priv where user="super" and db ="web_positions" and table_name = "hr";
> I get the following result on both machines:
> | Host | Db | User | Table_name | Grantor | Timestamp | Table_priv | Column_priv
> +------+---------------+-------+------------+----------------+---------------------+------------+-------------+
> | % | web_positions | super | hr | root@localhost | 2002-07-21 15:07:17 | Select | |
>
> When I give the following command, I aslo get the same results on both machines:
> select * from user where user ="super";
> The results are N for all the different privileges.
>
> Has anything changed in MySQL 5.0.45 that would cause this behavior?

Probably not. You are probably not logged in as the user you think
you are. Instead of checking privileges by selecting from the mysql
system tables, use SHOW GRANTS to see what your privileges are and who
you're logged in as.