Fedora Server 36: Where and what is the MySQL configuration/settings file?

Ask Fedora
1

About MySQL, to edit the port number and define the ips to access the server in the same LAN, in Ubuntu is used the /etc/mysql/mysql.conf.d/mysqld.cnf file. I used that file since long time ago, but in Fedora Server 36 what is the equivalent?

Note for both OS, MySQL was installed through the .deb and .rpm files available from the MySQL Community Downloads page

2

Have a look here:

Best would be if you check first in the manual if you could change something for the installation.
To get the updates automatically.

2 Likes
3

Thanks, at User Documentation I did not realize about the Quick Docs section

1 Like
4

Just how an observation - according with the link shared we have:

MySQL           `/etc/my.cnf/`
MySQL Community `/etc/my.cnf.d/community-mysql-server.cnf`
MariaDB         `/etc/my.conf`

If is executed mysql --version appears

mysql Ver 8.0.31 for Linux on x86_64 (MySQL Community Server - GPL)

the Community term appears as you can read, but the /etc/my.cnf.d/ directory is empty, therefore does not exist the community-mysql-server.cnf file ,but exists the /etc/my.cnf/ file

5

In Linux configuration is generally in a /etc/config.conf file stored. Mostly there we do find a default config with all sections and comments to see what they do.

If an app has a .d directory this means you can just make changes for certain part of a config file and name it in a way, to give preference for execution and a description what it does.

A nice example is the file /etc/sudo.conf and the sub-folder sudoers.d
If the system has more than one user it is easy to make some additions and put them in the sudoers.d directory and name it as example as the usersname.

The directory is empty because you not made any changes yet. As explained above, it makes sense that you use the my.cnf as your default config, and put the changes in /etc/my.cnf.d/ . You even can separate them by domainname, webrootname etc.

6

Thanks for the valuable information. Interesting this behavior - huge thanks for your support!

1 Like