"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]
