Install ERPNext without root access to the remote mariadb server

[oneyb]

I had the same problem… It took me forever, but got things working now now. It’s not ideal, but works. See:

Getting MySQL to work on Debian 9

1 Proper MySQL set-up From: https://kofler.info/root-login-problem-mit-mariadb/ 2 Install prerequisites sudo apt-get install mysql-server mysql-client mysql-common libmariadbclient-dev 3 Set password sudo mysqladmin password -u root 4 Put passwords in file:///etc/mysql/debian.cnf 5 Remove unix_socket plugin sudo mysql -u root -p UPDATE mysql.user set PLUGIN='' where USER='root'; FLUSH PRIVILEGES; 6 Configure for ERPNext echo -e "[mysqld]\ninnodb-file-f…