Question

mysqli_real_connect(): (HY000/1862): Your password has expired. To log in you must change it using a client that supports expired passwords.

비밀번호가 만료된것 같아요.

변경 방법 알려주세요.

Answer 1

> ALTER USER 'script'@'localhost' PASSWORD EXPIRE NEVER;

$ /usr/local/mysql/bin/mysqladmin -u root -p password
Enter password:
New password:
Confirm new password:
Warning: Since password will be sent to server in plain text,
use ssl connection to ensure password safety.