Problem "pymysql.err.OperationalError: (1698, "Access denied for user '_7d79990466ac2897'@'localhost

Hi everyone,

I’ve just set up Frappe Bench and started it, but when I try to access the website, I get a “pymysql.err.OperationalError: (1698, “Access denied for user ‘_7d79990466ac2897’@‘localhost’”)” error.

To fix this error, I tried checking MariaDB, but there seems to be no user table even after reinstalling it. I also tried updating the user plugin to ‘mysql_native_password’, but it gave me an error saying that the ‘mysql.user’ view references invalid tables or columns.

Can anyone help me with this issue? I’m not sure what else to do.

Thanks in advance.

the username appears to be the name of the DB on mysql/mariadb. You probably need to set/fix permissions to the DB and then check access from inside python using a test script for connectivity