0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 3 years have passed since last update.

MACでmysqlをDLした後にユーザーを設定せずに出たエラーへの解決

Last updated at Posted at 2020-09-05

mysql を mac なのでHome brewでDLしました。
https://qiita.com/hkusu/items/cda3e8461e7a46ecf25d
ユーザー名の設定をしていなく、mysql.infoschemaと出てしまいました。

image.png

このmysql.infoschemaをpythonに変更しようと、

rename user mysql.infoschema@localhost to python@localhost;

でユーザー名変更しようとしたところ、

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.infoschema@localhost to python@localhost' at line 1

とエラーが出ました。
この場合は、シンプルに新規にユーザー名の変更ではなく、設定を行うとうまく行きました。

ユーザー名の設定
https://qiita.com/YoshitakaOkada/items/f434bb0bc493ff9cd65b#%E3%83%A6%E3%83%BC%E3%82%B6%E4%BD%9C%E6%88%90

0
0
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
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?