Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Next revisionBoth sides next revision | ||
deb_mutism [2019/04/06 17:58] – [Install ownCloud] Júne Park | deb_mutism [2019/04/10 14:50] – [Install ownCloud] Júne Park | ||
---|---|---|---|
Line 460: | Line 460: | ||
<code bash> | <code bash> | ||
* * * * * / | * * * * * / | ||
+ | </ | ||
+ | |||
+ | ---- | ||
+ | |||
+ | ==== Reset MySQL password ==== | ||
+ | |||
+ | Stop the MySQL service | ||
+ | <code bash> | ||
+ | sudo / | ||
+ | </ | ||
+ | |||
+ | Start MySQL without a password | ||
+ | <code bash> | ||
+ | sudo mysqld_safe --skip-grant-tables & | ||
+ | </ | ||
+ | |||
+ | Connect to MySQL | ||
+ | <code mysql> | ||
+ | mysql -uroot | ||
+ | </ | ||
+ | |||
+ | Set a new MySQL root password | ||
+ | <code mysql> | ||
+ | use mysql; | ||
+ | update user set authentication_string=PASSWORD(" | ||
+ | flush privileges; | ||
+ | quit | ||
+ | </ | ||
+ | |||
+ | Stop and start the MySQL service | ||
+ | <code bash> | ||
+ | sudo / | ||
+ | ... | ||
+ | sudo / | ||
+ | </ | ||
+ | |||
+ | Log in to the database | ||
+ | <code bash> | ||
+ | mysql -u root -p | ||
</ | </ | ||