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/