Update Guide to install

As was suggested in other posts, I have tried to install ERPNext manually, but I am having great difficulty even though I am following step by step the official guides.
In some cases I find Warning and Fatal Error; in another case I arrived at the end, but then ERPNext is not reachable.

Is there an updated guide?

I am starting with a VPS installed at 1and1. This is my VPS configuration.
Xeon E5-2650 2 vCore

I have tried both a minimal installation of Ubuntu 64bit, and with a “1and1 standard” installation with already present the classic applications.
I tried both the 16.04 and the 18.04.

I would prefer to use the 18.04 LTS, but if there are problems of incompatibility I will use the 16.04.
However, most of my tests were done with the 16.04 minimal

I’ve used these guides:

Thanks in advance for the advices

Use the below guide

I’m sorry, but even with this there are some warnings and errors.

I tried with a “Minimal” installation of Ubuntu 18.04 and doing the copy paste of your commands.

During the installation of MariaDB the password is not requested, I have to supply it with mysql_secure_installation. I’m sure about password.

With non-root users, such as Bench, the “pip” commands give rights errors to the .config folders. You must use “sudo -H”

At the beginning the 10.0.1 version of pip was installed, but then with the bench command there is the message that you are using version 9.0.3

When I finally run bench new-site and the MySQL Root password request appears, several errors are listed and the process stops.

We have tried 5, FIVE, times from a clean server image and with different MariaDB root passwords and the problem can not be this one.

Frankly speaking, it is the first time that we are in two to work 4 days just to make a first installation of an application. And we have years of experience behind it.

bench@localhost:~/erpnext$ bench new-site SUBDOMAIN.DOMAIN.TLD
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/bench/erpnext/apps/frappe/frappe/utils/bench_helper.py", line 97, in <module>
  File "/opt/bench/erpnext/apps/frappe/frappe/utils/bench_helper.py", line 18, in main
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/click/core.py", line 722, in __call__
    return self.main(*args, **kwargs)
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/click/core.py", line 697, in main
    rv = self.invoke(ctx)
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/click/core.py", line 1066, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/click/core.py", line 1066, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/click/core.py", line 895, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/click/core.py", line 535, in invoke
    return callback(*args, **kwargs)
  File "/opt/bench/erpnext/apps/frappe/frappe/commands/site.py", line 34, in new_site
    verbose=verbose, install_apps=install_app, source_sql=source_sql, force=force)
  File "/opt/bench/erpnext/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 "/opt/bench/erpnext/apps/frappe/frappe/installer.py", line 38, in install_db
    create_database_and_user(force, verbose)
  File "/opt/bench/erpnext/apps/frappe/frappe/installer.py", line 62, in create_database_and_user
    if force or (db_name not in dbman.get_database_list()):
  File "/opt/bench/erpnext/apps/frappe/frappe/model/db_schema.py", line 554, in get_database_list
    return [d[0] for d in self.db.sql("SHOW DATABASES")]
  File "/opt/bench/erpnext/apps/frappe/frappe/database.py", line 166, in sql
  File "/opt/bench/erpnext/apps/frappe/frappe/database.py", line 116, in connect
    charset='utf8mb4', use_unicode = True, conv = conversions, local_infile = self.local_infile)
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/__init__.py", line 94, in Connect
    return Connection(*args, **kwargs)
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 327, in __init__
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 598, in connect
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 852, in _request_authentication
    auth_packet = self._read_packet()
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 683, in _read_packet
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/protocol.py", line 220, in check_error
  File "/opt/bench/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'")

I manage to install on 18.04,
I followed the below link and given bench database access in mysql