title: MySQL: django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'") with correct username and pw
body: <p>I have <code>django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")</code> when using mysql. The username and pw are correct:</p>
  
  <pre><code>DB_HOST = '127.0.0.1'
  DB_USER = 'root'
  DB_PASSWORD = ''
  </code></pre>
  
  <p>I can log into mysql as root:</p>
  
  <pre><code>$ sudo mysql -u root
  Welcome to the MySQL monitor.  Commands end with ; or \g.
  Your MySQL connection id is 16
  </code></pre>
  
  <p>But not as <code>cchilders</code>:</p>
  
  <pre><code>$ mysql -u root
  ERROR 1698 (28000): Access denied for user 'root'@'localhost'
  </code></pre>
  
  <p>This may contribute to the problem. Last time I installed mysql this didn't happen, so it doesn't make sense to me. I have the client fine:</p>
  
  <pre><code>$ pip3 freeze
  Django==1.10.5
  mysqlclient==1.3.9
  </code></pre>
  
  <p>How can I allow mysql to be run by my normal user, so I can run django in the terminal? thank you</p>
  
  <p>Dirty solution:</p>
  
  <p>Without any fixes, always run mysql as <code>sudo</code></p>