title: MySQL Root User
body: <p>I was trying to create a very simple MySQL event and realized the action was not running. I then realized that the user I was using did not have super privileges (or any other event-related privileges). I tried granting all privileges to this user via phpMyAdmin but that wasn't working (makes since because I was logged in as that user and not the root user). In fact, I'm not sure if my account has a root user. <strong>How do I find out who the root user is (username and password)?</strong></p>
  
  <p>I'm using a hosting provider that has cpanel and when I look at a list of my mysql users I only see the ones I created. <strong>Is there a way I can find out via phpMyAdmin if I'm logged in as another user?</strong></p>
  
  <p>Also, whenever I create a user in cpanel, I always select the checkbox to grant "all privileges" but I found out just now that super priviledge and a few other privileges are not on the list. As far as I can tell, I won't be able to create any mysql events since I can't grant super privileges to any of my users.</p>
  
  <p><strong>Addition:</strong></p>
  
  <p>When assigning a user to a database, the only privileges I can select from are</p>
  
  <ul>
  <li>ALTER</li>
  <li>ALTER ROUTINE</li>
  <li>CREATE</li>
  <li>CREATE ROUTINE</li>
  <li>CREATE TEMPORARY TABLES</li>
  <li>CREATE VIEW</li>
  <li>DELETE</li>
  <li>DROP</li>
  <li>EXECUTE</li>
  <li>INDEX</li>
  <li>INSERT</li>
  <li>LOCK TABLES</li>
  <li>REFERENCES</li>
  <li>SELECT</li>
  <li>SHOW VIEW</li>
  <li>TRIGGER</li>
  <li>UPDATE</li>
  </ul>
  
  <p>From what everyone is saying in their answers it looks like I'm using a shared database, the event schedule is either turned off and/or I am not allowed to grant users privileges dealing with events. Kind of sucks..</p>
  
  <p>But for now I will use cron jobs.</p>