horitaku1124/mysql-setup.md

Last active January 16, 2023 06:06

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/horitaku1124/53c23d6a459efcbd1e9a0f1805669dc6.js"></script>
Save horitaku1124/53c23d6a459efcbd1e9a0f1805669dc6 to your computer and use it in GitHub Desktop.

Raw

CREATE DATABASE dabase_name CHARACTER SET utf8mb4;

create user 'mysql_user'@'localhost' identified by 'mysql_user_password';

GRANT ALL PRIVILEGES ON dabase_name.* to mysql_user@localhost IDENTIFIED BY 'mysql_user_password';

MySQL8では IDENTIFIED BY は使えない