Ervin Hegedüs wrote: > 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!
To avoid that use getpass.getpass() instead of raw_input(). http://docs.python.org/2/library/getpass.html -- https://mail.python.org/mailman/listinfo/python-list