Forums

one line MySQL database URL

I'm using environment variables for my database url so it has to be one line for practicality. The env vars are exported inside postactivate virtualenv. The app is using django

As I see in the previous topic I must use these format

mysql://PAWusername:DBpassword@PAWusername.mysql.pythonanywhere-services.com/PAWusername$databasename

but it doesn't work, it gives me this error

django.db.utils.OperationalError: (1044, "Access denied for user 'PAWusername'@'%' to database 'databasename'")

the strange part is, the databasename in the error is not same as in the environment variable, lets say my database is

richard$blog-mezzanine

but in the error it says

django.db.utils.OperationalError: (1044, "Access denied for user 'PAWusername'@'%' to database 'richard-mezzanine'")

the '$blog' is missing

I know this isn't mandatory but this is the way my repo is set-up. Thanks

nevermind my bad, the export value must be a string so the dollar sign is escaped