mysqluser.rb — no more looking up mysql syntax for adding users…

mysqluser.rb

#!/usr/bin/env ruby
require 'tempfile'
case ARGV[0]
when nil
  abort "usage: mysqluser [add|] <arg(s)>"
when 'add'
  abort "usage: mysqluser add <username> <password>" unless ARGV[2]
  usernames = ["'#{ARGV[1]}'@'localhost'", "'#{ARGV[1]}'@'%'"]
  mysql_commands = []
  usernames.each do |username|
    mysql_commands << "CREATE USER #{username} IDENTIFIED BY '#{ARGV[2]}';"
    mysql_commands << "GRANT ALL PRIVILEGES ON *.* TO #{username} WITH GRANT OPTION;"
  end
  mysql_commands << "FLUSH PRIVILEGES;"
  Tempfile.open('adduser.sql') do |tf|
    File.open(tf.path,'w') do |f|
      mysql_commands.each do |mysql_command|
        f.puts mysql_command
      end
    end
    puts `mysql -p --user=root mysql < #{tf.path}`
  end
end