MySQL & Python

Jaime Wyant programmer.py at gmail.com
Thu Sep 15 10:27:03 EDT 2005


Connect to the database as root.

create database databasename;

Now grant priveleges accordingly:

grant all on databasename to super_user;

(I may have the grant syntax screwed up, but you get the idea.) 

jw

On 9/15/05, Ed Hotchkiss <edhotchkiss at gmail.com> wrote:
> Just migrating now from ASP/to MySQL and Python. 
>   
> I am trying to create a simple script to access a MySQL DB. 
> The Module for MySQL looks very easy, however I do not understand one thing
> ... 
>   
> In ASP, you can just create a new DB with Access. In MySQL, how do I create
> a database to start playing with? I see all of the commands to edits tables
> and values and move a cursor, but I do not see how I actually create THE
> INITIAL DB, any help would be appreciated. thanks. 
> 
> -- 
> edward hotchkiss 
> --
> http://mail.python.org/mailman/listinfo/python-list
> 
>



More information about the Python-list mailing list