MySQLコマンドやSQL文に関する各種メモ書き

MySQL8.0ではGRANT構文でユーザを作成できない

引用元 : MySQL8.0ではGRANT構文でユーザを作成できない – guro_chanの手帳

grant all on *.* to 'guro'@'localhost' identified by 'avava' with grant option;

            ↓

create user 'guro'@'localhost' identified by 'avava';
grant all on *.* to 'guro'@'localhost' with grant option;
flush privileges;
No.2335
05/05 19:45

edit