mysql - snippets

aizu

CREATE USER 'wp'@'localhost' IDENTIFIED BY '123456789';
GRANT ALL PRIVILEGES ON *.* TO 'wp'@'localhost';

GRANT ALL PRIVILEGES ON *.* TO 'wp'@'localhost' WITH GRANT OPTION;

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

aizu

CREATE USER 'admin'@'localhost' IDENTIFIED BY 'the_secure_password';
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;