title: Lost All Privileges in MYSQL
body: <p>I have seen this same question in many forms on this site and in many other forums.  However, I have tried all the solutions and still have the same outcome.  I'm pretty sure I once had root access on this MySQL server in the past and I was even able to use the phpMyAdmin tool to create databases amongst others queries.  Now when I go to phpMyAdmin and click on databases I am greeted by:</p>
  
  <p><img src="https://i.stack.imgur.com/387UB.png" alt="enter image description here"></p>
  
  <p>If I use the command tool I can login using:</p>
  
  <pre><code>mysql -u root -p
  </code></pre>
  
  <p>I get prompted to enter a password and I do so.  When I try to do anything else, say:</p>
  
  <pre><code>mysql&gt; SELECT user, host FROM mysql.user;
  
  I get the following:
  ERROR 1142 (42000): SELECT command denied to user 'root'@'localhost' for table 'user'
  </code></pre>
  
  <p>I have also followed this article ( <a href="http://benrobb.com/2007/01/15/howto-remote-root-access-to-mysql/" rel="noreferrer">http://benrobb.com/2007/01/15/howto-remote-root-access-to-mysql/</a> ) since yes I am ssh'ing to this MySQL server from a remote machine.  Again, when I attempt:</p>
  
  <pre><code>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
  </code></pre>
  
  <p>In various forms, I am greeted by a nasty:</p>
  
  <pre><code>ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
  </code></pre>
  
  <p>Even though I am putting the same password I used to login!  I also want to mention that I updated my pear resources yesterday and I wonder if this was the cause of this mess...</p>
  
  <p>If anyone can guide me, I'd truly appreciate it.  Thank you for all your time and consideration.</p>
  
  <p>Elshae</p>
  
  <p>****Update****
  In trying to troubleshoot and running mysqld I now cannot start the server back up!  Every time I run:</p>
  
  <pre><code>/etc/init.d/mysql start
  Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
  </code></pre>
  
  <p>What should I do?</p>