Forums

ERROR 1044 (42000): Access denied for user ' '@'%' to database ' '

Hello to everyone, I encounter this error when I want to create a new database. I did research on the internet, but I could not find any solution. also can I do field operation on json object in mysql 5.7.21 version? Thank you.

console output

i found the solution for the create db: https://www.pythonanywhere.com/user/<username>/databases/ > Create a database and i tested the json field on the mysqldb working properly CREATE TABLE t1 (jdoc JSON); INSERT INTO t1 VALUES('{"key1": "value1", "key2": "value2"}'); describe t1; thanks.

You could create a new MySQL database only via our web interface ("Databases" page on PythonAnywhere). It ensures correct permissions.