The/etc/mysql/mysql. Conf. D/mysqld. CNF and/etc/mysql/my CNF difference-CodePudding

modify mysql configuration is commonly is to modify my CNF,, today I in my ubuntu installed mysql 5.7. Ready to configure my CNF found online said configure mysqld. CNF,,,, and I see my my CNF is empty, if I put the mysqld CNF configuration replication to my. The CNF inside is ok, or I directly configure mysqld. CNF to also go, so always feel very strange, two configuration files should be different

CodePudding user response:

Have never met the MySQL DCNF, should is to configure my CNF the original poster can try to know,

CodePudding user response:

My only. CNF
Or you see startup file to read the configuration file

CodePudding user response:

I don't have mysql under/etc, can not find the mysqld. CNF

CodePudding user response:

reference qq_38474729 reply: 3/f

I don't have mysql under/etc, can not find the mysqld. CNF

Not always under/etc.

The/etc/my CNF global options
The/etc/mysql/my CNF global options
SYSCONFDIR/my CNF global options
Specific options. $MYSQL_HOME/my CNF server (server) only
Defaults - extra - file specified file - defaults - extra - file, if any
~/. My. CNF user specific options
~/. Mylogin. CNF login user specific path option (only client)

CodePudding user response:

How do you know the current MySql default configuration files in where?
Find the default configuration file location, perform commands, will display the order of the search configuration file:
Mysql -- help | grep my. CNF

CodePudding user response:

reference 4 floor baidu_36457652 response:

Quote: reference qq_38474729 reply: 3/f

I don't have mysql under/etc, can't find the mysqld. CNF

Not always under/etc.

The/etc/my CNF global options
The/etc/mysql/my CNF global options
SYSCONFDIR/my CNF global options
Specific options. $MYSQL_HOME/my CNF server (server) only
Defaults - extra - file specified file - defaults - extra - file, if any
~/. My. CNF user specific options
~/. Mylogin. CNF login user specific path option (only client)

So, could you please tell me, mysqld CNF

CodePudding user response:

refer to 6th floor qq_38474729 response:

Quote: refer to 4th floor baidu_36457652 response:

Quote: refer to the third floor qq_38474729 response:

I don't have mysql under/etc, can't find the mysqld. CNF

Not always under/etc.

The/etc/my CNF global options
The/etc/mysql/my CNF global options
SYSCONFDIR/my CNF global options
Specific options. $MYSQL_HOME/my CNF server (server) only
Defaults - extra - file specified file - defaults - extra - file, if any
~/. My. CNF user specific options
~/. Mylogin. CNF login user specific path option (only client)

So, excuse me, where's mysqld. CNF

There is no need to match mysqld. CNF

CodePudding user response:

refer to 7th floor baidu_36457652 response:

Quote: refer to the sixth floor qq_38474729 response:

Quote: refer to 4th floor baidu_36457652 response:

Quote: refer to the third floor qq_38474729 response:

I don't have mysql under/etc, can't find the mysqld. CNF

Not always under/etc.

The/etc/my CNF global options
The/etc/mysql/my CNF global options
SYSCONFDIR/my CNF global options
Specific options. $MYSQL_HOME/my CNF server (server) only
Defaults - extra - file specified file - defaults - extra - file, if any
~/. My. CNF user specific options
~/. Mylogin. CNF login user specific path option (only client)

So, excuse me, where's mysqld. CNF

. There is no need to match mysqld CNF of

Is to create mysqld. The CNF file, my/etc/my CNF there are [mysqld] field, whether in writing, or must be mysqld,. CNF

CodePudding user response:

With [mysqld] directly put the server parameters inside

CodePudding user response:

Can you write the actual answer