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.


Answer: You can try this:

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

