Re: SQL syntax near 'IDENTIFIED BY'...

2001-08-28 Thread Grigory Bakunov
Date |Tue, 28 Aug 2001 15:14:54 +0500 >From |Alexander Barkov <[EMAIL PROTECTED]> Hello! AB> Hello! AB> These query produces an SQL syntax error AB> in 3.23.29a-gamma: AB> GRANT ALL PRIVILEGES ON databases.* AB> TO 'foo'@'localhost' IDENTIFIED BY 'bar'; AB> SHOW TABLES FROM databases; AB

SQL syntax near 'IDENTIFIED BY'...

2001-08-28 Thread Alexander Barkov
Hello! These query produces an SQL syntax error in 3.23.29a-gamma: GRANT ALL PRIVILEGES ON databases.* TO 'foo'@'localhost' IDENTIFIED BY 'bar'; SHOW TABLES FROM databases; Probably this is because of "databases" is a keyword. However, mysqladmin does allow to create database 'database