I have Mysql problem

1

When I use bench new-site library
MySQL root password: I enter my root password
Traceback (most recent call last):
File “/Users/qassimnasir/CSamples/QFrappe/apps/frappe/frappe/commands/site.py”, line 109, in new_site
_new_site(
File “/Users/qassimnasir/CSamples/QFrappe/apps/frappe/frappe/installer.py”, line 83, in _new_site
install_db(
File “/Users/qassimnasir/CSamples/QFrappe/apps/frappe/frappe/installer.py”, line 166, in install_db
setup_database(force, verbose, mariadb_user_host_login_scope)
File “/Users/qassimnasir/CSamples/QFrappe/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 “/Users/qassimnasir/CSamples/QFrappe/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 “/Users/qassimnasir/CSamples/QFrappe/apps/frappe/frappe/database/db_manager.py”, line 17, in create_user
host = host or self.get_current_host()
^^^^^^^^^^^^^^^^^^^^^^^
File “/Users/qassimnasir/CSamples/QFrappe/apps/frappe/frappe/database/db_manager.py”, line 14, in get_current_host
return self.db.sql(“select user()”)[0][0].split(“@”)[1]
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/Users/qassimnasir/CSamples/QFrappe/apps/frappe/frappe/database/database.py”, line 213, in sql
self.connect()
File “/Users/qassimnasir/CSamples/QFrappe/apps/frappe/frappe/database/database.py”, line 118, in connect
self._conn: “MariadbConnection” | “PostgresConnection” = self.get_connection()
^^^^^^^^^^^^^^^^^^^^^
File “/Users/qassimnasir/CSamples/QFrappe/apps/frappe/frappe/database/mariadb/database.py”, line 107, in get_connection
conn = self._get_connection()
^^^^^^^^^^^^^^^^^^^^^^
File “/Users/qassimnasir/CSamples/QFrappe/apps/frappe/frappe/database/mariadb/database.py”, line 113, in _get_connection
return self.create_connection()
^^^^^^^^^^^^^^^^^^^^^^^^
File “/Users/qassimnasir/CSamples/QFrappe/apps/frappe/frappe/database/mariadb/database.py”, line 116, in create_connection
return pymysql.connect(**self.get_connection_settings())
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/Users/qassimnasir/CSamples/QFrappe/env/lib/python3.11/site-packages/pymysql/connections.py”, line 358, in init
self.connect()
File “/Users/qassimnasir/CSamples/QFrappe/env/lib/python3.11/site-packages/pymysql/connections.py”, line 664, in connect
self._request_authentication()
File “/Users/qassimnasir/CSamples/QFrappe/env/lib/python3.11/site-packages/pymysql/connections.py”, line 954, in _request_authentication
auth_packet = self._read_packet()
^^^^^^^^^^^^^^^^^^^
File “/Users/qassimnasir/CSamples/QFrappe/env/lib/python3.11/site-packages/pymysql/connections.py”, line 772, in _read_packet
packet.raise_for_error()
File “/Users/qassimnasir/CSamples/QFrappe/env/lib/python3.11/site-packages/pymysql/protocol.py”, line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File “/Users/qassimnasir/CSamples/QFrappe/env/lib/python3.11/site-packages/pymysql/err.py”, line 143, 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

Any can help?

2

Why are you installing it as a root user? :face_with_monocle:

Why not create a user and use that user for installing frappe?

Is this a Linux OS or a WSL version?

Did you check if the root password is correct?

3

How ca I install it with a new user? yes, I am sure about it. How can I uninstall and reinstall as you advice?

4

You can drop site from using below command.

bench drop-site [site name] --force

Create user and proceed ahead.

sudo adduser frappe
usermod -aG sudo frappe
su frappe
cd /home/frappe

Thanks