Change my own password

From SQLZOO
Revision as of 13:40, 17 July 2012 by Connor (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, 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'
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense