MySQL access denied for user ‘root’@’localhost’ when creating a new Phoenix project

I am trying to create a new Phoenix project with MySQL as the database. These are the steps I did $ mix phx.new hello –database mysql $ cd hello $ mix ecto.create This is the error I am getting 19:58:16.576 [error] GenServer #PID<0.2485.0> terminating ** (MyXQL.Error) (1045) (ER_ACCESS_DENIED_ERROR) Access denied for user ‘root’@’localhost’ (using password:…

Discover more

MySQL: why is a query using a VIEW less efficient compared to a query directly using the view’s underlying JOIN?

I have three tables, bug, bugrule and bugtrace, for which relationships are: bug 1——–N bugrule id = bugid bugrule 0———N bugtrace id = ruleid Because I’m almost always interested in relations between bug <—> bugtrace I have created an appropriate VIEW which is used as part of several queries. Interestingly, queries using this VIEW have…

Discover more

PHP MySQL How to select 2 specific and 1 common value over 2 tables?

i have here two tables (only the important columns listed) : table1: unique_code(INT), spediteur(VARCHAR also Names), table2: unique_code(INT), versendet(timestamp) I have here a SELECT but that don’t work and if the value is true – that means: just let me into the IF WHEN: spediteur value is Name and versendet = 0000-00-00 00:00:00 and unique_code…

Discover more