piątek, 2 maja 2014

enter anonymous password in mysql connection python

#!/usr/bin/python

import MySQLdb
import getpass

print "---====DB CONNECT====---"

user = raw_input("Enter username: ")
password = getpass.getpass("Enter password: ")
"""password = raw_input("Enter password: ")"""

try:
    db = MySQLdb.connect("localhost",user,password,"mysql")
    if db:
        print "connected"
        cursor = db.cursor()
        cursor.execute("Select version()")
        data = cursor.fetchone()
        print "db version: %s " %data
        db.close()
    else:
        print "error"
       
except MySQLdb.Error, e:
    try:
        print "MySQL Error [%d]: %s" % (e.args[0], e.args[1])
    except IndexError:
        print "MySQL Error: %s" % str(e)

Brak komentarzy:

Prześlij komentarz