[owncloud-devel] SOLVED - Re: Owncloud in Ubuntu 16.04 - Failed to connect to the database: Access denied for user ‘root’@’localhost’

Anton Blau tony.blue.mailinglist at gmx.de
Sat Sep 17 23:20:03 GMT 2016

Thank you to all.

Here´s the solution:

1. Produce a MySQL Dump (mysqldump-uusername-p--all-databases>dump.sql)
2. Delete all mysql-packages (dpkg --purge mysql...)
3. Reinstall mysql

mysql -u root -p|

|CREATE DATABASE owncloud; ||GRANT ALL ON owncloud.* to 'owncloud'@'localhost' IDENTIFIED BY 
'set_database_password'; ||FLUSH PRIVILEGES;|

4. Restore MySQL Dump(mysql-uusername-pdatabase_name<dump.sql)
5. Backup /var/www/owncloud/config + /var/www/owncloud/data
6. Delete all owncloud* Packages
7. Reinstall owncloud
8. Restore /var/www/owncloud/config + /var/www/owncloud/data from backup


Thank you!


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.owncloud.org/pipermail/devel/attachments/20160918/64530b56/attachment.html>

More information about the Devel mailing list