使用phpMyAdmin连接MariaDB遇1045权限错误及IPv6解析问题求助

核心错误信息 #

mysqli::real_connect(): (HY000/1045): Access denied for user 'tudor'@'<ipv6 ip>' (using password: YES)

phpMyAdmin配置详情 #

/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['verbose'] = 'Node 3';
$cfg['Servers'][$i]['host'] = 'n3sql.tudor0b.xyz';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = false;

/* SSL */
$cfg['ForceSSL']= false;
$cfg['Servers'][$i]['ssl'] = false;
$cfg['Servers'][$i]['ssl_ca'] = '/etc/mysql/ssl/ca-cert.pem';
$cfg['Servers'][$i]['ssl_ca_path'] = '/etc/mysql/ssl/';
$cfg['Servers'][$i]['ssl_ciphers'] = 'TLS_AES_256_GCM_SHA384';
$cfg['Servers'][$i]['ssl_key'] = '/etc/mysql/ss1/server-key.pem';
$cfg['Servers'][$i]['ssl_cert'] = '/etc/mysql/ss1/server-cert.pem';
$cfg['Servers'][$i]['ssl_verify'] = true;

环境配置 #

OS: Ubuntu 22.04
phpMyAdmin: 5.2.1
MariaDB: 10.6.12
PHP: 8.2
VPS拥有3个IPv6地址和1个本地IPv4地址

• DNS解析已指向MariaDB的IPv6地址
• 使用MySQL Workbench连接数据库及SSL功能均正常
• 尝试过通过DNS域名和直接IPv6地址两种方式连接phpMyAdmin
• 已执行chmod 777 /etc/mysql/ssl/确保phpMyAdmin可访问SSL证书目录

补充错误（直接用IPv6地址连接时） #

mysqli::real_connect(): php_network_getaddresses: getaddrinfo for 2a01 failed: Temporary failure in name resolution

内容的提问来源于stack exchange，提问作者Tudor0b