...
sudo systemctl restart postgresql
Инсталляция MySql (Ubuntu)
Code Block |
---|
sudo apt update
sudo apt upgrade
sudo apt install mysql-server
sudo mysql_secure_installation |
Смотрим еще эту инструкцию: https://stackoverflow.com/questions/51803216/lower-case-table-names-settings-in-mysql-8-0-12
Заходим в MySql:
sudo mysql
SET GLOBAL validate_password.policy=LOW;
alter user 'root'@'localhost' identified by '7qaskfhb&#!823DD';
create database demo;
CREATE USER 'mystorage'@'localhost' identified by 'mystorage';
GRANT ALL PRIVILEGES ON demo.* To 'mystorage'@'localhost';
exit
mysql -u root -p demo < demo_dump.sql