What is the default port number of MariaDB?

Question

I am new to programming. I am creating my first Java application that connect to MariaDB. I need to specify the database port number.

score 23 · Accepted Answer · edited Oct 30 '21 at 03:03

23

The default port number of MariaDB is 3306. It is the same as MySQL.

edited Oct 30 '21 at 03:03

Peter Mortensen

30,738
21
105
131

answered Nov 30 '19 at 06:00

Niluka Gunasekara

391
2
3

score 3 · Answer 2 · edited Oct 30 '21 at 02:56

3

The default port number for both MySQL and MariaDB is 3306, but you can change it as required with changing the port variable in the /etc/mysql/mariadb.conf.d/50-server.cnf file (on Debian/Ubuntu) or in the /etc/my.cnf.d/server.cnf (on CentOS/RHEL) and restarting the service ;)

edited Oct 30 '21 at 02:56

Peter Mortensen

30,738
21
105
131

answered Nov 30 '19 at 06:06

Farzaneh Torkpichlou

2,306
3
14
18

1

The "port" line is outcommented by default (presumably means the port number is 3306). – Peter Mortensen Oct 30 '21 at 02:58

score 1 · Answer 3 · edited Oct 30 '21 at 02:59

1

The default port number is 3306, the same as MySQL...if you have a trouble with port, I think you should check the firewall or if you need the remote access you can look at the bind address.

edited Oct 30 '21 at 02:59

Peter Mortensen

30,738
21
105
131

answered Nov 30 '19 at 06:07

JohnPS

11
1

What is the default port number of MariaDB?

3 Answers3

Linked