Differences

This shows you the differences between two versions of the page.

--- deb_mutism [2019/04/06 16:50] – [Install Wordpress™] Júne Park
+++ deb_mutism [2019/04/10 14:50] – [Install ownCloud] Júne Park
@@ Line 445: / Line 445: @@
 ),
 );
+</code>
+----
+=== Run background jobs ===
+Add ''crontab'' with web user such as ''www-data''
+<code bash>
+# crontab -u www-data -e
+</code>
+Add job
+<code bash>
+*  *  *  *  * /usr/bin/php -f /path/to/your/owncloud/cron.php
+</code>
+----
+==== Reset MySQL password ====
+Stop the MySQL service
+<code bash>
+sudo /etc/init.d/mysql stop
+</code>
+Start MySQL without a password
+<code bash>
+sudo mysqld_safe --skip-grant-tables &
+</code>
+Connect to MySQL
+<code mysql>
+mysql -uroot
+</code>
+Set a new MySQL root password
+<code mysql>
+use mysql;
+update user set authentication_string=PASSWORD("mynewpassword") where User='root';
+flush privileges;
+quit
+</code>
+Stop and start the MySQL service
+<code bash>
+sudo /etc/init.d/mysql stop
+...
+sudo /etc/init.d/mysql start
+</code>
+Log in to the database
+<code bash>
+mysql -u root -p
 </code>