Sign InTry Free

SET PASSWORD

This statement changes the user password for a user account in the TiDB system database.

Synopsis

SetStmt:

SetStmt

Examples

mysql> SET PASSWORD='test'; -- change my password Query OK, 0 rows affected (0.01 sec) mysql> CREATE USER 'newuser' IDENTIFIED BY 'test'; Query OK, 1 row affected (0.00 sec) mysql> SELECT USER, HOST, PASSWORD FROM mysql.`user` WHERE USER = 'newuser'; +---------+------+-------------------------------------------+ | USER | HOST | PASSWORD | +---------+------+-------------------------------------------+ | newuser | % | *94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29 | +---------+------+-------------------------------------------+ 1 row in set (0.00 sec) mysql> SET PASSWORD FOR newuser = 'test'; Query OK, 0 rows affected (0.01 sec) mysql> SELECT USER, HOST, PASSWORD FROM mysql.`user` WHERE USER = 'newuser'; +---------+------+-------------------------------------------+ | USER | HOST | PASSWORD | +---------+------+-------------------------------------------+ | newuser | % | *94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29 | +---------+------+-------------------------------------------+ 1 row in set (0.00 sec) mysql> SET PASSWORD FOR newuser = PASSWORD('test'); -- deprecated syntax from earlier MySQL releases Query OK, 0 rows affected (0.00 sec) mysql> SELECT USER, HOST, PASSWORD FROM mysql.`user` WHERE USER = 'newuser'; +---------+------+-------------------------------------------+ | USER | HOST | PASSWORD | +---------+------+-------------------------------------------+ | newuser | % | *94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29 | +---------+------+-------------------------------------------+ 1 row in set (0.00 sec)

MySQL compatibility

This statement is understood to be fully compatible with MySQL. Any compatibility differences should be reported via an issue on GitHub.

See also

Download PDF
Playground
New
One-stop & interactive experience of TiDB's capabilities WITHOUT registration.
Products
TiDB
TiDB Dedicated
TiDB Serverless
Pricing
Get Demo
Get Started
© 2024 PingCAP. All Rights Reserved.
Privacy Policy.