title: mysql> create database test; ERROR 1006 (HY000): Can't create database 'test' (errno: 2)
body: <p>I can't create a database after logging in mysql under my root account. Do I have to make an admin account to do so? Also, for some reason, my StartUp file didn't install (there was an error). I'm not sure if that will affect anything else since mySQL DOES start up when I type "mysql" into my terminal. </p>
  
  <p>Also when I type in </p>
  
  <pre><code>mysql&gt; SELECT Host, User FROM mysql.user;
  +---------------------+------+
  | Host                | User |
  +---------------------+------+
  | 127.0.0.1           | root |
  | ::1                 | root |
  | myname-mac.att.net  |      |
  | myname-mac.att.net  | root |
  | localhost           |      |
  | localhost           | root |
  +---------------------+------+
  </code></pre>
  
  <p>Which I don't get. I seem to have multiple root users and I don't know what ::1 means.</p>
  
  <p>EDIT: My databases currently look like this.</p>
  
  <pre><code>mysql&gt; SHOW DATABASES;
  +--------------------+
  | Database           |
  +--------------------+
  | information_schema |
  +--------------------+
  1 row in set (0.02 sec)
  </code></pre>
  
  <p>And it doesn't matter what I type in as my database name. I even tried calling it 'apple'. </p>