Problem with library.test and mysql (access denied)

#1

Hello. I am having difficulties with the first library.test project shortly after installing ERPNext.

After creating the library.test site I try bench start and to access the test website through the browser. but get the following message:

OperationalError pymysql.err.OperationalError: (1045, “Access denied for user (…) (using password: YES)”)

Why does the user that was created alongside library.test not get access? Is he not using the proper password? Any ideas what I can do? Thanks

#2

The error message OperationalError pymysql.err.OperationalError: (1045, “Access denied for user (…) (using password: YES)”) indicates that you are trying to connect to a MySQL database with an incorrect username or password. The 1045 error code specifically means that the database server denied your request because the username and password combination you provided did not match a valid user account.

#3

Thanks for the reply. I am new to both Frappe and Linux, but I did figure out that it’s an issue with user privileges. I find it a bit mysterious though, seeing as both the database and the user seem to be generated by bench? They only exist in the database after I run bench new-site library.test, as per the instructions. The tutorial also does not specify any need to grant permissions to a new user that is created during the process. So far I haven’t been able to solve the problem.

#4

What linux distro are you testing on?