How to set the login password for mysql

Editor to share with you how to set mysql login password, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Setting method: 1, use "set password=password ('your password');" command; 2, use "update user set password=password ('your password') where user='root';" command.

Mysql set password

There are many ways:

1. After entering mysql with root

Mysql > set password = password ('your password'); mysql > flush privileges

2. Use the Grant statement

Mysql > grant all on *. * to 'root'@'localhost' IDENTIFIED BY' your password 'with grant option; mysql > flush privileges

3. Enter the mysql library to modify the user table

Mysql > use mysql;mysql > update user set password=password ('your password') where user='root';mysql > flush privileges; all the contents of how to set the login password of mysql, thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!