Facing issue with db connection after creating new site

Frappe Framework
,
1

Hi there, When i give command for new-site and enter sql password im getting many errors. I tried all methods like editing .cnf file, Changing collation variable.Please help me!!
This is the error i have encountered:
bench new-site dcode.c
MySQL root password:
b"/usr/bin/mariadb: unknown variable ‘pid-file=/run/mysqld/mysqld.pid’\n"
Traceback (most recent call last):
File “”, line 198, in _run_module_as_main
File “”, line 88, in _run_code
File “/home/eunoia/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 114, in
main()
File “/home/eunoia/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 20, in main
click.Group(commands=commands)(prog_name=“bench”)
File “/home/eunoia/frappe-bench/env/lib/python3.11/site-packages/click/core.py”, line 1157, in call
return self.main(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/home/eunoia/frappe-bench/env/lib/python3.11/site-packages/click/core.py”, line 1078, in main
rv = self.invoke(ctx)
^^^^^^^^^^^^^^^^
File “/home/eunoia/frappe-bench/env/lib/python3.11/site-packages/click/core.py”, line 1688, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/home/eunoia/frappe-bench/env/lib/python3.11/site-packages/click/core.py”, line 1688, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/home/eunoia/frappe-bench/env/lib/python3.11/site-packages/click/core.py”, line 1434, in invoke
return ctx.invoke(self.callback, **ctx.params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/home/eunoia/frappe-bench/env/lib/python3.11/site-packages/click/core.py”, line 783, in invoke
return __callback(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/home/eunoia/frappe-bench/apps/frappe/frappe/commands/site.py”, line 68, in new_site
_new_site(
File “/home/eunoia/frappe-bench/apps/frappe/frappe/installer.py”, line 87, in _new_site
install_db(
File “/home/eunoia/frappe-bench/apps/frappe/frappe/installer.py”, line 160, in install_db
setup_database(force, source_sql, verbose, no_mariadb_socket)
File “/home/eunoia/frappe-bench/apps/frappe/frappe/database/init.py”, line 21, in setup_database
return frappe.database.mariadb.setup_db.setup_database(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/home/eunoia/frappe-bench/apps/frappe/frappe/database/mariadb/setup_db.py”, line 53, in setup_database
bootstrap_database(db_name, verbose, source_sql)
File “/home/eunoia/frappe-bench/apps/frappe/frappe/database/mariadb/setup_db.py”, line 70, in bootstrap_database
import_db_from_sql(source_sql, verbose)
File “/home/eunoia/frappe-bench/apps/frappe/frappe/database/mariadb/setup_db.py”, line 93, in import_db_from_sql
DbManager(frappe.local.db).restore_database(
File “/home/eunoia/frappe-bench/apps/frappe/frappe/database/db_manager.py”, line 87, in restore_database
execute_in_shell(" ".join(command), check_exit_code=True, verbose=verbose)
File “/home/eunoia/frappe-bench/apps/frappe/frappe/utils/init.py”, line 484, in execute_in_shell
raise Exception(“Command failed”)
Exception: Command failed

1 Like
2

SEE: mysql - unknown variable 'pid-file=/run/mysqld/mysqld.pid' when setting 50-server.cnf - Ask Ubuntu

3

thankyou