Python, mySQL and password
Ervin Hegedüs
airween at gmail.com
Mon Dec 16 06:16:41 EST 2013
Hello,
On Mon, Dec 16, 2013 at 02:55:29AM -0800, Igor Korot wrote:
> Hi, ALL,
> Is there a way to make python script that connects to mySQL DB ask for
> a password on the:
>
> conn = mdb.connect(host, user)
>
> line.
> The host variable is "localhost" and the user variable is "root" (for
> developmental purposes).
may be you think some like this:
import MySQLdb
dsn = {
'host': "127.0.0.1",
'user': "root",
'passwd': "",
'port': 3306,
'db': "test"
}
dsn['passwd'] = raw_input("Enter password for %s: " % (dsn['user']))
mysql = MySQLdb.connect(**dsn)
cursor = mysql.cursor(MySQLdb.cursors.DictCursor)
but at this way the password what you type will showing!
a.
More information about the Python-list
mailing list