我已经检查了上面的所有条目，但它解决不了我的问题，mysql启动的正常，我可以输入mmysql -u根-p和密码，这是确定的！
但是当我检查mysql状态时，我得到以下消息：
Jul 04 13:29:46 raspi21 systemd[1]: Starting MariaDB 10.3.34 database server...
Jul 04 13:29:47 raspi21 mysqld[861]: 2022-07-04 13:29:47 0 [Note] /usr/sbin/mysqld (mysqld 10.3.34-MariaDB-0+deb10u1) starting as process 861 ...
Jul 04 13:29:48 raspi21 systemd[1]: Started MariaDB 10.3.34 database server.
Jul 04 13:29:48 raspi21 /etc/mysql/debian-start[910]: Upgrading MySQL tables if necessary.
Jul 04 13:29:48 raspi21 /etc/mysql/debian-start[913]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Jul 04 13:29:48 raspi21 /etc/mysql/debian-start[913]: Looking for 'mysql' as: /usr/bin/mysql
Jul 04 13:29:48 raspi21 /etc/mysql/debian-start[913]: Reading datadir from the MariaDB server failed. Got the following error when executing the 'mysql' command line client
Jul 04 13:29:48 raspi21 /etc/mysql/debian-start[913]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Jul 04 13:29:48 raspi21 /etc/mysql/debian-start[913]: FATAL ERROR: Upgrade failed
Jul 04 13:29:48 raspi21 /etc/mysql/debian-start[920]: Checking for insecure root accounts.我不明白这个论点“（使用密码：否）
谢谢你的任何信息的帮助马克斯
1条答案
按热度按时间gstyhher1#
/etc/debian/debian-start正在启动升级，并使用/etc/mysql/debian.cnf作为mysql_upgrade的用户名/密码存储。由于此处的凭据与您更改的密码不匹配，因此无法升级。