def main(): """Main.""" os.system('/etc/init.d/mysql start') username, password = _test_mysql_conn() db_connect_creds.write_creds(username, password) dbconn = MySQLdb.connect('localhost', user=username, passwd=password) dbcurr = dbconn.cursor() create_db(dbcurr, INFERNAL_DB, username, password) dbconn.close()
def main(): """Main.""" os.system("/etc/init.d/mysql start") username, password = _test_mysql_conn() db_connect_creds.write_creds(username, password) dbconn = MySQLdb.connect("localhost", user=username, passwd=password) dbcurr = dbconn.cursor() create_db = "CREATE DATABASE IF NOT EXISTS %s" % INFERNAL_DB logging.debug(create_db) dbcurr.execute(create_db) grant_all = "GRANT ALL ON %s.* TO '%s'@'localhost'" % (INFERNAL_DB, username) if password != "": grant_all = "%s IDENTIFIED BY '%s'" % (grant_all, password) logging.debug(grant_all) dbcurr.execute(grant_all) dbconn.close()
def main(): """Main.""" os.system('/etc/init.d/mysql start') username, password = _test_mysql_conn() db_connect_creds.write_creds(username, password) dbconn = MySQLdb.connect('localhost', user=username, passwd=password) dbcurr = dbconn.cursor() create_db = 'CREATE DATABASE IF NOT EXISTS %s' % INFERNAL_DB logging.debug(create_db) dbcurr.execute(create_db) grant_all = "GRANT ALL ON %s.* TO '%s'@'localhost'" % (INFERNAL_DB, username) if password != '': grant_all = "%s IDENTIFIED BY '%s'" % (grant_all, password) logging.debug(grant_all) dbcurr.execute(grant_all) dbconn.close()