New site creation issue while installing erpnext

HI There,

I have been trying to install erpnext on AWS using ubuntu 18.04

and getting the below error while creating new site


(erpnext) ubuntu@ip-172-31-29-243:~/erpnext/frappe-bench$ bench new-site testsite
WARN: bench is installed in editable mode!

This is not the recommended mode of installation for production. Instead, install the package from PyPI with: pip install frappe-bench

MySQL root password:
Traceback (most recent call last):
File “/usr/lib/python3.6/runpy.py”, line 193, in _run_module_as_main
main”, mod_spec)
File “/usr/lib/python3.6/runpy.py”, line 85, in _run_code
exec(code, run_globals)
File “/home/ubuntu/erpnext/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 97, in
main()
File “/home/ubuntu/erpnext/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 18, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/home/ubuntu/erpnext/frappe-bench/env/lib/python3.6/site-packages/click/core.py”, line 829, in call
return self.main(*args, **kwargs)
File “/home/ubuntu/erpnext/frappe-bench/env/lib/python3.6/site-packages/click/core.py”, line 782, in main
rv = self.invoke(ctx)
File “/home/ubuntu/erpnext/frappe-bench/env/lib/python3.6/site-packages/click/core.py”, line 1259, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/ubuntu/erpnext/frappe-bench/env/lib/python3.6/site-packages/click/core.py”, line 1259, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/ubuntu/erpnext/frappe-bench/env/lib/python3.6/site-packages/click/core.py”, line 1066, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/home/ubuntu/erpnext/frappe-bench/env/lib/python3.6/site-packages/click/core.py”, line 610, in invoke
return callback(*args, **kwargs)
File “/home/ubuntu/erpnext/frappe-bench/apps/frappe/frappe/commands/site.py”, line 34, in new_site
verbose=verbose, install_apps=install_app, source_sql=source_sql, force=force)
File “/home/ubuntu/erpnext/frappe-bench/apps/frappe/frappe/commands/site.py”, line 65, in _new_site
admin_password=admin_password, verbose=verbose, source_sql=source_sql,force=force, reinstall=reinstall)
File “/home/ubuntu/erpnext/frappe-bench/apps/frappe/frappe/installer.py”, line 38, in install_db
create_database_and_user(force, verbose)
File “/home/ubuntu/erpnext/frappe-bench/apps/frappe/frappe/installer.py”, line 62, in create_database_and_user
if force or (db_name not in dbman.get_database_list()):
File “/home/ubuntu/erpnext/frappe-bench/apps/frappe/frappe/model/db_schema.py”, line 555, in get_database_list
return [d[0] for d in self.db.sql(“SHOW DATABASES”)]
File “/home/ubuntu/erpnext/frappe-bench/apps/frappe/frappe/database.py”, line 165, in sql
self.connect()
File “/home/ubuntu/erpnext/frappe-bench/apps/frappe/frappe/database.py”, line 115, in connect
charset=‘utf8mb4’, use_unicode = True, conv = conversions, local_infile = self.local_infile)
TypeError: init() takes 1 positional argument but 4 positional arguments (and 4 keyword-only arguments) were given
(erpnext) ubuntu@ip-172-31-29-243:~/erpnext/frappe-bench$![erp_bug-1|689x372]


Kindly suggest

Try sudo… it will work but I think it is not the best way to install

tried with sudo, not working.

share a reference link to be followed for installing erpnext on ubuntu 18.04