dpkg-reconfigure tzdata
March 5, 2010
June 7, 2009
Change Linux Password from PHP Script
There are a few scripts available on net which allow you to change a linux user password from PHP. but all of them are very complex and hard to implement , so after some hours of work , I’ve written this PHP script 🙂 it is very simple , in order for this to work you need to allow your webserver to run sed command as root through sudoers , or allow your webserver to write on your /etc/shadow file.
$username='USERNAME';
$password='PASSWORD'; // New Password
$sed='/bin/sed'; //Path to sed command
$salt = substr($username, 0, 2);
$pass_crypt = crypt($password, $salt);
$pass_crypt=str_replace("/","\/",$pass_crypt);
system($sed." -i 's/".$username.":[a-zA-z0-9/$\.]*/".$username.":".$pass_crypt."/g' /etc/shadow",$retval);
June 2, 2009
MySQL Change root password
If you have never set a root password for MySQL, the server does not require a password at all for connecting as root. To setup root password for first time, use mysqladmin command at shell prompt as follows:
mysqladmin -u root password NEWPASSWORD
However, if you want to change (or update) a root password, then you need to use following command
mysqladmin -u root -p'oldpassword' password newpass
For example, If old password is abc, and set new password to 123456, enter:
mysqladmin -u root -p'abc' password '123456'
May 18, 2009
Convert and Change MySQL Collation/Encoding to utf8
This is simple , use the following command on mysql :
alter table TABLE_NAME convert to character set utf8 collate utf8_unicode_ci;