beedoc icon indicating copy to clipboard operation
beedoc copied to clipboard

bee migrate not working:Could not show migrations table: The authentication plugin is not supported

Open kenji-iiii opened this issue 6 years ago • 3 comments

bee migrate

$ bee migrate
______
| ___ \
| |_/ /  ___   ___
| ___ \ / _ \ / _ \
| |_/ /|  __/|  __/
\____/  \___| \___| v1.10.0
2019/04/12 22:57:37 INFO     ▶ 0001 Using 'mysql' as 'driver'
2019/04/12 22:57:37 INFO     ▶ 0002 Using 'root:root@tcp(127.0.0.1:3306)/test' as 'conn'
2019/04/12 22:57:37 INFO     ▶ 0003 Running all outstanding migrations
2019/04/12 22:57:37 FATAL    ▶ 0004 Could not show migrations table: The authentication plugin is not supported.

mysql

mysql> SELECT user, host, plugin FROM mysql.user;
+------------------+-----------+-----------------------+
| user             | host      | plugin                |
+------------------+-----------+-----------------------+
| mysql.infoschema | localhost | mysql_native_password |
| mysql.session    | localhost | mysql_native_password |
| mysql.sys        | localhost | mysql_native_password |
| root             | localhost | mysql_native_password |
| testuser         | localhost | caching_sha2_password |
+------------------+-----------+-----------------------+
5 rows in set (0.00 sec)

Your MySQL connection id is 81 Server version: 8.0.15 MySQL Community Server - GPL

kenji-iiii avatar Apr 12 '19 14:04 kenji-iiii

i have same issue. when change data on app.conf

#数据库配置
mysqluser = "yogithesymbian"
mysqlpass = "yogiarifwidodo"

the error is access denied blabla 'root@localhost` so thats mean configuration is not set my user , i have tried with root user still doesnt work, when i trying with other user, the error is same , so why my app.conf didnt set on config ?

edit[1] ah my bad

2021/07/13 19:06:01 FATAL    ▶ 0004 Could not show migrations table: Error 1045: Access denied for user 'root'@'localhost' (using password: NO)

i have read on could not show i think it same issue , sorry ..

yogithesymbian avatar Jul 13 '21 11:07 yogithesymbian

please read the doc https://beego.me/docs/install/bee.md

flycash avatar Jul 16 '21 16:07 flycash

you should pass the connection parameter

flycash avatar Jul 16 '21 16:07 flycash