List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:June 5 2011 9:29pm
Subject: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...
View as plain text  
hm - bad

i would use a replication slave and stop him for consistent backups
because dumb locks are not really a good solution independent
if this works "normally"

Am 05.06.2011 23:26, schrieb agd85@stripped:
> fwiw, others are seeing this. e.g., in addition to the two bugs i'd
> already referenced,
> 
>  http://www.directadmin.com/forum/showthread.php?p=202053
> 
> and one
> 
> 
> http://qa.lampcms.com/q122897/Can-t-backup-mysql-table-with-mysqldump-SELECT-LOCK-TABL-command
> 
> claims a solution
> 
>  "Add --skip-add-locks to your mysqldump command"
> 
> which, having added as i mentioned above, to the [mysqldump] section of
> /etc/my.cnf, does NOT make a difference for me.
> 
> 
> On Sun, 05 Jun 2011 23:19 +0200, "Reindl Harald"
> <h.reindl@stripped> wrote:
>> the grant statements does nobody interest
>> mysql> select * from mysql.user where user='root' limit 1;
> 
> 
> and, my result for your cmd,
> 
> 
> 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 | *3......................................4 | 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 |        | NULL                  |
>
> +-----------+------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+--------+-----------------------+
> 1 row in set (0.06 sec)
> 
> 

-- 

Mit besten Grüßen, Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofmühlgasse 17
CTO / software-development / cms-solutions
p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
icq: 154546673, http://www.thelounge.net/

http://www.thelounge.net/signature.asc.what.htm


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
Thread
upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142:SELECT,LOCK TABL command denied to user 'root'@'localhost' for table'cond_instances' when...agd855 Jun
  • 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_instances'...Reindl Harald5 Jun
    • 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_instances' ...agd855 Jun
      • 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_instances'...Reindl Harald5 Jun
        • 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_instances' ...agd855 Jun
          • 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_instances'...Reindl Harald5 Jun
            • 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_instances' ...agd855 Jun
              • 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_instances'...Reindl Harald5 Jun
                • 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_instances' ...agd855 Jun
                  • 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_instances'...Reindl Harald6 Jun
                  • 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_instances...Johan De Meersman6 Jun
                    • 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_instances' ...agd856 Jun
                      • 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_instances...Johan De Meersman6 Jun
                        • 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_instances' ...agd856 Jun
          • 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_instances'...Reindl Harald5 Jun
            • 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_instances' ...agd855 Jun
              • HowTo using mailing-listsReindl Harald5 Jun
                • Re: HowTo using mailing-listsagd855 Jun
                  • Re: HowTo using mailing-listsReindl Harald5 Jun
            • Re: to the list AND the authorhsv6 Jun