[solved]Cannot change mysql password for owncloud

[jimmycypherz]

Hello

I recently installed the own cloud container and i cannot change the mysql password no matter what i try. I've searched the forum and tried all the solutions i've found with no luck.

I tried restarting the server, deleting the container, recreating it again always getting the same result.
After a few hours i gave up and installed myphpadmin and thought about using the default password, and cannot login with the default password. I get a 1045 error and tells me i cannot login to MYSQL.
What am i doing wrong?

Here's a screenshot of the error.

Any suggestions will be greatly appreciated

Thanks,


Jimmy

 

[snowman66]

Re: Cannot change mysql password for owncloud

Check the root username if is really root. Maybe is something else which is good for security reasons i guess.
Owncloud also uses sqlite database.

Where did you get this owncloud template?

 

[jimmycypherz]

Re: Cannot change mysql password for owncloud

Hi snowman66

Yes, it shows the user is root at the .my.cnf file
See below

I downloaded the own cloud template from here, the password there is the randomized one created at first boot up.
I have even tried pasting the password when i get prompted for the password and i still get the same error.
http://pve.proxmox.com/wiki/OwnCloud

Thanks,

Jimmy

 

[snowman66]

Re: Cannot change mysql password for owncloud

Try to reconfigure mysql server:

dpkg-reconfigure mysql-server-5.1

 

[jimmycypherz]

Re: Cannot change mysql password for owncloud

You Sir, are a lifesaver. That did it.
All is good now

Thanks snowman66