creating database in python

Question

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

Burhan Khalid · Accepted Answer · 2018-08-07 04:51:02Z

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.

edited Aug 7, 2018 at 4:51

answered Jun 13, 2013 at 4:11

Burhan Khalid

175k20 gold badges254 silver badges291 bronze badges

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

5 Comments

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.

Burhan Khalid Over a year ago

Did you install a MySQL server?

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.

user3522371 Over a year ago

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

SuB Over a year ago

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

htynkn · Accepted Answer · 2013-06-13 04:15:33Z

3

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)

answered Jun 13, 2013 at 4:15

htynkn

1045 bronze badges

2 Comments

chom Over a year ago

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)")

htynkn Over a year ago

@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.

Collectives™ on Stack Overflow

creating database in python

2 Answers 2

5 Comments

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

2 Comments

Related