creating database in python

Question 1

I have installed mysql for python and running python from command line. I am getting syntax error while creating a database.

>>> import MySQLdb
>>> CREATE DATABASE chom;
 File "<stdin>", line 1
 CREATE DATABASE chom;
 ^
SyntaxError: invalid syntax

Question 2

CREATE DATABASE chom; this should be run from the MySQL command line client, not from the Python shell.

So, first type mysql -u yourusername -p from your command line. It will ask you for a password, type it in. Then you will get a prompt like this mysql>. Here is where you would type that query.

Now, if you want to do this through Python, you can, but it will require some more work.

>>> import MySQLdb as db
>>> con = db.connect(user="foo", passwd="secret")
>>> cur = con.cursor()
>>> cur.execute('CREATE DATABASE chom;')

See this guide for some examples on how to work with Python and MySQL using the standard DB API.

Question 3

Thanks for the solution. I am getting the following error. Do i need to add Mysql path to environmental variables ? If so what path i need to add ? C:\>mysql -u Chom -p 'mysql' is not recognized as an internal or external command, operable program or batch file.

Question 4

Did you install a MySQL server?

Question 5

Technically creating the database is possible from python, "should be run from the MySQL command line client" is a subjective statement.

Question 6

Can we use the same thing for an SQLite database using python ?

Question 7

username is not input of connect function. please replace it with user

Question 8

If you want create a database,you can try:

import MySQLdb
db1 = MySQLdb.connect(host="localhost",user="root",passwd="****")
cursor = db1.cursor()
sql = 'CREATE DATABASE chom'
cursor.execute(sql)

Question 9

Thanks for the solution. I am getting the following error. <br/> >>> db1 = MySQLdb.connect(host="localhost",user="Chom",passwd="") Traceback (most recent call last): File "<stdin>", line 1, in <module> File "C:\Python27\lib\site-packages\MySQLdb_init_.py", line 81, in Connect return Connection(*args, **kwargs) File "C:\Python27\lib\site-packages\MySQLdb\connections.py", line 187, in init super(Connection, self).__init__(*args, **kwargs2)_mysql_exceptions.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' (10061)")

Question 10

@chom Maybe you should check you mysql status.The username、password and port.Make sure your mysql service works well and can be connected with others.I think the error "Can't connect to MySQL server on 'localhost' (10061)" is caused by your mysql settings not python code.

Burhan Khalid 175k20 gold badges255 silver badges292 bronze badges · Accepted Answer · 2013-06-13 04:11:40Z

9

CREATE DATABASE chom; this should be run from the MySQL command line client, not from the Python shell.

So, first type mysql -u yourusername -p from your command line. It will ask you for a password, type it in. Then you will get a prompt like this mysql>. Here is where you would type that query.

Now, if you want to do this through Python, you can, but it will require some more work.

>>> import MySQLdb as db
>>> con = db.connect(user="foo", passwd="secret")
>>> cur = con.cursor()
>>> cur.execute('CREATE DATABASE chom;')

See this guide for some examples on how to work with Python and MySQL using the standard DB API.

Share

Improve this answer

edited Aug 7, 2018 at 4:51

answered Jun 13, 2013 at 4:11

Burhan Khalid's user avatar

Burhan Khalid

175k20 gold badges255 silver badges292 bronze badges

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

5 Comments

chom

chom Over a year ago

Thanks for the solution. I am getting the following error. Do i need to add Mysql path to environmental variables ? If so what path i need to add ? C:\>mysql -u Chom -p 'mysql' is not recognized as an internal or external command, operable program or batch file.

2013年06月13日T04:36:45.233Z+00:00

Burhan Khalid

Burhan Khalid Over a year ago

Did you install a MySQL server?

2013年06月13日T04:57:47.063Z+00:00

kmarsh

kmarsh Over a year ago

Technically creating the database is possible from python, "should be run from the MySQL command line client" is a subjective statement.

2014年01月13日T15:39:47.617Z+00:00

user3522371

user3522371 Over a year ago

Can we use the same thing for an SQLite database using python ?

2014年07月28日T12:31:11.303Z+00:00

SuB

SuB Over a year ago

username is not input of connect function. please replace it with user

2017年07月22日T15:58:37.303Z+00:00

CollectivesTM on Stack Overflow

creating database in python

2 Answers 2

5 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Post as a guest

Hot Network Questions

CollectivesTM on Stack Overflow

2 Answers 2

5 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Post as a guest

Related