List:General Discussion« Previous MessageNext Message »
From:agd85 Date:June 5 2011 9:05pm
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_instanc...
View as plain text  
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  
	                                                                
	       |
	+----------------------------------------------------------------------------------------------------------------------------------------+

and,

 mysql>  show grants for 'drupal_admin'@'localhost';
	+------------------------------------------------------------------------------------------------------------------------------------------------------------------+
	| Grants for drupal_admin@localhost                             
	                                                                
	                                 |
	+------------------------------------------------------------------------------------------------------------------------------------------------------------------+
	| GRANT USAGE ON *.* TO 'drupal_admin'@'localhost' IDENTIFIED BY
	PASSWORD '*D...D'                                               
	                                 |
	| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX,
	ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON `drupal6`.* TO
	'drupal_admin'@'localhost'              |
	+------------------------------------------------------------------------------------------------------------------------------------------------------------------+
	17 rows in set (0.00 sec)

are these sufficient?  these permissions worked fine as far as i could
tell for the v5.1.x install i had.

> and have you started "ymsql_upgrade" after all updates?

yes, i'd already executed 'mysql_upgrade', following the instructions
here:
 http://dev.mysql.com/doc/refman/5.5/en/upgrading-from-previous-series.html

checking,

 mysql_upgrade
  Looking for 'mysql' as: mysql
  Looking for 'mysqlcheck' as: mysqlcheck
  This installation of MySQL is already upgraded to 5.5.12, use --force
  if you still need to run mysql_upgrade

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