mysql5.7免密码登录_MySQL5.7.24无密登陆-.my.cnf

[zabbix@mysqldb02 ~]$ ls -la

total 40

drwx------ 2 zabbix zabbix 159 Jan 16 17:55 .

drwxr-xr-x. 3 root

root

20 Jan 7 15:57 ..

-rw------- 1 zabbix zabbix 9909 Jan 16 17:53

.bash_history

-rw-r--r-- 1 zabbix zabbix

18 Aug 3 2016 .bash_logout

-rw-r--r-- 1 zabbix zabbix 193 Aug 3 2016 .bash_profile

-rw-r--r-- 1 zabbix zabbix 231 Aug 3 2016 .bashrc

-rw-rw-r-- 1 zabbix zabbix

89 Jan 16 17:55 .my.cnf

-rw-rw-r-- 1 zabbix zabbix 215 Jan 16 17:52 .my.cnf.bak

-rw------- 1 zabbix zabbix 172 Jan 16 10:51 .mylogin.cnf

-rw------- 1 zabbix zabbix

52 Jan 16 17:55 .mysql_history

[zabbix@mysqldb02 ~]$ cat .my.cnf

[client]user = 'zabbixmonitor'

password = 'XXdb#x0XX01'

host = 'localhost'

port = 3306[zabbix@mysqldb02 ~]$ mysql

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 10705

Server version: 5.7.24-log MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights

reserved.

Oracle is a registered trademark of Oracle Corporation and/or

its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input

statement.

mysql>