Tour de Zwift

[PHPmyAdmin] The mbstring extension is missing. Please check your PHP configuration.

The mbstring extension is missing. Please check your PHP configuration.

sudo apt-get install  php-mbstring php-gettext

.home-assistant Error in setting up recorder with MySQL

sudo pip3 install pymysql
sudo pip install mysqlclient
sudo apt-get install libmysqlclient-dev

Mariadb reset root password

mysql --version

sudo systemctl stop mariadb

sudo systemctl set-environment MYSQLD_OPTS="--skip-grant-tables --skip-networking"


sudo systemctl start mariadb


sudo mysql -u root


FLUSH PRIVILEGES;

UPDATE mysql.user SET password = PASSWORD('UMANOVAPASSWORD') WHERE user = 'root';

UPDATE mysql.user SET authentication_string = '' WHERE user = 'root';

UPDATE mysql.user SET plugin = '' WHERE user = 'root';

EXIT



sudo systemctl unset-environment MYSQLD_OPTS

sudo systemctl restart mariadb

sudo systemctl daemon-reload