creating a new database with mysqldb

[John Salerno]

Since the connect method of mysqldb requires a database name, it seems
like you can't use it without having a database already created. So is
there a way to connect to your mysql server (without a specified
database) in order to create a new database (i.e., the CREATE DATABASE
query)?

Thanks.

[BartlebyScrivener]

Type:

create a new database with mysql

into google and see what happens

rd

[John Salerno]

BartlebyScriven er wrote:

Type:

create a new database with mysql

into google and see what happens

rd

Well, the thing about it is that all the guides I find online seem to
begin with using a command prompt or a unix shell, neither of which will
work in my case. I'm trying to find a way to access my database server
using just a python script. Perhaps that isn't even possible for me to
do without shell access. I might just have to use the msqladministrat or
in my server control panel, instead of using python.

[Philippe Martin]

John Salerno wrote:

Since the connect method of mysqldb requires a database name, it seems
like you can't use it without having a database already created. So is
there a way to connect to your mysql server (without a specified
database) in order to create a new database (i.e., the CREATE DATABASE
query)?

Thanks.

I'm no expert but: can't you spawn mysql with a script/scheme ?

Philippe

[Heiko Wundram]

Am Mittwoch 17 Mai 2006 21:23 schrieb John Salerno:

Well, the thing about it is that all the guides I find online seem to
begin with using a command prompt or a unix shell, neither of which will
work in my case. I'm trying to find a way to access my database server
using just a python script. Perhaps that isn't even possible for me to
do without shell access. I might just have to use the msqladministrat or
in my server control panel, instead of using python.

Creating a database is just another SQL command in MySQL (which you can easily
send to the MySQL server you're using with Python and MySQLdb):

"CREATE DATABASE <dbname>"

Of course, you need to log on with a user who is allowed to create databases.

See the MySQL documentation for more info on the available CREATE commands.

--- Heiko.

[BartlebyScrivener]

I would learn basic, commandline SQL first and get comfortable creating
tables, querying your dbs etc. THEN, add Python. Otherwise you spin
your wheels not knowing whether it's your use of the Python modules or
your bad SQL commands that are fouling things up.

http://sqlcourse.com/intro.html

or I recommend Chris Fehily's SQL 2nd Ed. Great book, and cheap.

[John Salerno]

Heiko Wundram wrote:

Of course, you need to log on with a user who is allowed to create databases.

yeah, this is where I'm stuck. The only "logging on" i know how to do is
with the connect method, but that requires a database to exist already

[John Salerno]

BartlebyScriven er wrote:

I would learn basic, commandline SQL first and get comfortable creating
tables, querying your dbs etc. THEN, add Python. Otherwise you spin
your wheels not knowing whether it's your use of the Python modules or
your bad SQL commands that are fouling things up.

http://sqlcourse.com/intro.html

or I recommend Chris Fehily's SQL 2nd Ed. Great book, and cheap.

I did that tutorial yesterday. It was great and I learned a lot about
the basics of working with tables. After learning the queries, then I
moved on to using them with Python. I plan to get the pocket reference
later today, so that might help as well.

[Jesse Hager]

John Salerno wrote:

Since the connect method of mysqldb requires a database name, it seems
like you can't use it without having a database already created. So is
there a way to connect to your mysql server (without a specified
database) in order to create a new database (i.e., the CREATE DATABASE
query)?

Thanks.

In every MySQL library I have ever seen, the database parameter is
optional. You may either omit it or pass an empty string. It is just a
shortcut so the application does not need to send a "USE" command to
select the active database.

import MySQLdb
db = MySQLdb.connect ("host","userna me","password ")
c = db.cursor()
To get the currently selected database:
c.execute("S ELECT DATABASE()") 1Lc.fetchall () ((None,),)
^^^
None (NULL) indicates no currently selected database.

To set the default database:
c.execute("U SE mysql") 0L

Getting the database again:
c.execute("S ELECT DATABASE()") 1Lc.fetchall ()

(('mysql',),)
^^^
A string indicates that a database is currently selected.

Hope this helps.

--
Jesse Hager
email = "wr********@tzn vy.pbz".decode( "rot13")

[John Salerno]

Jesse Hager wrote:

In every MySQL library I have ever seen, the database parameter is
optional. You may either omit it or pass an empty string. It is just a
shortcut so the application does not need to send a "USE" command to
select the active database.

I tried it without the db parameter, then sent a CREATE TABLE query, but
I got this:

OperationalErro r: (1046, 'No Database Selected')