WordPressのDB作成
$ grep ‘temporary password’ /var/log/mysqld.log $ mysql […]
Category : MySQL
Articles
[Ubuntu]MySQLのrootパスを変更
ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_nat […]
[MySQL]既存DBの文字コードをutf8mb4に変更する
show variables like “chara%”; +———————— […]
[MySQL]文字コードの確認
show variables like “chara%”;
DBのdumpとrestore
dump $ mysqldump -u root -p -h xxxxxxxxxxxx –skip-lock […]