Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #62044

Re: Python, mySQL and password

Show all headers | View raw

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

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread

Thread

Re: Python, mySQL and password Peter Otten <__peter__@web.de> - 2013-12-16 12:38 +0100

csiph-web