mysql connector in python not working

Question

i wrote the code as below

import mysql.connector
mysql.connector.connect
(host='localhost',database='test2',user='root',password='1234')

and saved the file as databas.py.

When i execute the below code from command prompt i am getting error as shown in command_prompt_error.

But when i execute the same set of commands in python command line link to data base s getting created successfully.(shown in working.png)

please let me know what is the source of the issue

thank u both.@elanor:python defaults to 3.7 version of ptython. @elanor and Frank:i found the answer.python 3.7 doesnot have my sql connector yet.so when i run in 3.4 only the code is working.thank u both for ur suggestion — jeyshree
– jeyshree, Commented Dec 15, 2017 at 3:35

jeyshree · Accepted Answer · 2017-12-15 03:38:07Z

1

python 3.7 does not have my sql connector yet. so when i run in 3.4 only the commands mentioned above are accepted.

answered Dec 15, 2017 at 3:38

jeyshree

592 silver badges9 bronze badges

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

1 Answer 1