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.
Forums
ERROR 1044 (42000): Access denied for user ' '@'%' to database ' '
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.
fjl
|
4614
posts
|
PythonAnywhere staff
|
deleted
lisot
|
14
posts
|
@lisot I believe we've already replied you in this thread, let's keep the conversation in one place.
