Forums

i have been getitng this error , i have searched through forum but did not find anything

error in error log

Error running WSGI application : pymysql.err.OperationalError: (1044, "Access denied for user 'digifarm'@'%' to database 'commodity_prices'") File "/var/www/digifarm_pythonanywhere_com_wsgi.py", line 16, in <module> from app.py import app as application

File "/home/digifarm/mysite/app.py", line 13, in <module> db = pymysql.connect(host="digifarm.mysql.pythonanywhere-services.com", user="digifarm", password="root@123", db="commodity_prices")

File "/home/digifarm/.local/lib/python3.10/site-packages/pymysql/connections.py", line 352, in init self.connect()

File "/home/digifarm/.local/lib/python3.10/site-packages/pymysql/connections.py", line 636, in connect self._request_authentication() File "/home/digifarm/.local/lib/python3.10/site-packages/pymysql/connections.py", line 911, in _request_authentication auth_packet = self._read_packet()

File "/home/digifarm/.local/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet packet.raise_for_error() File "/home/digifarm/.local/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/home/digifarm/.local/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval)

error while trying to grant privilages mysql> GRANT ALL PRIVILEGES ON commodity_prices.* TO 'digifarm'@'%'; ERROR 1044 (42000): Access denied for user 'digifarm'@'%' to database 'commodity_prices'

i think there is some problem with wsgi file but i am unable to understand it import sys

project_home = '/home/digifarm/mysite' if project_home not in sys.path: sys.path = [project_home] + sys.path

from app import app as application

application = application

You are not able to change the privileges of your databases. You should already have privileges, so you do not need to do that.