beedoc
beedoc copied to clipboard
bee migrate not working:Could not show migrations table: The authentication plugin is not supported
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
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 ..
please read the doc https://beego.me/docs/install/bee.md
you should pass the connection parameter