Victoria, > Thank you for bug reports, both bugs are fixed.
That's fast :-)) What about the LOCAL bug (or feature)? I.e. you can start mysqld --local-infile=1, or you can start MySQL Monitor like mysql --local-infile=1, or even both, and it won't help. You cannot use load data LOCAL. Furthermore, client tools report that the option local-infile is unrecognized, but the manual says it's a valid option: "For the mysql command-line client, LOAD DATA LOCAL can be enabled by specifying the option -- local-infile[=1], or disabled with --local-infile=0." Well, here's the output: c:\mysql\bin>mysql --local-infile=1 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 4.0.7-gamma-max-nt-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> USE test; Database changed mysql> LOAD DATA LOCAL INFILE 'f:/import.txt' INTO TABLE t; ERROR 1148: Das used Kommando ist mit dieser MySQL Version nicht erlaubt Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, January 13, 2003 2:55 PM Subject: re: Re: MySQL 4.0.7-gamma: Bugs affecting the privilege system > On Wednesday 08 January 2003 22:32, Stefan Hinz iConnect \(Berlin\) wrote: > > > > Have you tried to reproduce them? > > > > Bug #1: GRANT USAGE doesn't seem to create a user: > > > > mysql> GRANT USAGE ON *.* TO 'foo'@'foohost'; > > Query OK, 0 rows affected (0.26 sec) > > > > mysql> SHOW GRANTS FOR 'foo'@'foohost'; > > Empty set (0.03 sec) > > > > mysql> SELECT Host, User, Password FROM mysql.user WHERE User = 'foo'; > > +---------+------+----------+ > > > > | Host | User | Password | > > > > +---------+------+----------+ > > > > | foohost | foo | | > > > > +---------+------+----------+ > > 1 row in set (0.04 sec) > > > Bug #2: SHOW GRANTS shows wrong GRANT statement: > > > > mysql> GRANT USAGE ON `footable`.* TO 'foo'@'foohost' IDENTIFIED BY > > 'foobar' > > -> WITH GRANT OPTION; > > Query OK, 0 rows affected (0.03 sec) > > > > mysql> SHOW GRANTS FOR 'foo'@'foohost'; > > +----------------------------------------------------------------------- > > ---- > > > > | Grants for foo@foohost > > > > +----------------------------------------------------------------------- > > ---- > > > > | GRANT USAGE ON *.* TO 'foo'@'foohost' IDENTIFIED BY PASSWORD > > > > '4655c05b05f1 > > > > | GRANT ON `footable`.* TO 'foo'@'foohost' WITH GRANT OPTION > > > > +----------------------------------------------------------------------- > > ---- > > 2 rows in set (0.00 sec) > > > > Yes, I can confirm both bugs you encountered. My settings: > > > > Server version: 4.0.7-gamma-max-nt-log > > OS: Win2K SP2 > > > > Maybe worth mentioning, a database 'footable' doesn't exist on my > > machine. Double-checking this, I found out it doesn't matter if a > > database exists or not. Bug #2 happens with database 'test', too. > > > > Regards, > > Thank you for bug reports, both bugs are fixed. > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Victoria Reznichenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com > > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php