sudo journalctl -b |grep mysqlįeb 04 17:54:39 mydebian mysqld: 17:54:39 0 /usr/sbin/mysqld (mysqld 10.3.27-MariaDB-0+deb10u1) starting as process 690. It is the proper way to make the mysql as the unix root user and be authenticated with CREATE USER IDENIFIED VIA unix_socket Issue remains ,booting log is the same as before,maybe the reason is that auto upgrade script executed with root at the booting,it is no related with new created user showkey. It is my turn to solve the issue,which is the best-make or disable mysql auto upgrade in the booting stage?How to help mysql auto-upgrade then? I display all action mysql try to take during os booting stage everytime,mysql try to upgrade but failed.

Got the following error when calling the 'mysql' command line clientįeb 04 13:05:42 mydebian /etc/mysql/debian-start: ERROR 1045 (28000): Access denied for user (using password: NO)įeb 04 13:05:42 mydebian /etc/mysql/debian-start: FATAL ERROR: Upgrade failedįeb 04 13:05:42 mydebian /etc/mysql/debian-start: Checking for insecure root accounts.

įeb 04 13:05:35 mydebian mysqld: 13:05:35 0 Could not increase number of max_open_files to more than 16384 (request: 32184)įeb 04 13:05:41 mydebian /etc/mysql/debian-start: Upgrading MySQL tables if necessary.įeb 04 13:05:42 mydebian /etc/mysql/debian-start: /usr/bin/mysql_upgrade: the '-basedir' option is always ignoredįeb 04 13:05:42 mydebian /etc/mysql/debian-start: Looking for 'mysql' as: /usr/bin/mysqlįeb 04 13:05:42 mydebian /etc/mysql/debian-start: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheckįeb 04 13:05:42 mydebian /etc/mysql/debian-start: Version check failed. I find that mysql always try to auto-upgrade in the booting stage: sudo journalctl -b -l | grep mysqlįeb 04 13:05:35 mydebian mysqld: 13:05:35 0 /usr/sbin/mysqld (mysqld 10.3.27-MariaDB-0+deb10u1) starting as process 713.

Mysql debian 11