mysql - snippets
-
CREATE USER 'wp'@'localhost' IDENTIFIED BY '123456789'; GRANT ALL PRIVILEGES ON *.* TO 'wp'@'localhost'; ALTER USER 'root'@'localhost' IDENTIFIED BY '123456789'; FLUSH PRIVILEGES; CREATE DATABASE wordpress; ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password by '11112222'; UPDATE users SET password='dsdsdsd' WHERE email = '[email protected]';
su - mysql -s /bin/sh -c "/usr/bin/mysqld_safe" /usr/bin/mysqld_safe --defaults-file=/etc/mysql/my.cnf