LoginSignup
10
5

More than 3 years have passed since last update.

MYSQLでユーザー作成が出来ない方対象!(ERROR 1290 (HY000):~)

Last updated at Posted at 2020-01-16
mysql> CREATE USER dbuser@'localhost' IDENTIFIED BY 'test';

ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

見かけないエラー文が表示されて困りました・・・
しかし、調べたらすぐに解決したので共有させて頂きます。

解決方法

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> CREATE USER dbuser@'localhost' IDENTIFIED BY 'test';
Query OK, 0 rows affected (0.03 sec)

これだけで無事解決しました。

10
5
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
10
5