Strange behavior, Table Level Permission

[Udbhav Shah]

Dear Victoria Reznichenko,

Thanks for reply.

Could you tell me from where I can get patch to fix
this bug. 
or I have to use Mysql 4.0/Mysql 5.0

with regards,
Udbhav Shah

=

Thinking is the Assets

Enterprise is the Way

Hard Work is the Solution

  - Ignited Minds 

 



__
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Strange behavior, Table Level Permission

[Udbhav Shah]

Hello Everyone,

Using Mysql 4.1.1-alpha release on RH9,
I have used RPM provided on Mysql site to upgrade from
3.23 to 4.1.1

I have a very strange behavior of mysql server,when I
restart my server, it is not reading permission given
to user at Table Level from tables_priv.

Permission are still there, but when I use "show
grants for ..." it show that no privileges.

Commands used:
grant all on try.TBL_MACIP to 'tryAdmin1'@'localhost';
/etc/init.d/mysqld restart

>mysql -utryAdmin1
mysql>use try
access denied
 
Does anyone know how to remove such unexpected
behavior, because this was perfectly working in 3.23

with regards,
Udbhav Shah
India

=

Thinking is the Assets

Enterprise is the Way

Hard Work is the Solution

  - Ignited Minds 

 



__
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problem in setting Table Level Privileges

[Udbhav Shah]

Hi Everybody
Commands:

> mysql -uroot
mysql> grant select,insert,update,delete on
try.TBL_MACIP to 'tryAdmin1'@'localhost';
>mysql -utryAdmin1
mysql> use try
mysql> select * from TBL_MACIP;
>/etc/init.d/mysql restrat
>mysql -utryAdmin1
mysql>use try
ERROR 1044 (42000): Access denied for user:
''@'localhost' to database 'try'

mysql>show grants for 'tryAdmin1'@'localhost';
No privilege is set.

Using 
Server version  4.1.1-alpha-standard
Protocol version10
Connection  Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
OS  i686 GNU/Linux (RH9)

Used RPM to upgrade from 3.23 to 4.1.1

Should I send this problem as BUG?
Any Suggestion/HELP!!!

Thanks in Advance.

with regards
Udbhav Shah
B.E (Computer Engg)
Ahmedabad,Gujarat
India

=

Thinking is the Assets

Enterprise is the Way

Hard Work is the Solution

  - Ignited Minds 

 



__
Do you Yahoo!?
Yahoo! Mail - More reliable, more storage, less spam
http://mail.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]