Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Python Anywhere access denied to MySQL database

I started to use Python Anywhere today. I created the database MySQL following the instructions. The problem is I can't do a simple manage.py syncdb because I get access denied error for my user 'irgmedeiros' in my mysql database. I can't grant privileges to my user neither create another user with privileges. How to solve it? Couldn't find solution in their forum and I'm waiting a answer from email. Anybody experienced this before?

like image 462
Medeiros Avatar asked Dec 28 '12 01:12

Medeiros


1 Answers

Some possible troubleshooting steps:

  • check the server address - mysql.server
  • double-check the password - is it the same as the one you configured on the pythonanywhere MySQL config screens
  • double-check the database name - this follows the format username$database_name
  • check if you can open a normal mysql console, firstly from the MySQL tab, and then manually in a bash shell with

.

mysql -u my_username -h mysql.server -p

[edit] - the final solution was:

* double-check the database name - this follows the format username$database_name

don't forget that username$ folks!

like image 77
hwjp Avatar answered Sep 19 '22 17:09

hwjp