I have created Droplet and Followed on of the Tutorial to infall LAMP.
However, Please can someone help me to Change the MYSQL Root Password (XXXXXX) as Shown in the MOTD below
I followed this Steps,
Following STEP[1] , I am able to Login phpmyadmin using either of the NEW Password created in STEP[1] Or using the MOTD’s XXXXXXX
Is it Possible to Change this MOTD’s password XXXXX to something else. I thought STEP [1] would help, but unfortunately it doesn’t.
Thank you in advance.
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Now mysql Ver 14.14 Distrib 5.7.27, for Linux (x86_64) using EditLine wrapper I get Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.
even though I’m connected via socket.
This comment has been deleted
This comment has been deleted
Use the mysqladmin command. From the man page: