关键字: mysql5.7.20 端口号 linux6
(1): 停止mysql
su - root
# mysql -V
mysql Ver 14.14 Distrib 5.7.20, for linux-glibc2.12 (x86_64) using EditLine wrapper
# service mysqld status
# mysql -u root -P 133067 -h 192.168.134.202 -p
# service mysqld stop
# service mysqld status
(2): 修改配置文件,设置新的端口号
# vi /etc/my.cnf
[client]
port = 13307
socket = /home/db/mysql/product/mysql.sock
[mysql]
init_command = set names utf8mb4
port = 13307
(3): 启动mysql
# service mysqld start
# service mysqld status
# mysql -u root -P 13307 -h 192.168.134.202 -p