Pythonanywhere MySQL connection

Question

I'm new to pythonanywhere and am currently deploying my first app with it and the bottle framework. I have created a db with the online console but I don't know the syntax for accessing it. Is it the same syntax as when deploying locally? Or is it something else? MySQLdb has been imported... Thanks for any help.

Have you tried anything? Reading help for PythonAnywhere and for MySQLdb package is strongly recommended. — Vladimir
– Vladimir, Commented Sep 9, 2014 at 10:52

Vladimir · Accepted Answer · 2014-09-10 07:41:34Z

3

Here is page on using MySQL at PythonAnywhere. It suggests to use the following configuration for django:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': '<your_username>$<your_database_name>',
        'USER': '<your_username>',
        'PASSWORD': '<your_mysql_password>',
        'HOST': 'mysql.server',
    }
}

And I'm almost entirely sure that these credentials will be acceped by MySQLdb driver:

db=MySQLdb.connect(
    host='mysql.server',
    user='<your_username>',
    passwd='<your_mysql_password>',
    db='<your_username>$<your_database_name>')

edited Sep 10, 2014 at 7:41

answered Sep 9, 2014 at 10:51

Vladimir

10.6k4 gold badges30 silver badges37 bronze badges

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

3 Comments

Donnacha Over a year ago

Thanks VLadimir, I had some similar to that, but when I use db_mysqlconnect(host='mysql.server', user='<your_username>', passwd='<your_mysql_password>', db='<your_username>$<your_database_name>') I get an error "undefined name '_mysql'", any thoughts?

Vladimir Over a year ago

From documentation on MySQL: If you want to write applications which are portable across databases, use MySQLdb, and avoid using this module directly. Code fixed.

Donnacha Over a year ago

Apologies my password was wrong, thanks a million for your help :)

Collectives™ on Stack Overflow

Pythonanywhere MySQL connection

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related