search

sudara / alonetone

A free, open source, non-commercial home for musicians and their music
https://alonetone.com
MIT License
346 stars 89 forks source link

stuck on rake setup #1148

Closed jlmitch5 closed 2 years ago

jlmitch5 commented 2 years ago

When running rake setup, I get

Mysql2::Error::ConnectionError: Access denied for user 'jmitchel'@'localhost' (using password: NO)

so I did

$ mysql start $ mysql -u root -h localhost -p

and then

CREATE USER 'jmitchel'@'localhost' IDENTIFIED BY 'NO'; GRANT ALL PRIVILEGES ON . TO 'jmitchel'@'localhost';

$ exit

and then tried again.

It seems I can log in using

$ mysql -u jmitchel -h localhost -p

and then typing NO in the password prompt, so I'm not sure why the rake setup is still failing for me.

Side-note that this is not documented in contrib and probably should be

jlmitch5 commented 2 years ago

Ah so NO != 'NO' 😅

closing this. I'll open up a pr to contrib about the step

sudara commented 2 years ago

Howdy! Nice to see you here!

using password: NO means that no password was supplied to mysql. It's often default for localhost mysql setups (and how I have things setup locally) to use the root user without a password.

This is also the assumption that the database.yml makes (I believe it's still the assumption rails itself makes), so if you want to use a different user, you'll have to edit the database.yml.

You could hop into the discord https://discord.gg/tvQbf7Ra if you run into further issues or want to chat about things.