Answer the question
In order to leave comments, you need to log in
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)
Answer the question
In order to leave comments, you need to log in
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.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question