mysql access denied for user root@localhost

Issues during installation and related to database
Post Reply
tafkaz
Posts: 2
Joined: Tue Jul 02, 2019 3:57 pm

mysql access denied for user root@localhost

Post by tafkaz » Tue Jul 02, 2019 4:35 pm

Hi,
we are avluating onlyoffice for a customer.
I have installed the community edition via the script from here
(choosing N).
Onlyoffice is running pretty stable, seems all good.
We do however experience som charset issues with german language.
gives me a hint on how to resolv, but unfortunately we can't log in to mysql. We simply don't know the password.

mysql -u root -p gives me

Code: Select all

ERROR 1045 (28000): Access denied for user root@localhost (using password: YES)
The hint from here doesn't help
"onlyoffice" or "my-secret-pw" both don't work

Can you help?
Thanks
Sascha

Maxim
Posts: 2017
Joined: Tue Oct 11, 2016 2:34 pm

Re: mysql access denied for user root@localhost

Post by Maxim » Wed Jul 03, 2019 7:13 am

Hello tafkaz!
Open /var/www/onlyoffice/WebStudio/web.connections.config
You can find it there.

tafkaz
Posts: 2
Joined: Tue Jul 02, 2019 3:57 pm

Re: mysql access denied for user root@localhost

Post by tafkaz » Wed Jul 03, 2019 12:59 pm

Hi Maxim,
thanks for your quick answer.
I allready reinstalled the complete system now using docker, and we don't have the encoding error there.
Strange enough, but works for us now. :-)

thanks
Sascha

Maxim
Posts: 2017
Joined: Tue Oct 11, 2016 2:34 pm

Re: mysql access denied for user root@localhost

Post by Maxim » Thu Jul 04, 2019 7:55 am

Hello tafkaz!
I think Docker is more flexible solution.

Post Reply