Jdbc-what are the restrictions on setting passwords in database tables for the PASSWORD function of mysql database?

SELECTID, Name, PASSWORD (Pass), LoginType, CinemaID, MainAccountTypefromt_web_accountWHEREPassPASSWORD (& #39; 01996666 & #39;) andName & #39; quanguohengdian & #39 ;; the same SQL statement executes data in mysql data and does not execute data in java code. However, after I change the password to 11996666 in the database, the SQL statements executed by the java code are recorded, and everything works properly! It is preliminarily considered that the mysqljdbcjavapassword function

Select id, Name, PASSWORD (Pass), LoginType, CinemaID, MainAccountType from t_web_account WHERE Pass = PASSWORD ('000000') and Name = 'quanguohengdian '; the same SQL statement executes data in mysql data and does not execute data in java code. However, after I change the password to 11996666 in the database, the SQL statements executed by the java code are recorded, and everything works properly!

It is preliminarily believed that the PASSWORD in the PASSWORD function cannot start with 0, and I can try many passwords.