Databases
StackOverflow2013
Postsdbo
POmysql forgets who is logged in: command denied to user ''@'%'
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POmysql forgets who is logged in: command denied to user ''@'%'
    primarykey
    data
    text
    <p>Running <code>show grants;</code> indicates that I am logged in as a user with all privileges on a database.</p> <p>Running <code>show table status;</code> results in an error. And the error does not show the username I am logged in as!</p> <p>It's as if, for this command, mysql forgets who I am. Other select statements work fine. Can anyone explain this? How to fix? Thanks.</p> <pre><code>Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.5.13-log Source distribution Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql&gt; show grants; +---------------------------------------------------------------------------------------------------------------------+ | Grants for php@localhost | +---------------------------------------------------------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'php'@'localhost' IDENTIFIED BY PASSWORD '*8F5FF90079BC601F8EA7C148475658E65A0C029D' | | GRANT ALL PRIVILEGES ON `sunflower_work`.* TO 'php'@'localhost' | | GRANT ALL PRIVILEGES ON `news_demo`.* TO 'php'@'localhost' | | GRANT ALL PRIVILEGES ON `news_base`.* TO 'php'@'localhost' | +---------------------------------------------------------------------------------------------------------------------+ 4 rows in set (0.00 sec) mysql&gt; show table status from sunflower_work; ERROR 1143 (42000): SELECT command denied to user ''@'%' for column 'uid' in table 'users' mysql&gt; </code></pre> <p>update... as suggested by Tomalak, I deleted the user and recreated with fuller privileges and no password. Still the problem persists. Now it looks like this:</p> <pre><code>mysql&gt; show grants; +--------------------------------------------------+ | Grants for php@localhost | +--------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'php'@'localhost' | +--------------------------------------------------+ 1 row in set (0.00 sec) mysql&gt; show table status; ERROR 1143 (42000): SELECT command denied to user ''@'%' for column 'uid' in table 'users' mysql&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USDave Cohen
    1. USDave Cohen
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POmysql forgets who is logged in: command denied to user ''@'%'
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POmysql forgets who is logged in: command denied to user ''@'%'
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POmysql forgets who is logged in: command denied to user ''@'%'
      1. USbdonlan
      1. VTFavorite
    1. COThere may be two problems: a faulty error message and misbehaving privileges. To solve the latter issue, can you delete all the `GRANT`s and re-add just the first one, _not_ using `IDENTIFIED BY` (let the actual user record contain the password)? I wonder whether there's a conflict in that list.
      singulars
      1. POmysql forgets who is logged in: command denied to user ''@'%'
      1. USLightness Races in Orbit
    2. CO@tomalak geret'kal: If you google the error message, you'd know that 1143 is a typo -- it's 1142 like the 16+ other questions...
      singulars
      1. POmysql forgets who is logged in: command denied to user ''@'%'
      1. USOMG Ponies
    3. CO@OMGPonies: If you bother to [look it up](http://dev.mysql.com/doc/refman/5.5/en/error-messages-server.html), you'll see that 1142 does not contain column information, whereas 1143 does. Why would the OP have made a typo in a blatantly copy/pasted output?
      singulars
      1. POmysql forgets who is logged in: command denied to user ''@'%'
      1. USLightness Races in Orbit
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload