Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instance...

[Reindl Harald]

the grant statements does nobody interest
maybe use phpmyadmin for a clearer display

mysql> select * from mysql.user where user='root' limit 1;
+-----------+------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+--------+-----------------------+
| Host      | User | Password                                  | Select_priv | Insert_priv
| Update_priv |
Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv |
File_priv | Grant_priv |
References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv |
Create_tmp_table_priv | Lock_tables_priv |
Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv |
Create_routine_priv |
Alter_routine_priv | Create_user_priv | Event_priv | Trigger_priv | Create_tablespace_priv
| ssl_type | ssl_cipher
| x509_issuer | x509_subject | max_questions | max_updates | max_connections |
max_user_connections | plugin |
authentication_string |
+-----------+------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+--------+-----------------------+
| localhost | root | ********* | Y           | Y           | Y           | Y           | Y
          | Y         |
Y           | Y             | Y            | Y         | Y          | Y               | Y 
        | Y          | Y
           | Y          | Y                     | Y                | Y            | Y     
         | Y
    | Y                | Y              | Y                   | Y                  | Y    
           | Y
| Y            | Y                      |          |            |             |           
  |             0 |
      0 |               0 |                    0 |        |                       |
+-----------+------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+--------+-----------------------+
1 row in set (0.00 sec)



Am 05.06.2011 23:05, schrieb agd85@stripped:
> 
> hi,
> 
> On Sun, 05 Jun 2011 22:24 +0200, "Reindl Harald"
> <h.reindl@stripped> wrote:
>> have you checked you permissions-table if all privileges are active for root
> 
> i've got,
> 
>  mysql>  show grants for 'root'@'localhost';
>
> 	+----------------------------------------------------------------------------------------------------------------------------------------+
> 	| Grants for root@localhost                                     
> 	                                                                
> 	       |
>
> 	+----------------------------------------------------------------------------------------------------------------------------------------+
> 	| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED
> 	BY PASSWORD '*3...4' WITH GRANT OPTION                          
> 	         |
> 	| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION  
> 	                                                                
> 	       |
>
> 	+----------------------------------------------------------------------------------------------------------------------------------------+


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc