In Linux, I use my. cnf. mysql does not need to enter the account password to connect to the server.

In Linux, mysql is often used to connect to the server every time:

1. [Root @ localhost ~] # Mysql-hlocalhost-uroot-p11111

Every time I enter the user name, password, and more people, is there a more convenient way?

We only need to simply configure the client section of my. cnf and put the username and password information in the client section. The configuration example is as follows:

1. # The following options will be passed to all MySQL clients
2. 18 [client]
3. 19 host = "localhost"
4. 20 password = "11111"
5. 21 user = "root"
6. 22 port = 3306
7. 23 socket =/tmp/mysql. sock

After modifying my. cnf, you can easily connect to the specified server by running mysql directly without restarting the server.