【常用命令】mysql

连接mysql

通用版

/usr/local/mysql/bin/mysql -uroot -pyhsj_idc@act -h127.0.0.1 -Ducenter

限制版

/usr/local/mysql/bin/mysql -pyhsj_idc@act -Ducenter -A -h127.0.0.1

开通远程连接权限

grant all privileges on *.* to rooact@'17.107.115.0' identified by 'Yhsj_idc@2019';
flush privileges;