How can I change mysql port from 0 to 3306?

Question

I find it hard to establish a link between JDBC and MySQL. I think one of the reasons is the mysql port. I checked the port with the statement: show variables like 'port'; in mysql. And the response is:

+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port          | 0     |
+---------------+-------+
1 row in set (0.07 sec)

My operating system is archlinux. How can I change mysql port from 0 to 3306?

I have changed the port number in both /etc/my.cnf and /etc/mysql/my.cnf. But it didn't work.

Answer 1

First of all check what SHOW VARIABLES LIKE 'skip_networking'; if it reports skip_networking = On, your mysqld is started without networking support (which leads to an value of 0 in the port system variable).

If this is the case, you most likely have to check the init scripts for your mysqld, its most likely under /etc/init.d/mysql, search here for --skip-networking and comment out (delete) this part. After this procedure you have to restart your mysqld.

Normaly there is no need to set the port 3306 explicitly since 3306 is the default port for mjysqld to listen on.