title: MySQL user DB does not have password columns - Installing MySQL on OSX
body: <p>I am trying to change MySql root password.</p>
  
  <p>What I have done is below.</p>
  
  <ol>
  <li>Install MySql-5.7.6 ~ .dmg(Community Server) and workbench.</li>
  <li>Turn off the server on OSX System preferences.</li>
  <li>Access MySql with console. The command was <code>mysqld_safe --skip-grant</code></li>
  <li>Execute <code>update user set password=password('1111') where user='root';</code> and got an error message --> <code>ERROR 1054 (42S22): Unknown column 'password' in 'field list'</code>.</li>
  </ol>
  
  <p>FYI, I did <code>use mysql;</code>.
  So I did select query on user table and found password column actually does not exist. </p>
  
  <p>It is very weird. Is it possible that original user table does not have password column?</p>
  
  <p>How can I change password, which does not exist?</p>
  
  <p>Thanks for your answer :D</p>