Error when connecting to database when creating first admin account



So I followed instruction on how to install OwnCloud from DigitalOcean here,

Everything went fine, until the last part when I need to create account for the OwnCloud. There is this error.

SQLSTATE[HY000][1045] Access denied for user 'user_test'@'localhost' (using password: yes)

I suspected this is because I input wrong password. However, I can login to 'user_test' using MySQL in console fine (via SSH).

I am using Ubuntu 16.04 from DigitalOcean.

I am new to this kind of stuffs. What kind of information that I need to provide?



you need to specify the mysql root user there and then a correct less privileged user is created as explained at the installation guides available at


Honestly, I am not sure to which part I should look in. I do have these user in MySQL.

  • debian-user-maint
  • mysql.sys
  • user_test
  • root

I can login to user_test and to root via interactive shell.



its the root user as explained (in this little bit hidden) docs:


otherwise you can simply reconfigure whole MySQL (if not any other databases running on this server), by doing this:

sudo dpkg-reconfigure mysql-server

after youve done it, just keep in mind to SAFE your root-password for mysql!


Thank you, I will try this when I get home.