Simple steps for mysql to authorize password change

The following brings you simple steps about mysql authorization to change your password. If you are interested, let's take a look at this article. I believe it is more or less helpful for you to read the simple steps of mysql authorization to change your password.

Mysql change password

Update mysql.user set authentication_string=password ('123456') where user='root'

Prompt error password length problem

Mysql > set global validate_password_policy=0

Mysql > set global validate_password_length=1

Mysql authorization

Authorize all permissions of the user

Grant all on. To 'user' @ "%" identified by "password"

Grant alter,insert,select,delete,update,create,drop on. To 'user' @ "%" identified by "password"

FLUSH PRIVILEGES

Grant update,insert,select,create,DELETE on nad.* to 'svsadmin'@ "%"

Authorization of query permissions

Grant select on. To user @ "%" identified by "password"

Revoke drop permission

Revoke drop on. From 'user' @ "%"

Mysql View user list

Mysql > select host,user from mysql.user

Query authorized user permissions

Show grants for user name

Delete accounts and permissions

Drop user user name @'%'

Read the above on the mysql authorization to change the password of the simple steps of the details, whether there is any gain. If you want to know more about it, you can continue to follow our industry information section.