Hello everyone, Anyone having success using mariaex with mysql 8.0.x? There is an open issue , but adding to my.cnf … [mysqld] default-authentication-plugin=mysql_native_password … does not solve the problem. I still got this error when trying to create the repo. 12:27:42.618 [error] GenServer #…

Could you check what’s the authentication plugin for the user you’re trying to log in as? E.g.: mysql> select user,plugin from mysql.user; +------------------+-----------------------+ | user | plugin | +------------------+-----------------------+ | mariaex_user | mys…

That was it… droping the user, and recreate allows me to create the Repo :slight_smile: Thank You @wojtekmach

Hi, I’ve read the issue on GitHub and the previous comments of this thread, but this is still not working for me. Also I can’t really understand what the solution suggested in the comments above was. Should the plugin be changed to caching_sha2_password? Or to mysql_native_password? What worked? A…

You should use mysql_native_password, if You did wrong, as I did, just drop the user and recreate. BTW I did not use root, but elixir… and configured config files with this user. How do You create your user?

Hi, thanks for getting back to this. The user was created ages ago when MySQL was first installed on this dev machine. Yesterday I upgraded MySQL to 8.0 and I ran the mysql upgrade command. Mariaex t was connecting fine before that. I have already dropped and recreated 'root'@'localhost', but it d…

Is the host you connect from recognized as localhost? Maybe its bare IP or mylaptop.local. I have no clue how MySQL does this host thing. If I were you, I’d alter all users. Or explicitely create a non root user for the application, that has known to work settings.

As mentionned in the OP, the issue is related to MySQL 8.x If You have recently upgraded, then You need to change the auth settings, and recreate users.

I think the syntax is mysql> CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password'; mysql> GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'localhost'; mysql> FLUSH PRIVILEGES; The second command gives rights… You might change newuser password ALL *.*

Thanks @kokolegorille . I’ve now tried again and I’ve run exactly those commands, creating a new user. I’ve then configured Ecto with the new username, deleted the compiled beam artifacts from _build, and then tried again. I am still getting the same error: ** (Mariaex.Error) (1251): Client does n…

I’ve resolved by downgrading to MySQL 5.7. Mariaex with MySQL 8.0 was just not working.

Elixir Programming Language Forum

Mariaex mysql 8+

Questions & Help Questions

kokolegorille October 14, 2018, 6:06pm 4

That was it…

droping the user, and recreate allows me to create the Repo

Thank You @wojtekmach