Hi,

I am trying to setup froxlor on my Debian LAMP. I followed the guide from here: https://github.com/Froxlor/Froxlor/wiki/Install-froxlor-on-debian and and here https://github.com/Froxlor/Froxlor/wiki/Install-froxlor-from-tarball.

I am stuck on page that I need to provide credentials to the database. When I go forward I do get this:

I fill in my credentials; new password for froxlor database, new password for admin account, my root password that I can use to login locally via:

mysql -u root -p

Please help

 

EDIT:
I did some research and I allowed remote root login.

MariaDB [(none)]> show grants;
+------------------------------------------------------------------------------------------------+
| Grants for root@localhost                                                                      |
+------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED VIA unix_socket WITH GRANT OPTION |
| GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION                                  |
+------------------------------------------------------------------------------------------------+

 

Newer distros do this to avoid usage of the root user, to allow login run the following queries:

update mysql.user set password=password('YOUR_MYSQL_ROOT_PASSWD') where user='root';
update mysql.user set plugin='' where user='root';
flush privileges;

 

Thanks that actually worked like a charm. I was able to install froxlor successfully.  Solved.

It is also possible to change MySQL Hostname from '127.0.0.1' to 'localhost' (in case the database is installed on the same server)

Then you do not have to enable remote root login.