log in to MySql server without password

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.

Be Sociable, Share!