Connor: Created page with "Change my own password.

schema:gisq

Users should be able to change their own passwords. The administrator should be able to chan..."

2012-07-17T13:40:36Z

Created page with "Change my own password. <div class='ht'> <div class=params>schema:gisq</div> <div> Users should be able to change their own passwords. The administrator should be able to chan..."

New page

Change my own password.
<div class='ht'>
<div class=params>schema:gisq</div>
<div>
Users should be able to change their own passwords. The administrator should be able to change other people's passwords.
<h3>'''WARNING'''</h3>
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.
</div>
<source lang=sql class='tidy'>
</source>
<source lang=sql class='setup'></source>
<source lang='sql' class='def e-sqlite'>ALTER USER scott WITH PASSWORD 'tiger'</source>
<source lang='sql' class='def e-db2'>!passwd</source>
<source lang='sql' class='def e-ingres'>ALTER USER scott WITH PASSWORD 'tiger'</source>
<source lang='sql' class='def e-access'>ALTER USER scott WITH PASSWORD 'tiger'</source>
<source lang='sql' class='def e-postgres'>ALTER USER scott PASSWORD 'tiger'</source>
<source lang='sql' class='def e-oracle'>password</source>
<source lang='sql' class='def e-sqlserver'>sp_password @old='tiger', @new='tiger'</source>
<source lang='sql' class='def e-mysql'>set password for scott@localhost=password('tiger')</source>
<source lang='sql' class='def e-mimer'>ALTER IDENT scott USING 'tiger'</source>
<source lang='sql' class='def e-sybase'>sp_password @old='tiger', @new='tiger'</source>

<div class="ecomm e-db2" style="display: none">db2 does not do passwords.
In Unix the command to change the password is passwd.</div>
<div class="ecomm e-oracle" style="display: none">From with sqlplus the command is
password</div>
<div class="ecomm e-mysql" style="display: none">WARNING: PLEASE DO NOT CHANGE THE PASSWORD.
If you change the password the system will not work. No one will be able to connect to this engine - and you will not be able to change it back!</div>
</div>
{{Users ref}}

Change my own password - Revision history

Connor: Created page with "Change my own password. schema:gisq Users should be able to change their own passwords. The administrator should be able to chan..."

Connor: Created page with "Change my own password.

schema:gisq

Users should be able to change their own passwords. The administrator should be able to chan..."