Set / Change / Reset the MySQL root password on Ubuntu Linux

Tested on
- Ubuntu Linux 7.10 Gutsy Gibbon and MySQL 5.0.45. (2007-10-21)
- Ubuntu Linux 6.06 Dapper Drake and MySQL 4.1.15.

Set / change / reset the MySQL root password on Ubuntu Linux. Enter the following lines in your terminal.

1. Stop the MySQL Server.
   

   sudo /etc/init.d/mysql stop



2. Start the mysqld configuration.
   

   sudo mysqld --skip-grant-tables &



3. Login to MySQL as root.
   

   mysql -u root mysql



4. Replace YOURNEWPASSWORD with your new password!
   

   UPDATE user SET Password=PASSWORD('YOURNEWPASSWORD') WHERE User='root'; FLUSH PRIVILEGES; exit;

Note: This method is not regarded as the securest way of resetting the password. However it works.


References

MySQL 5.0 Reference Manual: How to Reset the Root Password

© Copyright 2003-2006 - Rafael Gattringer. All rights reserved. Legal notic

Moodle2.5擾人的Installing an add-on

其實Moodle2.5真的增加了許多功能，但也因為開放太太多了，導致執行速度下降…＝　＝

所以爬了一下文找到Moodle官方的文件說明Installing an add-on的用途，也找到的可以disabled的設定。

說明如下：

Preventing installing add-ons from within Moodle
If required, installing and updating from within Moodle can be prevented by copying the following lines of code from config-dist.php and pasting them in config.php.

// Use the following flag to completely disable the On-click add-on installation

// feature and hide it from the server administration UI. 

 $CFG->disableonclickaddoninstall = true;　　//設定不要每次登入時都執行plugin搜尋

參考

http://docs.moodle.org/25/en/Installing_add-ons