修改MySQL連接埠後重啟不了

標籤：size   for   bsp   links   root   重啟   read   /etc   inno   

 

修改MySQL連接埠為13306

vim /etc/my.cnf

[mysqld]
port=13306
lower_case_table_names=1

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

 

/etc/init.d/mysqld start
MySQL Daemon failed to start.
Starting mysqld:　　　　　　 [FAILED]

日誌報錯

180402 13:07:25 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
180402 13:13:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
180402 13:13:19 InnoDB: Initializing buffer pool, size = 8.0M
180402 13:13:19 InnoDB: Completed initialization of buffer pool
180402 13:13:19 InnoDB: Started; log sequence number 0 44233
180402 13:13:19 [ERROR] Can‘t start server: Bind on TCP/IP port: Permission denied
180402 13:13:19 [ERROR] Do you already have another mysqld server running on port: 13306 ?
180402 13:13:19 [ERROR] Aborting

180402 13:13:19 InnoDB: Starting shutdown...
180402 13:13:24 InnoDB: Shutdown completed; log sequence number 0 44233
180402 13:13:24 [Note] /usr/libexec/mysqld: Shutdown complete

1.解決辦法

vim /etc/sysconfig/iptables

-A INPUT -m state --state NEW -m tcp -p tcp --dport 13306 -j ACCEPT

 第一種方法是開放外網連接埠，第二種方式用於本地啟動；

不寫防火牆策略，無法遠端存取資料庫

2.關閉 SELinux問題

方法一： 不需要重啟Linux:
 [[email protected] ~]# setenforce 0

 方法二：需要重啟Linux:
vi /etc/selinux/config

SELINUX=disabled

修改MySQL連接埠後重啟不了