I want to establish a ‘web-safe’ user for my MySQL database (i.e. one that only has select, create, update and delete permissions). If I drop my web-safe user from the database, I get this error which is totally expected because I have no such user in the database: [error] MyXQL.Connection (#PID<0…

config.exs # This file is responsible for configuring your application # and its dependencies with the aid of the Mix.Config module. # # This configuration file is loaded before any dependency and # is restricted to this project. # General application configuration use Mix.Config config :pcafe, …

MyXQL defaults :username to System.get_env("USER"), but you are explicitly passing :username option so it’s unclear to me what’s going on. What is the system user you’re starting elixir process with? If you could reproduce it in a minimal project please open up an issue in myxql repo and I’ll take a…

I noticed that same thing the other day so I went through the trouble of setting up the same environment variables MyXQL is looking for in their source code (HOST, USER and MYSQL_PWD) , but I thought they were daft names and wanted to use my own. I’ll go back to try using their environment variable…

No luck. I’m now using the environment variables MyXQL is expecting and I still get this error: 12:09:11.664 [error] MyXQL.Connection (#PID<0.405.0>) failed to connect: ** (MyXQL.Error) (1045) (ER_ACCESS_DENIED_ERROR) Access denied for user 'root'@'localhost' (using password: YES)

Note you don’t need to set the environment variables if you are setting the repo configuration. Could you paste the output (without secrets) of: iex> MyApp.Repo.config() ? Also please paste your myxql, ecto, and ecto_sql versions, and make you sure you tried on the latest myxql release (although I…

Well, that didn’t go well. First, I had repo.ex assign the user and password from the environment variables “USER” and “MYSQL_PWD” and when running the app, I got a bevy of errors. I then set the show_sensitive_data_on_connection_error flag to true to see what it was really complaining about. It r…

username: Pcafe.Encrypt.decrypt(System.get_env(prefix<>"_DB_USER_NAME"), secret), if this evaluates to nil, which is my guess, then you’d get the :username is missing error. If that’s the case the error message is arguably a little bit misleading, the username was set it’s just it’s set to nil wh…

That’s exactly what I did (set it in the repo.ex file) and it still wants to connect to the root db user: defmodule Pcafe.Repo do use Ecto.Repo, otp_app: :pcafe, adapter: Ecto.Adapters.MyXQL @doc """ Dynamically loads the repository url from the DATABASE_URL environment varia…

But you bring up a good point - I should add some error trapping in there to ensure that I’m not trying to use nil values!

Elixir Programming Language Forum

Can't connect using a non-root user

Questions & Help Questions

hauleth November 25, 2019, 7:31pm 2

Show us your config files.