Change my own password

From SQLZoo
Jump to navigation Jump to search

Change my own password.

schema:gisq

Users should be able to change their own passwords. The administrator should be able to change other people's passwords.

WARNING

Many of these commands will work and change the password for the user scott. This will prevent you and other users from using SQLZoo - if you do change it please set the password back by visiting the appropriate fix page.

ALTER USER scott WITH PASSWORD 'tiger'
!passwd
ALTER USER scott WITH PASSWORD 'tiger'
ALTER USER scott WITH PASSWORD 'tiger'
ALTER USER scott PASSWORD 'tiger'
password
sp_password @old='tiger', @new='tiger'
set password for scott@localhost=password('tiger')
ALTER IDENT scott USING 'tiger'
sp_password @old='tiger', @new='tiger'
DataWars, Data Science Practice Projects - LogoDataWars: Practice Data Science/Analysis with +100 Real Life Projects