mySQL root password

riff-raff · 12. Januar 2018

I set up a fresh OMV4 vm for testing, patched it, included OMV Extras and installed nginx, letsencrypt and mySQL.

After starting mySQL, I tried to log into the management tool as root. I tried no password, my root password and I used the function to specify a new root password, neither of those options worked for me to login.

I want to setup a database for nextcloud.

It probably would be better to use Docker, but I am a little confused using this nice tool. I did not get my nextcloud running within docker.

Edit: I tried to upgrade directly from OMV3 -> OMV4 with running plugins (Letsencrypt, MySQL, Nginx) and migration worked quite will despite some PHP issues for Nextcloud (GD, ZIP, cURL missing). Also I was able to login to my mySQL-install using the provided web tool. On a fresh OMV4 I still can't set my root password for mySQL through the OMV GUI.

moreje · 19. Februar 2018

well, same for me... fresch install of OMV 4.... unable to login to MySql webadmin using root

PeterPan · 24. Juli 2018

tray omvadmin instead of root as mysql user

shimue93 · 25. Juli 2018

I also tried that does not work for me. in the console over ssh but root goes perfectly

shimue93 · 25. Juli 2018

Have now changed over the console the password for the user omvadmin and then it worked.

Code

mysql -uroot -p
SET PASSWORD FOR 'omvadmin'@'localhost' = PASSWORD(''YOURPASSWORD);

Funny that it did not work before.

caseyj · 6. August 2018

Zitat

omvadmin

that works for me. But seriously, its written somewhere else we suppose to discover it by ourself ??

ryecoaaron · 6. August 2018

Zitat von caseyj

But seriously, its written somewhere else we suppose to discover it by ourself ??

Uhhh... Did you read the text on the plugin itself? I thought it was pretty clear.

caseyj · 6. August 2018

Ok sorry sensei !

Jetzt mitmachen!