"Steven Hentschel" <[EMAIL PROTECTED]> wrote: > Can anyone tell me why the following behaviour occurs. There is no change to > the contents of tables_priv after adding the table grant to some_user before > and after the database restart. The database has been upgraded from 3.23 to > 4.1.1 and the > mysql_fix_privilege_tables script has been run. > > # mysql -u root -p > Enter password: > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 2 to server version: 4.1.1-alpha-standard > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> use mysql; > Reading table information for completion of table and column names > You can turn off this feature to get a quicker startup with -A > > Database changed > mysql> show grants for [EMAIL PROTECTED]; > +--------------------------------------------------------------------------- > ---------------------------------------------------------------------+ > | Grants for [EMAIL PROTECTED] > | > +--------------------------------------------------------------------------- > ---------------------------------------------------------------------+ > | GRANT CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO > 'some_user'@'localhost' IDENTIFIED BY PASSWORD > '*43933BDF3E95B05EC8BE52E6AEE83DB1B1E309CA' | > | GRANT SELECT ON `some_db`.* TO 'some_user'@'localhost' > | > +--------------------------------------------------------------------------- > ---------------------------------------------------------------------+ > 2 rows in set (0.00 sec) > > mysql> grant all on some_db.some_table to 'some_user'@'localhost'; > Query OK, 0 rows affected (0.00 sec) > > mysql> show grants for [EMAIL PROTECTED]; > +--------------------------------------------------------------------------- > --+ > | Grants for [EMAIL PROTECTED] > | > +--------------------------------------------------------------------------- > --+ > | GRANT CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO > 'some_user'@'localhost' | > | GRANT SELECT ON `some_db`.* TO 'some_user'@'localhost' > | > | GRANT ALL PRIVILEGES ON `some_db`.`some_table` TO 'some_user'@'localhost' > | > +--------------------------------------------------------------------------- > --+ > 3 rows in set (0.00 sec) > > mysql> exit > Bye > # /etc/init.d/mysql restart > Killing mysqld with pid 4103 > Wait for mysqld to exit\c > 040127 12:33:04 mysqld ended > > done > # Starting mysqld daemon with databases from /var/lib/mysql > > # mysql -u root -p > Enter password: > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 1 to server version: 4.1.1-alpha-standard > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> show grants for [EMAIL PROTECTED]; > +--------------------------------------------------------------------------- > ---------------------------------------------------------------------+ > | Grants for [EMAIL PROTECTED] > | > +--------------------------------------------------------------------------- > ---------------------------------------------------------------------+ > | GRANT CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO > 'some_user'@'localhost' IDENTIFIED BY PASSWORD > '*43933BDF3E95B05EC8BE52E6AEE83DB1B1E309CA' | > | GRANT SELECT ON `some_db`.* TO 'some_user'@'localhost' > | > +--------------------------------------------------------------------------- > ---------------------------------------------------------------------+ > 2 rows in set (0.00 sec)
Thank you for bug report. Entered to the MySQL bug database as: http://bugs.mysql.com/bug.php?id=2546 > -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]