MySQL启动成功，3306端口没显示

项目场景：

用二进制命令启动MySQL数据库启动成功

[root@mysql8 tmp]# /usr/local/mysql/bin/mysqld_safe --defaults-file=/data/mysql/conf/my.cnf &
[1] 1986
[root@mysql8 tmp]# 2024-04-19T05:00:47.480979Z mysqld_safe Logging to '/data/mysql/log/mysqld.err'.
2024-04-19T05:00:47.510824Z mysqld_safe Starting mysqld daemon with databases from /data/mysql/data

查看端口，没有3306也没33060

[root@mysql8 ~]# ss -ntl
State       Recv-Q Send-Q                Local Address:Port                               Peer Address:Port              
LISTEN      0      10                        127.0.0.1:25                                            *:*                  
LISTEN      0      128                               *:22                                            *:*                  
LISTEN      0      128                            [::]:22                                         [::]:*         

---

问题描述

看错误日志，没任何报错

 tail -f /data/mysql/log/mysqld.err 
2024-04-19T04:58:45.891459Z 0 [System] [MY-010229] [Server] Starting crash recovery...
2024-04-19T04:58:45.891532Z 0 [System] [MY-010232] [Server] Crash recovery finished.
2024-04-19T04:58:45.964717Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-04-19T04:58:45.966625Z 0 [ERROR] [MY-010259] [Server] Another process with pid 1947 is using unix socket file.
2024-04-19T04:58:45.966637Z 0 [ERROR] [MY-010268] [Server] Unable to setup unix socket lock file.
2024-04-19T04:58:45.966661Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-04-19T04:58:47.758667Z 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.12)  MySQL Community Server - GPL.
2024-04-19T05:00:48.042445Z 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.12) starting as process 2715
2024-04-19T05:00:48.364106Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-04-19T05:00:48.372385Z 0 [System] [MY-010931] [Server] /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.12'  socket: '/data/mysql/tmp/mysqld.sock'  port: 0  MySQL Community Server - GPL.

---

原因分析：

有一次忘记MySQL密码，在配置文件加了一行skip-grant-tables，没有修改回去

---

解决方案：

确保密码改了的情况下，把skip-grant-tables这行注释或者删掉，重启MySQL

ps -ef|grep mysql

找到MySQL的pid，kill掉
重新启动命令

/usr/local/mysql/bin/mysqld_safe --defaults-file=/data/mysql/conf/my.cnf &

成功

[root@mysql8 ~]# ss -ntl
State       Recv-Q Send-Q                Local Address:Port                               Peer Address:Port              
LISTEN      0      10                        127.0.0.1:25                                            *:*                  
LISTEN      0      128                               *:22                                            *:*                  
LISTEN      0      70                             [::]:33060                                      [::]:*                  
LISTEN      0      128                            [::]:3307                                       [::]:*                  
LISTEN      0      128                            [::]:22                                         [::]:*               

3306显示，3307是我指定的
无错误日志

[root@mysql8 ~]# tail -f /data/mysql/log/mysqld.err 
2024-04-19T06:29:43.479721Z 0 [Warning] [MY-010315] [Server] 'user' entry 'mysql.infoschema@localhost' ignored in --skip-name-resolve mode.
2024-04-19T06:29:43.479853Z 0 [Warning] [MY-010315] [Server] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
2024-04-19T06:29:43.479890Z 0 [Warning] [MY-010315] [Server] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2024-04-19T06:29:43.479899Z 0 [Warning] [MY-010315] [Server] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
2024-04-19T06:29:43.480064Z 0 [Warning] [MY-010323] [Server] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
2024-04-19T06:29:43.480112Z 0 [Warning] [MY-010323] [Server] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2024-04-19T06:29:43.480163Z 0 [Warning] [MY-010311] [Server] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2024-04-19T06:29:43.483320Z 0 [Warning] [MY-010330] [Server] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
2024-04-19T06:29:43.483336Z 0 [Warning] [MY-010330] [Server] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
2024-04-19T06:29:43.497110Z 0 [System] [MY-010931] [Server] /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.12'  socket: '/data/mysql/tmp/mysqld.sock'  port: 3307  MySQL Community Server - GPL.