unix command execution with password via python

Question

I am trying to connect to mysql in unix from a python script. I provided the password to connect to mysql in the script itself but terminal still prompts for the password. This is what i have till now:

import os
from subprocess import Popen, PIPE

passwd = "user"
command = "mysql -u root -p"

proc = Popen(command.split(), stdin=PIPE)
proc.communicate(passwd+'\n')[1]

Can any one suggest what am i doing wrong here. Or is there a better way to do this.

Many apps don't use stdin for password prompt for security reasons. Possible duplicate of stackoverflow.com/questions/5225542/… — cdarke
– cdarke, Commented Apr 23, 2015 at 6:38
From the mysql doc: Specifying a password on the command line should be considered insecure. You can use an option file to avoid giving the password on the command line. dev.mysql.com/doc/refman/5.6/en/mysql-command-options.html — cdarke
– cdarke, Commented Apr 23, 2015 at 6:47

Toby D · Accepted Answer · 2015-04-23 06:12:55Z

1

You can try this:

command = "mysql -u root -p" + passwd

answered Apr 23, 2015 at 6:12

Toby D

1,4291 gold badge19 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Toby D Over a year ago

@harshul gandhi hi, please mark this answer if you find it correct. Thanks

harshul gandhi Over a year ago

tried that, it prompts me to enter password on terminal

Toby D Over a year ago

The command will look like: "mysql -u root -puser" for your case.

Jay Venkat · Accepted Answer · 2015-04-23 07:08:49Z

0

I tried your script in Ubuntu 14.04. It is very easy to start a MySQL in terminal using shell script. Here is the code..

#!/bin/bash       
user=('root')
pass=('XXX')
mysql -u $user -p$pass
echo 'success'

Simply run this code & you can start the MySQL at terminal...

answered Apr 23, 2015 at 7:08

Jay Venkat

4072 gold badges7 silver badges19 bronze badges

6 Comments

cdarke Over a year ago

What are the brackets all about around the user and pass values?

cdarke Over a year ago

Really? That doesn't create a constant for me, in bash I use declare -r. Which version of bash is that in?

Jay Venkat Over a year ago

GNU bash, version 4.3.11

Jay Venkat Over a year ago

I misunderstand variable declaration. Brackets used for array declaration.

cdarke Over a year ago

And that was introduced in Bash 4, prior to that the parentheses are ignored. By the way, it is good practice to put double quotes around variable expansions (`"$pass"') in case there is embedded whitespace.

|

Collectives™ on Stack Overflow

unix command execution with password via python

2 Answers 2

3 Comments

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related