etc/mysql/bin/createuser

   1 #!/bin/sh -eux
   2 user="$1"
   3 sudo mysql -u mysql --batch <<-EOF || true
   4         DROP   USER '$user'@'localhost';
   5         EOF
   6 sudo mysql -u mysql --batch <<-EOF
   7         CREATE USER '$user'@'localhost' IDENTIFIED WITH auth_socket;
   8         EOF