Is there a possibility to install ERPNext without the need to have root access to the remote MariaDB server. I have created the database myself and the user, given all grants on the database so this should be enough to set up the tables and so on. I see no reason to give root access, especially as it is very unsecure to allow root to login remotely.
A few more things in your setup scripts for MariaDB:
The above should not be up to the developer of the application to decide. It’s the DBA who decides this. Not so happy with that part, so I did not change my settings at all. Could you tell me why you have it and if it’s really needed ?
- collation-server = utf8mb4_unicode_ci
The above are very unwanted too. The application should not decide this. It’s the DBA. You can easily change this when you create the DB: create database erpnext character set utf8mb4 collate utf8mb4_unicode_ci;
I do not like the above, again, it’s the DBA who decides the server, not the application. I allowed it after reading what it does. But indexes on more than 768 characters ? What are you indexing that way ?