4. Create a new database in MySQL, grant permissions, set password and flush (Again, in this example the database name is owncloud). It is a good idea to create a separate admin-user for owncloud with a strong password, because you will only need this owncloud-admin for administrative tasks.
+
4. Create a new MySQL database (Again, in this example the database name is owncloud and replace username and password for your own chosen ones)
−
Create database and owncloud-admin. Replace "put ... usernamehere" with name of owncloud-admin (e.g. oc-admin) and choose strong password. So (on server-console) issue:
+
Login as root and issue on the console:
−
<nowiki>
+
mysql
−
myUser="put owncloud-admin usernamehere"
+
create database owncloud;
−
myPass="put password here"
+
grant all privileges on owncloud.* to username identified by 'password';
−
mysql --execute="create database owncloud"
+
flush privileges;
−
mysql --execute="grant all privileges on owncloud.* to $myUser@localhost identified by $myPass"
+
exit
−
mysql --execute="flush privileges"
−
</nowiki>
5. Browse to http://yourserver/owncloud and follow install script
5. Browse to http://yourserver/owncloud and follow install script