We can login into MySql prompt without password from shell using root user .
To configure mysql user prompt without password, open the file ~/.my.cnf file and add the following section.
[client]
user=root
password=password
If you don’t know MySql password,, then simply reset the mysql root user password and define it in above file.
