debian v10 --> v11 - mariadb upgrade failed
by Kropotkin from LinuxQuestions.org on (#5N1NE)
Hi all,
I upgraded my vps from debian 10 to debian 11. Something changed with my mariadb setup and it won't start now.
I can log into mysql as root manually in terminal. Here is the output from the status command:
Code:status;
--------------
mysql Ver 15.1 Distrib 10.5.11-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper
Connection id: 7
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server: MariaDB
Server version: 10.5.11-MariaDB-1 Debian 11
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /run/mysqld/mysqld.sock
Uptime: 11 min 32 sec
Threads: 1 Questions: 6 Slow queries: 0 Opens: 17 Open tables: 10 Queries per second avg: 0.008I also ran the mysql_upgrade which checked my tables and compeleted without error.
I restart the daemon, but mariadb returns an error:
Code:# systemctl status mariadb
Aug 06 19:02:17 myhost.com mariadbd[5927]: 2021-08-06 19:02:17 4 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
Aug 06 19:02:17 myhost.com /etc/mysql/debian-start[5944]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Aug 06 19:02:17 myhost.com /etc/mysql/debian-start[5944]: Looking for 'mysql' as: /usr/bin/mysql
Aug 06 19:02:17 myhost.com /etc/mysql/debian-start[5944]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Aug 06 19:02:17 myhost.com /etc/mysql/debian-start[5944]: Version check failed. Got the following error when calling the 'mysql' command line client
Aug 06 19:02:17 myhost.com /etc/mysql/debian-start[5944]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Aug 06 19:02:17 myhost.com /etc/mysql/debian-start[5944]: FATAL ERROR: Upgrade failed
Aug 06 19:02:17 myhost.com /etc/mysql/debian-start[5954]: Checking for insecure root accounts.
Aug 06 19:02:17 myhost.com mariadbd[5927]: 2021-08-06 19:02:17 5 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
Aug 06 19:02:17 myhost.com debian-start[5957]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)Any thoughts about what is going wrong here?
I upgraded my vps from debian 10 to debian 11. Something changed with my mariadb setup and it won't start now.
I can log into mysql as root manually in terminal. Here is the output from the status command:
Code:status;
--------------
mysql Ver 15.1 Distrib 10.5.11-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper
Connection id: 7
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server: MariaDB
Server version: 10.5.11-MariaDB-1 Debian 11
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /run/mysqld/mysqld.sock
Uptime: 11 min 32 sec
Threads: 1 Questions: 6 Slow queries: 0 Opens: 17 Open tables: 10 Queries per second avg: 0.008I also ran the mysql_upgrade which checked my tables and compeleted without error.
I restart the daemon, but mariadb returns an error:
Code:# systemctl status mariadb
Aug 06 19:02:17 myhost.com mariadbd[5927]: 2021-08-06 19:02:17 4 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
Aug 06 19:02:17 myhost.com /etc/mysql/debian-start[5944]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Aug 06 19:02:17 myhost.com /etc/mysql/debian-start[5944]: Looking for 'mysql' as: /usr/bin/mysql
Aug 06 19:02:17 myhost.com /etc/mysql/debian-start[5944]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Aug 06 19:02:17 myhost.com /etc/mysql/debian-start[5944]: Version check failed. Got the following error when calling the 'mysql' command line client
Aug 06 19:02:17 myhost.com /etc/mysql/debian-start[5944]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Aug 06 19:02:17 myhost.com /etc/mysql/debian-start[5944]: FATAL ERROR: Upgrade failed
Aug 06 19:02:17 myhost.com /etc/mysql/debian-start[5954]: Checking for insecure root accounts.
Aug 06 19:02:17 myhost.com mariadbd[5927]: 2021-08-06 19:02:17 5 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
Aug 06 19:02:17 myhost.com debian-start[5957]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)Any thoughts about what is going wrong here?