Thought Curry

Some time if you want your website or webpage to be displayed to selected people or you do not want other people to see what is behind the Page. That time you need to create password protected Site. So today I decide to share basic steps for the same. 1. You need to create file named - .htaccess 2. Write below code in .htaccess AuthUserFile /yourserver/fullpath/where.htpasswdresides/.htpasswd AuthGroupFile /dev/null AuthName "Whatever Name you want to displayed with Prompt " AuthType Basic require user Usernameyouwant  3.  create .htpasswd file on your linux system by typing command.  htpasswd -c .htpasswd  Usernameyouwant   4. Upload both file to server. There is also online utility available here:  http://www.tools.dynamicdrive.com/password/

Few days back I had issue with MySQL Root password on Ubuntu 9.04 (Jaunty). I was able to reset the password with following commands on 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;