MySQL Forums
Forum List  »  Install & Repo

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.

Options: ReplyQuote


Subject
Written By
Posted
Fail to change default port in 8.0.23
February 04, 2021 07:43PM


Sorry, only registered users may post in this forum.

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.