unable to connect to database, check login_user and login_password are correct or /root/.my.cnf has the credentials

Are you using debian ? Ubuntu ? Which version ?

For debian, this link can explain what is the defaut access :

https://wiki.debian.org/MySql

Regards,

JYL