G
G
gingerose2021-03-04 02:09:05
MySQL
gingerose, 2021-03-04 02:09:05

Why port = 0 in mysql and how to fix it?

I installed mysql on the centos virtual machine (for remote connection), but for some reason it gives out a zero port, I tried to change my.cnf but unfortunately the port did not change

mysql> show variables like 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port          | 0     |
+---------------+-------+
1 row in set (0.00 sec)

If anyone has come across please let me know. Thanks in advance

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Alexey Dmitriev, 2021-03-04
@SignFinder

Option 1 - offline mode is enabled. Can be viewed via "SHOW VARIABLES LIKE 'skip_networking';" - if in On, then look for - where it is included.
Option 2 - there are additional configuration files - in /etc/mysql.d, in /root, etc.
Bitrix, for example, has its own directory with configuration files in etc.

V
Vitaly Karasik, 2021-03-04
@vitaly_il1

Show me your my.cnf

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question