Assign Account Passwords

• Passwords may be assigned from the command line by using the mysqladmin command:

  mysqladmin -u user_name -h host_name password "password"

  • The account for which this command resets the password is the one with a user table row that matches user_name in the User column and the connecting client host in the Host column.

• Another way to assign a password to an account is to issue a SET PASSWORD statement:

  SET PASSWORD FOR 'user_name'@'%' = PASSWORD('password');

  • The FOR clause specifies the user.

• Only users such as root that have update access to the mysql database can change the password for other users.

• The syntax to change one's own password is:

  SET PASSWORD = PASSWORD('password');

How do I keep passwords secure?

---

---

© 2007 John Michael Pierobon

Notes