Adding new site problem (fresh install on ubuntu desktop 18.04 LTS)

Hello, please help
i want install erpnext on ubuntu 18.04 LTS
when i want add a new site it giving me this strange error
i tried with the normal user and root, im using Mariadb

what i get :

root@Myname:/opt/erpnext/erpnext# bench new-site example.com
MySQL root password:
Traceback (most recent call last):
File “/usr/lib/python2.7/runpy.py”, line 174, in _run_module_as_main
main”, fname, loader, pkg_name)
File “/usr/lib/python2.7/runpy.py”, line 72, in _run_code
exec code in run_globals
File “/opt/erpnext/erpnext/apps/frappe/frappe/utils/bench_helper.py”, line 97, in
main()
File “/opt/erpnext/erpnext/apps/frappe/frappe/utils/bench_helper.py”, line 18, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/opt/erpnext/erpnext/env/local/lib/python2.7/site-packages/click/core.py”, line 764, in call
return self.main(*args, **kwargs)
File “/opt/erpnext/erpnext/env/local/lib/python2.7/site-packages/click/core.py”, line 717, in main
rv = self.invoke(ctx)
File “/opt/erpnext/erpnext/env/local/lib/python2.7/site-packages/click/core.py”, line 1137, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/opt/erpnext/erpnext/env/local/lib/python2.7/site-packages/click/core.py”, line 1137, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/opt/erpnext/erpnext/env/local/lib/python2.7/site-packages/click/core.py”, line 956, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/opt/erpnext/erpnext/env/local/lib/python2.7/site-packages/click/core.py”, line 555, in invoke
return callback(*args, **kwargs)
File “/opt/erpnext/erpnext/apps/frappe/frappe/commands/site.py”, line 33, in new_site
db_type = db_type)
File “/opt/erpnext/erpnext/apps/frappe/frappe/commands/site.py”, line 66, in _new_site
source_sql=source_sql,force=force, reinstall=reinstall, db_type=db_type)
File “/opt/erpnext/erpnext/apps/frappe/frappe/installer.py”, line 35, in install_db
setup_database(force, source_sql, verbose)
File “/opt/erpnext/erpnext/apps/frappe/frappe/database/init.py”, line 16, in setup_database
return frappe.database.mariadb.setup_db.setup_database(force, source_sql, verbose)
File “/opt/erpnext/erpnext/apps/frappe/frappe/database/mariadb/setup_db.py”, line 39, in setup_database
if force or (db_name not in dbman.get_database_list()):
File “/opt/erpnext/erpnext/apps/frappe/frappe/database/db_manager.py”, line 58, in get_database_list
return [d[0] for d in self.db.sql(“SHOW DATABASES”)]
File “/opt/erpnext/erpnext/apps/frappe/frappe/database/database.py”, line 122, in sql
self.connect()
File “/opt/erpnext/erpnext/apps/frappe/frappe/database/database.py”, line 75, in connect
self._conn = self.get_connection()
File “/opt/erpnext/erpnext/apps/frappe/frappe/database/mariadb/database.py”, line 90, in get_connection
local_infile = frappe.conf.local_infile)
File “/opt/erpnext/erpnext/env/local/lib/python2.7/site-packages/pymysql/init.py”, line 94, in Connect
return Connection(*args, **kwargs)
File “/opt/erpnext/erpnext/env/local/lib/python2.7/site-packages/pymysql/connections.py”, line 325, in init
self.connect()
File “/opt/erpnext/erpnext/env/local/lib/python2.7/site-packages/pymysql/connections.py”, line 599, in connect
self._request_authentication()
File “/opt/erpnext/erpnext/env/local/lib/python2.7/site-packages/pymysql/connections.py”, line 861, in _request_authentication
auth_packet = self._read_packet()
File “/opt/erpnext/erpnext/env/local/lib/python2.7/site-packages/pymysql/connections.py”, line 684, in _read_packet
packet.check_error()
File “/opt/erpnext/erpnext/env/local/lib/python2.7/site-packages/pymysql/protocol.py”, line 220, in check_error
err.raise_mysql_exception(self._data)
File “/opt/erpnext/erpnext/env/local/lib/python2.7/site-packages/pymysql/err.py”, line 109, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.InternalError: (1698, u"Access denied for user ‘root’@‘localhost’")

Try either of these https://discuss.erpnext.com/search?q=pymysql.err.InternalError%3A%20(1698%2C%20u"Access%20denied%20for%20user%20‘root’%40‘localhost’")

You also seem to be running the install as user=root - this is not advised. Rather use user=frappe, and give that user sudo rights

the problem is on 18.04, is very complicated. i worked with 16.4 it was so easy and without any problem.
and the best way to install is following ERPNEXT steps on github.

thank you.

if you are still having issues, check this link

that is the one I used and worked good.

i installed it on Ubuntu 18.04 with these steps :
Log in as root

su -

Update the system and install necessary packages

apt-get update && sudo apt-get -y upgrade
apt-get install wget python-minimal

Download install script :

cd && wget https://raw.githubusercontent.com/frappe/bench/master/playbooks/install.py

Start the installation by command below :

python install.py --production --user frappe

During the installation process, the script will ask you for a MariaDB root password and a Frappe Administrator password which you can use later on to login to the ERPNext dashboard. Make sure to use a strong password.

The installation will take some time and if it is successful, you will see something like this:

Frappe/ERPNext has been successfully installed!