Update User Password in MySQL

July 9, 2011 By Leave a Comment

Apparently, quite a number of people are looking into my humble website trying to find out how to change a password of an existing user. Doing this is easy in Oracle with a ALTER USER command. In MySQL, it is different in such a way that you need to update a table. Here’s the command.
[Read more...]

Incoming search terms:

  • mysql alter user
  • alter user change password mysql
  • oracle alter user set password
  • mysql alter user password
  • mysql alter user change password
  • mysql alter password
  • myphp user_password
  • how to set password for existing user in mysql
  • how to find password of an existing users in mysql
  • alter user password
Filed Under: Blog, MySQL

How To Cancel Subscription on Paypal

June 28, 2011 By Leave a Comment

The menu on PayPal dashboard is very confusing to say the least. You have to dig into the menu to be able to find what exactly you are looking for. Case in point is the subscription. You’ll have to click several links just to see what your current subscriptions are. So for the benefit of mankind, I’m listing the steps down.
[Read more...]

Incoming search terms:

  • paypal cancel subscription
  • how to cancel paypal subscription 2011
  • paypal how to cancel subscription
Filed Under: Blog, InterWebs Tagged With: , , , ,

Recursive setacl command on Linux/Unix

June 24, 2011 By Leave a Comment

Setting access control list(acl) recursively is not as straigthforward in HP/UX. I believe the same is true for other Unix flavors. In case you are wondering how, the command is shown below.
[Read more...]

Incoming search terms:

  • setacl linux
  • linux install command recursive
  • setacl recursive
  • SetACL
  • kwatog setfacl
  • setacl recursive in hp-ux
  • setacl kwatog
  • setacl hp-ux file
  • setacl en linux que es?
  • setacl command in unix
Filed Under: Blog, Linux, Unix Tagged With: , , ,

SubVersion Initialization Error

June 13, 2011 By Leave a Comment

After installing subversion, I hit some error when I tried to restart Apache. When I removed/renamed the subversion.conf and the error went away. Obviously, subversion did not work. So I investigated to find out the root cause.
[Read more...]

Filed Under: Blog, Linux

How To Install Subversion on CentOS

June 12, 2011 By Leave a Comment

I finally decided to setup an online version control and chose subversion (instead of cvs which I use on my macbook). Initially, I was thinking of subscribing to github but the prospect of paying monthly did not bode well especially that it would only be me who will be updating the codes. Github has a free service though. But that’s if you open-source your code.
[Read more...]

Incoming search terms:

  • install subversion centos
  • centos svn
  • install subversion on centos
  • install svn centos
  • svnauthz conf httpd conf
  • svn centos passwd
  • install subversion on centos step by step
  • mod dav svn sethandler php
  • password protect svn centos
  • step by step guide to install subversion in centos
Filed Under: Blog, Linux Tagged With: , , , ,

Jing : Free Screencapture for Mac

June 12, 2011 By Leave a Comment

The default screen capture of Mac, command+shift+4, is good. I can specify the part of the screen I want to capture and it’s automatically saved into a PNG file. It’s very simple and straightforward. But the longer I use it, the more I miss Greenshot. But that’s not (yet?) available for Mac.
[Read more...]

Incoming search terms:

  • greenshot for mac
  • greenshot mac
  • free screen capture for mac 2011
  • free screen capture mac
  • free screen capture mac 2011
  • obfuscate in jing
Filed Under: Blog, Mac

How To Burn ISO Image to DVD in Mac

June 11, 2011 By Leave a Comment

Mac OS X already comes with the Disk Utility app which you can use to burn ISO images into a CD/DVD. You don’t have to buy or download a new app to just do that. The step-by-step procedure is shown below.
[Read more...]

Incoming search terms:

  • burn iso to dvd mac
  • burn iso mac
  • buy iso dvd mac
  • iso burn mac
  • how to burn iso to dvd on mac
  • how to burn iso to dvd mac
  • how to burn iso image to dvd on mac
  • burn iso to dvd on mac
  • how to burn iso on mac rename
  • how to burn iso on mac 2011
Filed Under: Blog, Mac

Read Input Without Echo in Bash

June 5, 2011 By Leave a Comment

I have a script that needs to be deployed in different environment as most scripts are. This script requires asking for userid, tnsname and password during deployment. I tried to use READ but it echoes the password on the screen as soon as I type it. So how can we hide the password? Here’s how.
[Read more...]

Incoming search terms:

  • bash read password no echo
  • bash read password
  • bash read input
  • bash read without echo
  • bash read no echo
  • bash readInput
  • read contraseñas bash
  • C no echo input
  • echo $ % bash
  • echo -e bash
Filed Under: Blog, Linux

Update Oracle Sequence Last Number

May 31, 2011 By Leave a Comment

I only realized this last week that direct update of the last number of the sequence. Or maybe I just don’t know so what I did was to create a workaround.
[Read more...]

Incoming search terms:

  • alter sequence last number
  • update sequence oracle
  • oracle update sequence last_number
  • oracle update sequence
  • alter sequence LAST_NUMBER
  • oracle sequence change last number
  • how to update oracle sequence last_number
  • update sequence in oracle
  • update sequence
  • update oracle sequence last_number
Filed Under: Blog, Oracle, PL/SQL

Automatically Convert Emails to NoSpam

May 18, 2011 By Leave a Comment

To prevent spam comments on one of the sites that I maintain, I send for approval any comment with at least one URL or email address in it. In that way, manual spammers will find no incentive on leaving comments on the site. At the same time, email addresses left by commenters will not be displayed in the site until it is sanitized. However, the amount of comments in the site in question is so many and manually sanitizing comments with emails is becoming a pain.
[Read more...]

Incoming search terms:

  • emailsafe jquery
  • \ [a-z0-9][a-z0-9_-]*
Filed Under: Blog, PHP, WordPress
« Older Posts
Newer Posts »