Create DB

[roldanbob]

Issue the command:

sudo mysql -u root -p

When prompted enter your sudo password and then the MySQL root user password. [When do I set the sql root user and pwd?]

When you are in the database command prompt, create the database with the command:

CREATE DATABASE owncloud;

Next create a new database user with the command:

CREATE USER 'ownclouduser'@'localhost' IDENTIFIED BY 'PASSWORD';

Where PASSWORD is a strong password for the user.

Give the new user permissions for the new database with the command:

GRANT ALL ON owncloud.* TO 'ownclouduser'@'localhost' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;

Where PASSWORD is a strong password for the user.

Flush the privileges and exit the database shell with the commands:

FLUSH PRIVILEGES;
EXIT;