2014年3月28日 星期五

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




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


2014年3月12日 星期三

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搜尋



參考