Mysql clearly has no problem with the password.

I initialize the mysql database and log in by initializing the password, but I cannot log in after modification.

-sharp 
/usr/taotie/mysql/bin/mysqld  --defaults-file=/usr/taotie/mysql/my.cnf --user=taotie-dber --initialize
-sharp 
mysqld_safe  --defaults-file=/etc/my.cnf --user=taotie-dber
-sharp 
mysql -uroot -p
-sharp
ALTER USER "root"@"localhost" IDENTIFIED WITH sha256_password BY "" PASSWORD EXPIRE INTERVAL 360 DAY;

CREATE USER wp IDENTIFIED BY "";

flush privileges;

cannot log in
mysql-uroot-p new password

paste database / etc/my.cnf configuration

[client]
port = 3306
socket = /tmp/mysql.sock
-sharp The MySQL server
[mysqld]
port = 3306
user = taotie-dber
socket = /tmp/mysql.sock
pid-file = /data/miss_taotie_db/mysqld.pid
basedir = /usr/taotie/mysql/
datadir = /data/miss_taotie_db/db
tmpdir = /data/miss_taotie_db/tmp
open_files_limit = 60000
explicit_defaults_for_timestamp=true
server-id = 1203306
lower_case_table_names = 1
character-set-server = utf8mb4
federated
-sharpsql_mode=STRICT_TRANS_TABLES
-sharpsql_mode="NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER"
max_connections = 1000
max_connect_errors = 100000
interactive_timeout = 86400
wait_timeout = 86400
sync_binlog=0
back_log=100
default-storage-engine = InnoDB
log_slave_updates = 1
-sharpskip-grant-tables
-sharpdefault-authentication-plugin=sha256_password
default-authentication-plugin=mysql_native_password
-sharpdefault-authentication-plugin=caching-sha2-password
-sharp*********** Logs related settings ***********
log-bin = /data/miss_taotie_db/logs/binlog/mysql-bin
binlog_format= mixed
binlog_cache_size=32m
max_binlog_cache_size=64m
max_binlog_size=512m
long_query_time = 1
log_output = FILE
log-error = /data/miss_taotie_db/logs/mysql-error.log
slow_query_log = 1
slow_query_log_file = /data/miss_taotie_db/logs/slow_statement.log
-sharplog_queries_not_using_indexes
general_log = 0
general_log_file = /data/miss_taotie_db/logs/general/general_statement.log
-sharpexpire-logs-days = 14
binlog_expire_logs_seconds = 1728000
relay-log = /data/miss_taotie_db/logs/binlog/relay-bin
relay-log-index = /data/miss_taotie_db/logs/binlog/relay-bin.index

-sharp****** MySQL Replication New Feature*********
master-info-repository=TABLE
relay-log-info-repository=TABLE
relay-log-recovery

-sharp*********** INNODB Specific options ***********
innodb_buffer_pool_size = 4096M
transaction-isolation=REPEATABLE-READ
innodb_buffer_pool_instances = 8
innodb_file_per_table = 1
innodb_data_home_dir = /data/miss_taotie_db/innodb/innodb_ts
innodb_data_file_path = ibdata1:2048M:autoextend
innodb_thread_concurrency = 8
innodb_log_buffer_size = 16M
innodb_log_file_size = 128M
innodb_log_files_in_group = 3
innodb_log_group_home_dir = /data/miss_taotie_db/innodb/innodb_log
innodb_flush_log_at_trx_commit = 2
innodb_max_dirty_pages_pct = 70
innodb_flush_method=O_DIRECT

[mysql]
no-auto-rehash
default-character-set=utf8mb4
prompt = (\u@\h) [\d]>\_
problem solved the password I generated with the random password generator, such as Gx*X@%$mQdizFutu or $oRU-fBNHmimMtzi, was successfully set, but could not be logged in, but I later gave up the random password generator such as 1111, and logged in successfully
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e9f065-5c83d.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e9f065-5c83d.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?