Thanks for your reply. When I do show grants, I get back

GRANT SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO 'super' @ 'localhost' ( mailto:super'@ 'localhost' ) identified by password.......

So it looks like super doesn't have rights to select from the hr table. But why not? According to the tables_priv table, super should have right to select.

I tried giving the command (as root)
grant select on web_positions.hr to super@localhost identified by .....
I get back
ERROR 2013 (HY000): Lost connection to MySQL server during query

I can give any other command but when I try to give the grant command I keep getting the same error.

Malka Cymbalista
Webmaster, Weizmann Institute of Science
malki.cymbalista@weizmann.ac.il
08-934-3036


>>> On 3/18/2008 at 3:20 PM, in message <4cfa0b030803180620j4696ed57m684003a74023064@mail. gmail.com>, "Baron Schwartz" <baron@xaprb.com> wrote:
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.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=M...weizmann.ac.il