1. IN 4.0.3 I CREATE 3 USERS using 3 different clients and get
slightly different results when I then run
SHOW GRANTS FOR XXX;
The user created by MySQL Front has a slightly different set of
privileges even though the GRANT displayed by MySQL Front appears to be
the same as the one used for the mysql client and MyCC.
I don't think SHOW DATABASES, CREATE TEMPORARY TABLES
and LOCK TABLES are the same as USAGE.
Any ideas?
2. Is the script to update the privileges in 4.0.2/4.0.3 included in the
Windows distribution? I don't seem to find it in
Gordon Bruce
Oh, if you GRANT ALL ON *.* instead of <tablename>.* with MySQL Front
you don't get the
SHOW DATABASES, CREATE TEMPORARY TABLES and LOCK TABLES
privileges.
________________________________________________________________________
___
GRANT ALL PRIVILEGES ON test.* TO 'Front'@'%'
IDENTIFIED BY 'front'
mysql> show grants for Front;
+-----------------------------------------------------------------------
-----------------------------------------------------+
| Grants for Front@% |
+-----------------------------------------------------------------------
-----------------------------------------------------+
| GRANT SHOW DATABASES, CREATE TEMPORARY TABLES,
LOCK TABLES ON *.* TO 'Front'@'%' IDENTIFIED
BY PASSWORD '671fb08f73d32f5a' |
| GRANT ALL PRIVILEGES ON `test`.* TO
'Front'@'%' |
+-----------------------------------------------------------------------
-----------------------------------------------------+
2 rows in set (0.00 sec)
________________________________________________________________________
____
mysql> grant all on test.* to cmd@'%' identified
by 'cmd';
Query OK, 0 rows affected (0.13 sec)
mysql> show grants for cmd;
+-----------------------------------------------------------------------
----+
| Grants for cmd@% |
+-----------------------------------------------------------------------
----+
| GRANT USAGE ON *.* TO 'cmd'@'%'
IDENTIFIED BY PASSWORD '7b49d2fa2263dafa' |
| GRANT ALL PRIVILEGES ON `test`.* TO
'cmd'@'%' |
+-----------------------------------------------------------------------
----+
________________________________________________________________________
____
mysql> show grants for MyCC;
+-----------------------------------------------------------------------
-----+
| Grants for MyCC@% |
+-----------------------------------------------------------------------
-----+
| GRANT USAGE ON *.* TO 'MyCC'@'%'
IDENTIFIED BY PASSWORD '6caf0b02004e14af' |
| GRANT ALL PRIVILEGES ON `test`.* TO
'MyCC'@'%' |
+-----------------------------------------------------------------------
-----+
2 rows in set (0.00 sec)
---------------------------------------------------------------------
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
