Re: creating a new database with mysqldb

2006-06-01 Thread John Salerno
Frithiof Andreas Jensen wrote: > "John Salerno" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] >> Since the connect method of mysqldb requires a database name, it > seems >> like you can't use it without having a database already created. > > The web hotel I use create *one* databas

Re: creating a new database with mysqldb

2006-06-01 Thread Frithiof Andreas Jensen
"John Salerno" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Since the connect method of mysqldb requires a database name, it seems > like you can't use it without having a database already created. The web hotel I use create *one* database together with the account. I.O.W: I ca

Re: creating a new database with mysqldb

2006-05-18 Thread John Salerno
Dennis Lee Bieber wrote: > As a client on a shared host, I suspect the provider created a user > account and A (one) database for that account. The privilege tables for > that user account would have been set so that only that database is > available. The account would have full privileges w

Re: creating a new database with mysqldb

2006-05-18 Thread John Salerno
BartlebyScrivener wrote: > I was hoping you'd find this earlier when I suggested that you type: > > creating a new database with MySQL > > into google. > > It's the number one hit: > > http://coronet.iicm.edu/mysql/create.html > > If you send the commands listed there via the commandline or th

Re: creating a new database with mysqldb

2006-05-17 Thread BartlebyScrivener
I was hoping you'd find this earlier when I suggested that you type: creating a new database with MySQL into google. It's the number one hit: http://coronet.iicm.edu/mysql/create.html If you send the commands listed there via the commandline or through MySQLdb you should be in business. -- h

Re: creating a new database with mysqldb

2006-05-17 Thread 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 paramet

Re: creating a new database with mysqldb

2006-05-17 Thread 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 DA

Re: creating a new database with mysqldb

2006-05-17 Thread Lou Losee
On 5/17/06, Philippe Martin <[EMAIL PROTECTED]> wrote: 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

Re: creating a new database with mysqldb

2006-05-17 Thread John Salerno
BartlebyScrivener 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. > >

Re: creating a new database with mysqldb

2006-05-17 Thread 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 -- http://mail.python.org/mailman/listinfo/python-

Re: creating a new database with mysqldb

2006-05-17 Thread 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

Re: creating a new database with mysqldb

2006-05-17 Thread 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 D

Re: creating a new database with mysqldb

2006-05-17 Thread 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 scrip

Re: creating a new database with mysqldb

2006-05-17 Thread John Salerno
BartlebyScrivener 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 fi

Re: creating a new database with mysqldb

2006-05-17 Thread BartlebyScrivener
Type: create a new database with mysql into google and see what happens rd -- http://mail.python.org/mailman/listinfo/python-list

creating a new database with mysqldb

2006-05-17 Thread 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.