Method: DBSetup#create_sql_db_and_perms

Defined in:
lib/DBSetup.rb

#create_sql_db_and_perms(conn_name, su, sup) ⇒ Object 



58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
 
# File 'lib/DBSetup.rb', line 58

def create_sql_db_and_perms(conn_name,su,sup)
	begin
		conn=@conns[conn_name]
		require 'DrbDB/MyMultiSQL/mysql-ruby.rb'
		sql=MySQL.new(conn['sql_host'],su,sup,nil)
		sql.query("drop database if exists `#{conn['sql_db']}`")
		sql.query("create database `#{conn['sql_db']}`")
		begin
			sql.query("create user '#{conn['sql_user']}' identified by '#{conn['sql_password']}'")
		rescue =>e
			einfo("failed to create user '#{conn['sql_user']}':#{e}")
		end
		sql.query("grant all privileges on #{conn['sql_db']}.* to '#{conn['sql_user']}'")
		sql.query("flush privileges")
#			conn['sql_user'],conn['sql_password'],conn['sql_db'])
		sql.close
	rescue => err
		eerror("#{err} #{err.backtrace.join("\n\t")}")
		raise "#{err}"
	end
end