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

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

Re: repeated, many-character write queries hang the server

2003-03-07 Thread Mark M. Ito
Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.49, for redhat-linux-gnu on i386 System: Linux claspc14.jlab.org 2.4.18-3 #1 Thu Apr 18 07:37:53 EDT 2002 i686 unknown Architecture: i686 -- Mark -- Mark M. Ito, Thomas Jefferson National Accelerator Facility 12000 Jefferson Ave., Mail Stop 12H

replication planning, concepts

2002-02-11 Thread Mark M. Ito
of the current binary log? In the CHANGE MASTER TO command, what is the interpretation of the value of MASTER_LOG_POS? I. e., how does one know what number to provide here? Any help would be appreciated. -- Mark -- Mark M. Ito, Thomas Jefferson National Accelerator Facility 12000 Jefferson Ave., Mail Stop

replication planning, concepts

2002-02-07 Thread Mark M. Ito
of the current binary log? In the CHANGE MASTER TO command, what is the interpretation of the value of MASTER_LOG_POS? I. e., how does one know what number to provide here? Any help would be appreciated. -- Mark -- Mark M. Ito, Thomas Jefferson National Accelerator Facility 12000 Jefferson Ave., Mail Stop