SSH Not Connecting


@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@    WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED!     @
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
IT IS POSSIBLE THAT SOMEONE IS DOING SOMETHING NASTY!
Someone could be eavesdropping on you right now (man-in-the-middle attack)!
It is also possible that a host key has just been changed.
The fingerprint for the ECDSA key sent by the remote host is
SHA256:xxxxxxxxxxxxxxxxx/+xxxxxxxxxxxxxxxxxxxx.
Please contact your system administrator.
Add correct host key in $PATH to get rid of this message.
Offending ECDSA key in $PATH
ECDSA host key for 192.168.XXX.XXX has changed and you have requested strict checking.
Host key verification failed.

This means there is a deadlock here. This one is marked duplicate so no one can add answer
 and the one it links is marked off topic so no can add answer there as well. If you delete
the known_hosts, it will fix the issue as well.If you ever face this problem in SSH then you
need to put this command

$ ssh-keygen -R <host>
i.e. ssh-keygen -R 192.168.XXX.XXX

That's it.

Install phpmyadmin

 Install phpmyadmin

$    sudo apt install phpmyadmin

$    mysql -u root -p

mysql> show databases;

mysql> create database database1;     "write any name instead of database1"

mysql> select user,host,plugin from mysql.user;

mysql> create user 'xxxx'@'localhost' identified by '*******(passwordkey)'

if you forgot to put password then use

ALTER USER xxx@localhost identified by '****';

mysql> grant all privileges on *.* to 'xxxx'@'localhost';

mysql> update user set plugin="auth_socket" where User='xxxx';

mysql> flush privileges;

mysql>exit