Error when connecting to database when creating first admin account

Server
, ,
1

So I followed instruction on how to install OwnCloud from DigitalOcean here, https://www.digitalocean.com/community/tutorials/how-to-install-and-configure-owncloud-on-ubuntu-16-04.

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?

2

Hi,

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 https://doc.owncloud.org

3

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.

4

Hi,

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

https://doc.owncloud.org/server/latest/admin_manual/installation/installation_wizard.html#database-choice

5

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!

6

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