How did you configure your database? Did you use"create a DB"? or did you use it on a separate host?
Which user should be used for database access?
It can be that there is an issue, because mariadb/ mysql has improved their security and and root is only allowed to be used for localhost.
I just followed the instructions. There are no step for creating/configuring a DB in your instructions. So I presumed that it gets created from the installation wizard page.
Where? That page tells me to input an admin username and password and then Click “Finish Setup”. Exactly what I did. It does not tell me to create or configure a DB. It does not even say we need or not need to create one before.
Point your web browser to http://localhost/owncloud
Enter your desired administrator’s username and password.
Click “Finish Setup”.
Does this part doesn’t describe the database part for MySQL/MariaDB?
MYSQL/MariaDB
MariaDB is the ownCloud recommended database. It may be used with either ownCloud Server or ownCloud Enterprise editions. To install the recommended MySQL/MariaDB database, use the following command:
sudo apt-get install mariadb-server
If you have an administrator login that has permissions to create and modify databases, you may choose “Storage & Database”. Then, enter your database administrator username and password, and the name you want for your ownCloud database. Alternatively, you can use these steps to create a temporary database administrator account.
sudo mysql --user=root mysql
CREATE USER ‘dbadmin’@‘localhost’ IDENTIFIED BY ‘Apassword’;
GRANT ALL PRIVILEGES ON . TO ‘dbadmin’@‘localhost’ WITH GRANT OPTION;
FLUSH PRIVILEGES;
exit
For more detailed information, see MySQL/MariaDB.
You can choose your database. But all is described in our installation instruction. You can choose another database, too.
I am having trouble when I try this line after creating the dbadmin user.
GRANT ALL PRIVILEGES ON . TO ‘dbadmin’@‘localhost’ WITH GRANT OPTION;
It says “You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘TO ‘dbadmin’@‘localhost’ WITH GRANT OPTION’ at line 1”
I was able to manage to make it work by doing some MySql googling.
I created the dbadmin user like so: CREATE USER ‘dbadmin’@‘localhost’ IDENTIFIED BY ‘123456’;
then I created a DB: CREATE DATABASE owncloud;
then I exited mysql
then I gave dbadmin access to the DB: mysql -h localhost -u dbadmin -p owncloud
then I input these credentials in the web Installation Wizard and created a user named ocadmin