deb_mutism

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revisionBoth sides next revision
deb_mutism [2019/04/06 17:58] – [Install ownCloud] Júne Parkdeb_mutism [2019/04/10 14:50] – [Install ownCloud] Júne Park
Line 460: Line 460:
 <code bash>  <code bash> 
 *  *  *  *  * /usr/bin/php -f /path/to/your/owncloud/cron.php *  *  *  *  * /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>  </code> 
  
  • deb_mutism
  • Last modified: 2024/05/21 17:51
  • by Júne Park