connecting to a local database server
Hello friends!
Could someone help me please about reconnecting to my local database server ?
I am attempting to connect to a local database server of my website https://wakawaka-afrobar.com/ which is already online and running.
But I'm having this message:
The authenticity of host 'localhost (127.0.0.1)' can't be established.
ED25519 key fingerprint is SHA256:jNmEbDWNCP1dYW4+s/KYRiydz6uMV8XWxf+z8VlPJrI.
This key is not known by any other names
Are you sure you want to continue connecting (yes/no/[fingerprint])? yes
Warning: Permanently added 'localhost' (ED25519) to the list of known hosts.
wakawakadatabase2admin@localhost's password:
Permission denied, please try again.
It seems that the password I provided for the user 'wakawakadatabase2admin' was incorrect, as it returned a "Permission denied" error. However, in this case, I am sure about the password I used to loging.
Thank you for your help!
1 Reply
I am attempting to connect to a local database server of my website https://wakawaka-afrobar.com/ which is already online and running.
But I'm having this message:
The authenticity of host 'localhost (127.0.0.1)' can't be established.
ED25519 key fingerprint is SHA256:jNmEbDWNCP1dYW4+s/KYRiydz6uMV8XWxf+z8VlPJrI.
This key is not known by any other names.
Are you sure you want to continue connecting (yes/no/[fingerprint])? yes
Warning: Permanently added 'localhost' (ED25519) to the list of known hosts.
wakawakadatabase2admin@localhost's password:
Permission denied, please try again.
You're attempting to connect using ssh. What you need to do is set up a public/private key-pair for wakawakadatabase2admin (assuming that's not your username) and install the public key in $HOME/.ssh/authorized_keys. This will eliminate the need for a password in this process altogether.
See: https://serverfault.com/questions/323958/how-do-you-create-an-ssh-key-for-another-user
-- sw
P.S. Use RSA or ED25519 keys (the -t option on ssh-keygen)…not DSA keys (as one of the examples in the above link shows):
https://security.stackexchange.com/questions/5096/rsa-vs-dsa-for-ssh-authentication-keys