How to access MySQL without password from command line?

[Dipak Bhoi]

Hello folks,

Here are tricks to access MySQL as root without password.

Trick 1 : Create a file .my.cnf under /root directory and add the credentials there as below.

[client]
user=root
password="password"

Trick 2 : Open a mysql configuration file /etc/my.cnf and add below line in it.

skip-grant-tables

Save the file and restart the mysql service.

#/etc/init.d/mysql restart

Hope this post will like you..

Enjoy !!