Changes

as root, first start mariadb without grant table

as root, first start mariadb without grant table

  systemctl stop mariadb

  systemctl stop mariadb

  /usr/libexec/mysqld --bootstrap --user=mysql --skip-grant-tables

  /usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr --datadir=/var/lib/mysql  --user=mysql --skip-grant-tables

{{warning box| be careful that mariadb will be running without any user auth, if it is open to outside of your server, then you might want to close this access first, and keep this session as short as possible }}

{{warning box| be careful that mariadb will be running without any user auth, if it is open to outside of your server, then you might want to close this access first, and keep this session as short as possible }}

then use mysql command line

then use mysql command line