def _setup_database(sql_password): ''' Configure database for rsyslog ''' mysqlUtils.drop_user('rsyslogd') mysqlUtils.create_user('rsyslogd', sql_password, 'Syslog', 'INSERT') mysql_exec("\. {0}".format(get_create_db_path()), True, escape=False)
def create_user(username, password, database, privileges = "ALL PRIVILEGES"): ''' Create a user and give it "resular" privileges. ''' mysql_exec("GRANT {0} ON {1}.* TO".format(privileges, database) + "'{0}'@'127.0.0.1' IDENTIFIED BY '{1}', ".format(username, password) + "'{0}'@'localhost' IDENTIFIED BY '{1}' ".format(username, password), True )
def create_user(username, password, database, privileges="ALL PRIVILEGES"): ''' Create a user and give it "resular" privileges. ''' mysql_exec( "GRANT {0} ON {1}.* TO".format(privileges, database) + "'{0}'@'127.0.0.1' IDENTIFIED BY '{1}', ".format(username, password) + "'{0}'@'localhost' IDENTIFIED BY '{1}' ".format(username, password), True)
def drop_user(username): ''' Drop a user and its privileges. ''' mysql_exec('DELETE FROM mysql.user where user="******";'.format(username), True) mysql_exec('DELETE FROM mysql.db where db="{0}";'.format(username), True) mysql_exec('flush privileges', True)
def mysql_result(query): # Send query to mysql and get back a result. result = mysql_exec(query, True).strip() # Create row based result in a list. result = result.split("\n") # Remove column names result.pop(0) # Parse out the columns. result_list = [] for row in result: result_list.append(row.split("\t")) return result_list