From: Reindl Harald Date: June 5 2011 9:30pm 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_instances' when using LOCK TABLES". a bug or my config? List-Archive: http://lists.mysql.com/mysql/225169 Message-Id: <4DEBF55B.1090607@thelounge.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig0C3FBD335EF409FD746E78BB" --------------enig0C3FBD335EF409FD746E78BB Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable BTW WHY is everybody ansering to the list AND the author of the last post? this reults in get every message twice :-( 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, >=20 > http://www.directadmin.com/forum/showthread.php?p=3D202053 >=20 > and one >=20 > http://qa.lampcms.com/q122897/Can-t-backup-mysql-table-with-mysqldump-= SELECT-LOCK-TABL-command >=20 > claims a solution >=20 > "Add --skip-add-locks to your mysqldump command" >=20 > which, having added as i mentioned above, to the [mysqldump] section of= > /etc/my.cnf, does NOT make a difference for me. >=20 >=20 > On Sun, 05 Jun 2011 23:19 +0200, "Reindl Harald" > wrote: >> the grant statements does nobody interest >> mysql> select * from mysql.user where user=3D'root' limit 1; >=20 >=20 > and, my result for your cmd, >=20 >=20 > mysql> select * from mysql.user where user=3D'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_pri= v > | 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 = =20 > | Y | Y | Y | Y | Y = > | Y | Y | Y | Y | Y |= > Y | Y | Y | Y | Y |= > Y | Y | Y | Y = =20 > | Y | Y | Y | Y = =20 > | Y | Y | Y | Y = =20 > | Y | | | | = =20 > | 0 | 0 | 0 | = =20 > 0 | | NULL | > +-----------+------+-------------------------------------------+-------= ------+-------------+-------------+-------------+-------------+----------= -+-------------+---------------+--------------+-----------+------------+-= ----------------+------------+------------+--------------+------------+--= ---------------------+------------------+--------------+-----------------= +------------------+------------------+----------------+-----------------= ----+--------------------+------------------+------------+--------------+= ------------------------+----------+------------+-------------+----------= ----+---------------+-------------+-----------------+--------------------= --+--------+-----------------------+ > 1 row in set (0.06 sec) >=20 >=20 --=20 Mit besten Gr=FC=DFen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofm=FChlgasse 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 --------------enig0C3FBD335EF409FD746E78BB Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk3r9VsACgkQhmBjz394AnlX1wCfU7jUkOs8EJ1+TEHW/WWuQ5Qn Bt4AnRbBJWbCniaUjQwJgNiTB8PggiwJ =8SUD -----END PGP SIGNATURE----- --------------enig0C3FBD335EF409FD746E78BB--