From: Reindl Harald Date: June 5 2011 9:19pm 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/225166 Message-Id: <4DEBF2CE.9090700@thelounge.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enigFE75633F14656D9378F3457C" --------------enigFE75633F14656D9378F3457C Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable the grant statements does nobody interest maybe use phpmyadmin for a clearer display mysql> select * from mysql.user where user=3D'root' limit 1; +-----------+------+-------------------------------------------+---------= ----+-------------+-------------+-------------+-------------+-----------+= -------------+---------------+--------------+-----------+------------+---= --------------+------------+------------+--------------+------------+----= -------------------+------------------+--------------+-----------------+-= -----------------+------------------+----------------+-------------------= --+--------------------+------------------+------------+--------------+--= ----------------------+----------+------------+-------------+------------= --+---------------+-------------+-----------------+----------------------= +--------+-----------------------+ | Host | User | Password | Select_p= riv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Pro= cess_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | C= reate_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Sh= ow_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | Event_priv | Trigger_priv | Creat= e_tablespace_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connecti= ons | 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: >=20 > hi, >=20 > On Sun, 05 Jun 2011 22:24 +0200, "Reindl Harald" > wrote: >> have you checked you permissions-table if all privileges are active fo= r root >=20 > i've got, >=20 > mysql> show grants for 'root'@'localhost'; > +---------------------------------------------------------------------= -------------------------------------------------------------------+ > | Grants for root@localhost =20 > =20 > | > +---------------------------------------------------------------------= -------------------------------------------------------------------+ > | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED > BY PASSWORD '*3...4' WITH GRANT OPTION =20 > | > | GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION =20 > =20 > | > +---------------------------------------------------------------------= -------------------------------------------------------------------+ --------------enigFE75633F14656D9378F3457C 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/ iEYEARECAAYFAk3r8s4ACgkQhmBjz394Anm3OwCfeqyAlGhSi7zFDAqDwRBByhns 6ngAoJ1qY5K/RfOEoB7ee/poK1XiKAa/ =GO0E -----END PGP SIGNATURE----- --------------enigFE75633F14656D9378F3457C--