grant all privileges on adachin-db.* to adachin@’%’ identified by ‘xxxxxxxxx’;

use mysql; UPDATE user SET authentication_string=password(‘新規パスワード’) WHERE user=’root’;

GRANT SELECT ON hoge-db.* to ‘hoge’@’%’ IDENTIFIED BY ‘hogepw’;

# zcat dump.sql.gz | mysql -u root -rootpw db-name

$ grep ‘temporary password’ /var/log/mysqld.log $ mysql_secure_installation change root pass all Y create DB a […]

ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘xxxxx’;

show variables like “chara%”; +————————–+—————————-+ | Variable_name | Valu […]

show variables like “chara%”;

dump $ mysqldump -u root -p -h xxxxxxxxxxxx –skip-lock-tables –single-transaction -v -P xxxxx DB-name table- […]