user2509663 user2509663 - 1 year ago 205
MySQL Question

ownCloud Setup: SQLSTATE[HY000][1045] Access denied for user 'owncloud'@localhost' (using password:YES)

I wanted to setup my owncloud installation on my raspberry pi 2. So, I created an mysql database and user.


CREATE USER 'owncloud'@'localhost' IDENTIFIED BY 'Password';
GRANT ALL PRIVILEGES ON owncloud. * TO 'owncloud'@'localhost';

After I type all nessesairy parameters into the webinterface of the owncloud-setup, I recevied:

Error while trying to create admin user: Failed to connect the database: An exeption occured in driver: SQLSTATE[HY000][1045] Access denied for user 'owncloud'@'localhost' (using password:YES)

Sadly, my resent sreach on similar topics didn't result in any functional hint on this problem. So, I would be happy about further suggestions.

Answer Source
  1. Look at this:
  2. In Terminal: mysql_upgrade --force -u root -p
  3. Use administrative MySQL »root«-user and password with the Installation Wizard
  4. Check that the Database not exist which you create with the Installation Wizard
  5. If nothing helps, start with sqlite, then migrate to mysql like this:
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download