python db connectivity with mysql -
i using sql workbench, php code in tools of workbench db connection is:
$host="215.157.120.106"; $port=3386; $socket=""; $user="root"; $password=""; $dbname="pay"; $con = new mysqli($host, $user, $password, $dbname, $port, $socket) or die ('could not connect database server' . mysqli_connect_error()); //$con->close();
i want query in python. attempt:
import mysqldb db = mysqldb.connect(host="215.157.120.106",user="root",db="pay",port=3386,passwd="")
but gives error:
operationalerror: (1045, "access denied user 'root'@'16.95.57.211' (using password: no)")
Comments
Post a Comment