How to Change Password of a user in MySQL Server - MySQL DBA Tutorial

How to change password for a user/login in MySQL Server

To reset the password in MySQL for user , below statement can be used.

Syntax:

MySQL > SET PASSWORD FOR 'UserName'@'HostName' = 'NewPassword'

Example : 
Let's say that we have user TB and we want to change the password to 'Pass123#' , below statement can be used in MySQL Server to reset the password.


MySQL > SET PASSWORD FOR 'TB'@'localhost' = 'Pass123#';


you can also user statement to change the password in MySQL Server

MySQL > alter user 'username'@'HostName' identified by 'Password'   


MySQL Tutorial for beginners - How to change or reset password for user in MySQL Server

2 comments:

  1. a word unscrambler is a tool that you enter all your letters in your hand and it rearranges them to reveal all possible word combinations. website: http://easywordunscrambler.com/

    ReplyDelete
  2. To set ‘username’ and ‘new_password’ as actual values but put instead the tags replacing them with their respective values. But I have been handling this while carrying out my project and getting master thesis help has really eased these tasks so much.

    ReplyDelete