hey, guys
I was installing frappe from this docs in git-hub
It was working fine till create a site in frappe bench by using this command.
bench new-site dcode.com
It asks me for mysql root password, when wrote it it gives me this error:
MySQL root password:
Traceback (most recent call last):
File “/home/saifsabry/frappe-bench/apps/frappe/frappe/commands/site.py”, line 109, in new_site
_new_site(
File “/home/saifsabry/frappe-bench/apps/frappe/frappe/installer.py”, line 83, in _new_site
install_db(
File “/home/saifsabry/frappe-bench/apps/frappe/frappe/installer.py”, line 166, in install_db
setup_database(force, verbose, mariadb_user_host_login_scope)
File “/home/saifsabry/frappe-bench/apps/frappe/frappe/database/init.py”, line 21, in setup_database
return frappe.database.mariadb.setup_db.setup_database(force, verbose, mariadb_user_host_login_scope)
File “/home/saifsabry/frappe-bench/apps/frappe/frappe/database/mariadb/setup_db.py”, line 34, in setup_database
dbman.create_user(db_user, frappe.conf.db_password, **dbman_kwargs)
File “/home/saifsabry/frappe-bench/apps/frappe/frappe/database/db_manager.py”, line 17, in create_user
host = host or self.get_current_host()
File “/home/saifsabry/frappe-bench/apps/frappe/frappe/database/db_manager.py”, line 14, in get_current_host
return self.db.sql(“select user()”)[0][0].split(“@”)[1]
File “/home/saifsabry/frappe-bench/apps/frappe/frappe/database/database.py”, line 213, in sql
self.connect()
File “/home/saifsabry/frappe-bench/apps/frappe/frappe/database/database.py”, line 118, in connect
self._conn: “MariadbConnection” | “PostgresConnection” = self.get_connection()
File “/home/saifsabry/frappe-bench/apps/frappe/frappe/database/mariadb/database.py”, line 107, in get_connection
conn = self._get_connection()
File “/home/saifsabry/frappe-bench/apps/frappe/frappe/database/mariadb/database.py”, line 113, in _get_connection
return self.create_connection()
File “/home/saifsabry/frappe-bench/apps/frappe/frappe/database/mariadb/database.py”, line 116, in create_connection
return pymysql.connect(**self.get_connection_settings())
File “/home/saifsabry/frappe-bench/env/lib/python3.10/site-packages/pymysql/connections.py”, line 361, in init
self.connect()
File “/home/saifsabry/frappe-bench/env/lib/python3.10/site-packages/pymysql/connections.py”, line 669, in connect
self._request_authentication()
File “/home/saifsabry/frappe-bench/env/lib/python3.10/site-packages/pymysql/connections.py”, line 957, in _request_authentication
auth_packet = self._read_packet()
File “/home/saifsabry/frappe-bench/env/lib/python3.10/site-packages/pymysql/connections.py”, line 775, in _read_packet
packet.raise_for_error()
File “/home/saifsabry/frappe-bench/env/lib/python3.10/site-packages/pymysql/protocol.py”, line 219, in raise_for_error
err.raise_mysql_exception(self._data)
File “/home/saifsabry/frappe-bench/env/lib/python3.10/site-packages/pymysql/err.py”, line 150, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1698, “Access denied for user ‘root’@‘localhost’”)
Site creation failed, do you want to rollback the site? [y/N]: y
so idk what is that it was working fine so please if anyone knew what is this plz help me .
thank you