Using mysql password function
update tablename set password=password(‘mypass’) where id=9;
Update MD5 Passwords
update tablename set password=md5(‘mypass’) where id=9;
Update sha1 Passwords
update tablename set password=sha1(‘mypass’) where id=9;
© 2018 ALL Rights Reserved | Sitemap
Vancouver | North Vancouver | Burnaby | Richmond | Coquitlam | Port Coquitlam | Surrey | Langley | Maple Ridge | Mission | Abbotsford | Kamloops | Kelowna | Victoria | Squamish | Whistler | Pemberton