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;
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’.
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!
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 ‘%”‘
Like in the console in your browser if you want to check a bunch of checkboxes on the page at once
Especially handy for Drupal permissions administration pages.
Now as a software developer I need to learn how to sew….
DIY Wearable Computing – Adafruit
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