Open mKay00 opened 4 years ago
Mysql returns "Access denied for user" when authentication plugin is wrong. Mobius uses mysql_native_password as authentication plugin.
Check authentication plugin of mysql account.
SELECT user,plugin,host FROM mysql.user;
Hi, I used also the Mobius_Docker and got the same error. connecting to mysql account , I checked the plugin is mysql_native_password. Could you please help ? Thanks.
@lovele0107
Try flush privileges;
Hi .
I went to mysql using command: sudo docker exec -it mobius_docker_db_1 mysql -u root -p
then I have tried : flush privileges, but it does not solve the issue.
Same for me. I checked the authentication plugin and tried flush privileges
. The plugins are mysql_native_password:
and flush privileges
shows OK:
But I still get access denied
afterwards, when I docker-compose up
edit: When I use docker-compose up
, it says Recreating mobius_docker_db_1
, does this mean that the flush privileges
doesn't have an effect, because it always creates a new image? If so, what would be the correct way to do this?
I installed Mobius Docker and got a same result. I found that mysql on mobius_docker_db_1 does not have any table.
@mKay00 @lovele0107
I found the cause. IoTKETI removed sql directory from Mobius but Mobius_Docker still uses it.
Enter
mkdir sql
cp ./mobius/mobiusdb.sql ./sql/mobiusdb.sql
after Mobius_Docker Installation step 4.
It will works well.
P.S. MySQL stll returns access denied error, but I don't know who try to access.
HI , I confirm it is working now. The rights of the sql file would need to be changed in order to be in the same user group. ( or do not use sudo for copying the sql file) Thank you very much for your prompt reply to this issue.
Thank you, although I am still getting Access denied for user 'root'@'localhost'
, it works now.
@mKay00 I found the cause. healthcheck command of Mobius_Docker is wrong.
Command should include password.
Change line 18 of docker-compose.yml in Mobius Docker from
test: ["CMD", "mysqladmin" ,"ping", "-h", "localhost"]
to
test: ["CMD", "mysqladmin" , "--password=dksdlfduq2","ping", "-h", "localhost"]
I used Mobius_Docker, but I can't get it to work. When it's started, I get repeatedly the following output
Since the message says
database error
, I looked what the database does and at the end of the database setup it saysSo, I am wondering how I could fix the issue. I already tried it on another PC, on Linux and Windows and also followed the steps for manual installation from the installation guide. I always get a database error. I also tried different solutions I found on the internet for the Access denied error, but nothing seems to work for me.
I would really appreciate some help here, since I ran out of options to try.
The version of MySQL is 5.7.28.