Fail to change default port in 8.0.23
Posted by:
CW Cheung
Date: February 04, 2021 07:43PM
Using community version 8.0.23 and tried to change default port by modify the /etc/my.cnf file.
#socket=/var/lib/mysql/mysql.sock <-commented
port=12345 <-added
Then start up "systemctl start mysqld" resulted in error.
The /var/log/mysqld.log shows the following message.
2021-02-05T01:10:02.751572Z 0 [ERROR] [MY-010262] [Server] Can't start server: Bind on TCP/IP port: Permission denied
2021-02-05T01:10:02.751747Z 0 [ERROR] [MY-010257] [Server] Do you already have another mysqld server running on port: 12345 ?
2021-02-05T01:10:02.752103Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-02-05T01:10:04.139671Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23) MySQL Community Server - GPL.
Subject
Written By
Posted
Fail to change default port in 8.0.23
February 04, 2021 07:43PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.