Two Methods for MySQL client to directly connect to the database without entering the user name and password

MySQL client does not enter the user name and password to directly connect to the database. You can test it.

MySQL client does not enter the user name and password to directly connect to the database. You can test it.

There are 2 methods
1. You can modify the configuration parameters of my. ini (my. cnf in linux );
[Quote] [client]
Port = 3306
Default-character-set = utf8
Host = localhost
User = root
Password = 1 [/quote]
You can modify other parameters here.
2. You can modify environment variables.
MYSQL_HOST represents the Host Name
USER is the USER name
MYSQL_PWD is the password
For more parameters, see the mysql help documentation. The following is a table in English.