1 | 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.
1 2 3 4 5 6 7 | $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:
1 | mysqladmin -u root password NEWPASSWORD |
However, if you want to change (or update) a root password, then you need to use following command
1 | mysqladmin -u root -p'oldpassword' password newpass |
For example, If old password is abc, and set new password to 123456, enter:
1 | 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 :
1 | alter table TABLE_NAME convert to character set utf8 collate utf8_unicode_ci; |