Jump to content
Froxlor Forum
  • 0

Setup proccess failed. Access denied for user 'root'@'localhost'


AreYouLoco?

Question

Posted

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:
5abfadcd634b8_Zrzutekranuz2018-03-3117-34-46.png.62aa1df941ddbbaa8729c54cf91bd791.png

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
5abfae66c71ed_Zrzutekranuz2018-03-3117-46-24.thumb.png.2bf609218497664d601918dbb4ab16dd.png

 

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                                  |
+------------------------------------------------------------------------------------------------+

 

3 answers to this question

Recommended Posts

Posted

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;

 

Posted

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.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...