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> Probably this is because of "databases" is
AB> a keyword. However, mysqladmin does allow to
AB> create database 'databases'.
AB> Is it a bug? Or is that already fixed in
AB> later releases?
AB> "mysqladmin create databases" does not output any
AB> error messages, however it does not create database
AB> "databases".
AB> However, "mysqladmin drop databases" produce this:
AB> /usr/local/mysql/etc/ access.grant > mysqladmin drop databases
AB> Dropping the database is potentially a very bad thing to do.
AB> Any data stored in the database will be destroyed.
AB>
AB> Do you really want to drop the 'databases' database [y/N]
AB> y
AB> mysqladmin: drop of 'databases' failed;
AB> error: 'You have an error in your SQL syntax near 'databases' at line 1'
I'll try to do all what you write.
~| mysqladmin -u root -p create databases
Enter password:
~|
so - create base 'databases' complete.
~| mysqladmin -u root -p drop databases
Enter password:
Dropping the database is potentially a very bad thing to do.
Any data stored in the database will be destroyed.
Do you really want to drop the 'databases' database [y/N] y
Database "databases" dropped
In short words - mysqladmin create and drop databases not through
mysql but directly.
PS: I use 3.23.39 version.
___
For technical support contracts, visit https://order.mysql.com/
This email is sponsored by SWSoft, http://www.asplinux.ru/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft
/_/ /_/\_, /___/\___\_\___/
<___/ 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
