mysql - snippets

[aizu]

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