Este blog é como um sótão....um local para guardar... Links Textos etc... Tudo o que um dia poderá fazer falta.
quinta-feira, fevereiro 14, 2019
terça-feira, fevereiro 05, 2019
[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
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
sudo pip install mysqlclient
sudo apt-get install libmysqlclient-dev
segunda-feira, fevereiro 04, 2019
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
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