A progressive voice of the digital age, we are fighting for our digital freedoms in software, hardware and on the Internet. We watch for corporate abuse as well as promote knowledge and educate people about the dangers our rights currently face such as DRM and software patents. We do this with a focus on the Free Software movement and the ideals presented by the EFF, FSF, ACLU, and the hacker ethic.
Please support our social mission.

*Subscribe to our discussion list (med traffic) here
*Stay updated and get action alerts delivered to your inbox here
*Come to our meetings here .
*Subscribe to our local Boston list here
All of our decisions are made through direct democracy and collective decision making. For more information about us, please go here.
Solidarity

 

Usefull Mysql commands

tata's picture
Submitted by tata on Tue, 2006-09-19 15:57.

You can change privileges using an SQL UPDATE command or the GRANT statement. If you are using SQL statements such as UPDATE or INSERT to update or set user passwords, be sure to use the PASSWORD() function to encrypt the password in the database. Finally, remember to FLUSH PRIVILEGES; for any changes you make so that they become effective:

UPDATE user SET Host=localhost, Password=PASSWORD(new_pass), Reload_priv=Y, Process_priv=Y WHERE User='admin'; FLUSH PRIVILEGES;

»