SQL to change Drupal 6 password directly in database

Need to change a Drupal 6 user password in your database using the command line or a tool like PhpMyAdmin or MySQL Workbench?  Use SQL like this:

update `users` set `pass` = MD5('NewPassword') where `uid` = 1;

or

update `users` set `pass` = MD5('NewPassword') 
where `mail` = 'useremailaddress';

In the first case I’m updating the password for the Drupal user whose uid is 1, and I’m making their new password ‘NewPassword’.

In the second case I’m updating the password for the Drupal user whose email address is ‘useremailaddress’, and I’m making their new password ‘NewPassword’.

Linode over AWS, GAE, DreamHost, GoDaddy

Need fast SSD hosting, root access, 1 GB of RAM? with speedy support? Then I recommend Linode.

I have used Amazon’s EC2, GoDaddy, DreamHost, Google App Engine, and others for deploying my applications. But Linode is the one I recommend. Stable, fast, reliable, great support, cost-effective. Highly Recommended!

MySQL how to remove prefix/suffix e.g. leading/trailing quotes from a column of strings

update table set column = trim(BOTH '"' FROM column);

For example, above removes the leading and trailing (prefix/suffic) quotes that excel adds upon csv export.

You could Select records with a prefix that was a quote (“) this way:

SELECT * FROM table WHERE column like '"%'

or a suffix quote (“) this way:

SELECT * FROM table WHERE column like ‘%”‘

Docker / Fabric links

Docker links:

http://docker.io

http://stackoverflow.com/questions/16047306/how-is-docker-io-different-from-a-normal-virtual-machine

https://www.docker.io/learn_more/

http://footyntech.wordpress.com/2013/08/23/what-docker-is/

http://www.activestate.com/blog/2013/06/solomon-hykes-explains-docker

https://www.docker.io/gettingstarted/

http://docs.docker.io/en/latest/installation/mac/
fabric/ python specific:

https://ochronus.com/docker-primer-django/

https://github.com/mailgun/shipper

http://www.pythonforbeginners.com/systems-programming/how-to-use-fabric-in-python/

https://github.com/FirelightWebware/djangocon2013-notes/blob/master/django-and-docker.md

https://dstegelman-conf-notes.readthedocs.org/en/latest/conferences/djangocon2013/tuesday/django_docker.html

http://rogueleaderr.com/post/65157477648/the-idiomatic-guide-to-deploying-django-in-production

http://techblog.stickyworld.com/testing-django-apps-with-docker.html

http://blog.docker.io/tag/django/

How to Argue

How to compose a successful critical commentary:
1. You should attempt to re-express your target’s position so clearly, vividly, and fairly that your target says, “Thanks, I wish I’d thought of putting it that way.
2. You should list any points of agreement (especially if they are not matters of general or widespread agreement).
3. You should mention anything you have learned from your target.
4. Only then are you permitted to say so much as a word of rebuttal or criticism.

–source I don’t remember