Mysql password has expired

Mysql password has expired Your password has ex navicat Indicates that the password has expired

Mysql -uroot -p If the local mysql server has expired, run the following command: Log in to the cli as user root (the cli login does not expire). Mysql -uroot -p set password = password(‘123456’); Use client access again and find available.

Then change the password correctly!!

Case 2: If the server mysql has expired. In this case, you need to change the password of the specified user. For example, root@% > set password for ‘root’@’%’ = password(‘123456’); Use client access again and find available.