title: How to create a MySQL user without password - needed for remote login - to be used in bash insert script?
body: <p>My requirement is to create a user for remote login but without a password. At my remote space I use a bash script to do inserts, which is something like:</p>
  
  <pre><code>for i in {1..5000}; do
    mysql -h 11.40.3.169 -uUser -pPass -DDatabaseName &lt;&lt;&lt;
      "insert into DatabaseTableName values('$i','dummy_$i');" &amp;
    echo -n "$i  "
    sleep 1
    date
  done
  </code></pre>
  
  <p>The problem is that each insert is taking almost 4 seconds, and I can not pinpoint the problem to anything but authentication at every insert. So, if I could create a user in MySQL with minimal authentication involved...Something like:</p>
  
  <pre><code># I'm trying to remove this password
  GRANT ALL PRIVILEGES TO 'user'@'%' IDENTIFIED BY 'password';
  </code></pre>
  
  <p>...Anything you can suggest.</p>