import MySQLdb as mdb
import sys

name = ""
password = ""

conn = mdb.connect('localhost', 'vlad', 'enma1991x', 'test')
cursor = conn.cursor()

print "Please enter your desired username: "
name = raw_input("> ")

print "Please enter your desired password: "
password = raw_input("> ")

try:
    cursor.execute("CREATE TABLE IF NOT EXISTS \
        Users(Id INT PRIMARY KEY AUTO_INCREMENT, Username VARCHAR(25), Password VARCHAR(25))")
    cursor.execute("INSERT INTO Users(Username) VALUES('%s')", [name])
    cursor.execute("INSERT INTO Users(Password) VALUES('%s')", [password])
except mdb.Error, e:
    print "Error %d : %s" % (e.args[0], e.args[1])
    sys.exit(1)

conn.commit()

cursor.close()
conn.close()