sudo apt update
\nsudo apt upgrade -y<\/p>\n
sudo apt install mariadb-server -y<\/p>\n
sudo systemctl status mariadb<\/p>\n
sudo systemctl start mariadb<\/p>\n
sudo systemctl enable mariadb<\/p>\n
sudo mysql_secure_installation<\/p>\n
sudo mysql<\/p>\n
CREATE DATABASE mydb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
\nCREATE USER ‘myuser’@’localhost’ IDENTIFIED BY ‘mypassword’;
\nGRANT ALL PRIVILEGES ON mydb.* TO ‘myuser’@’localhost’;
\nFLUSH PRIVILEGES;<\/p>\n
GRANT CREATE, CREATE USER ON *.* TO ‘myuser’@’localhost’;
\nFLUSH PRIVILEGES;<\/p>\n
GRANT ALL PRIVILEGES ON *.* TO ‘myuser’@’localhost’ WITH GRANT OPTION;
\nFLUSH PRIVILEGES;<\/p>\n","protected":false},"excerpt":{"rendered":"
sudo apt update sudo apt upgrade -y sudo apt install mariadb-server -y sudo systemctl status mariadb sudo systemctl start mariadb sudo systemctl enable mariadb sudo mysql_secure_installation sudo mysql CREATE DATABASE mydb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; CREATE USER ‘myuser’@’localhost’ IDENTIFIED BY ‘mypassword’; GRANT ALL PRIVILEGES ON mydb.* TO ‘myuser’@’localhost’; FLUSH PRIVILEGES; GRANT CREATE, CREATE USER […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-25","post","type-post","status-publish","format-standard","hentry","category-15"],"_links":{"self":[{"href":"https:\/\/wiki.rollyk.ru\/index.php?rest_route=\/wp\/v2\/posts\/25","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wiki.rollyk.ru\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wiki.rollyk.ru\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wiki.rollyk.ru\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wiki.rollyk.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=25"}],"version-history":[{"count":1,"href":"https:\/\/wiki.rollyk.ru\/index.php?rest_route=\/wp\/v2\/posts\/25\/revisions"}],"predecessor-version":[{"id":26,"href":"https:\/\/wiki.rollyk.ru\/index.php?rest_route=\/wp\/v2\/posts\/25\/revisions\/26"}],"wp:attachment":[{"href":"https:\/\/wiki.rollyk.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=25"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wiki.rollyk.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=25"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wiki.rollyk.ru\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=25"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}