Re: order important in grant commands?

2005-04-18 Thread Gleb Paharenko
Hello. I've reported a bug. See: http://bugs.mysql.com/bug.php?id=9952 Mark M. Ito [EMAIL PROTECTED] wrote: Gleb et al., I've tried something else. Fearing that the problem is due to some interaction with an already rather complicated set of privilege tables, I tried

Re: order important in grant commands?

2005-04-15 Thread Gleb Paharenko
for current_user(); Mark M. Ito [EMAIL PROTECTED] wrote: Dear MySQL List, Is order important when issuing grant commands? Linux, Fedora Core 3 MySQL server version: 4.1.11-standard, installed via RPM. perl DBI module installed from CPAN on top of this version. I am trying

Re: order important in grant commands?

2005-04-15 Thread Mark M. Ito
Gleb et al., Gleb Paharenko wrote: I think the grant statements flow order doesn't matter, because according to: http://dev.mysql.com/doc/mysql/en/connection-access.html server sorts the entries of the grant tables before reading them. That is what I thought. Because of the sorting I should

Re: order important in grant commands?

2005-04-15 Thread Mark M. Ito
Gleb et al., I've tried something else. Fearing that the problem is due to some interaction with an already rather complicated set of privilege tables, I tried to reproduce the problem starting from a very simple mysql database. I was indeed able to reproduce the problem, but the order of good

Re: order important in grant commands?

2005-04-15 Thread Gleb Paharenko
Yes, it is a weird behavior for MySQL. If you are able to make a reproducible test case, report a bug. If not, switch to the debug version of MySQL server. The clues could be in the trace files. Mark M. Ito [EMAIL PROTECTED] wrote: Gleb et al., Gleb Paharenko wrote: I think

order important in grant commands?

2005-04-14 Thread Mark M. Ito
Dear MySQL List, Is order important when issuing grant commands? Linux, Fedora Core 3 MySQL server version: 4.1.11-standard, installed via RPM. perl DBI module installed from CPAN on top of this version. I am trying to allow all privileges to a given user to a given database from inside my