Otdfbt

Inward extrusion is not working

How to signal to my players that the following part is supposed to be played on fast forward?

Soft question: Examples where lack of mathematical rigour cause security breaches?

Do simulator games use a realistic trajectory to get into orbit?

Where Mongol herds graze

What do abbreviations in movie scripts stand for?

Second (easy access) account in case my bank screws up

Does Disney no longer produce hand-drawn cartoon films?

What is the `some` keyword in SwiftUI?

How can "научись" mean "take it and keep trying"?

How to construct an hbox with negative height?

Cycle through MeshStyle directives in ListLinePlot

What to do when surprise and a high initiative roll conflict with the narrative?

SQL counting distinct over partition

Are there downsides to using std::string as a buffer?

Are there any important biographies of nobodies?

Passing multiple files through stdin (over ssh)

Why would future John risk sending back a T-800 to save his younger self?

Why was the Sega Genesis marketed as a 16-bit console?

What language is software running on the ISS written in?

Is it legal for a bar bouncer to conficaste a fake ID

Motivation - or how can I get myself to do the work I know I need to?

How to forge a multi-part weapon?

Logarithm of exponential

Make changes to MySQL global variables permanent across reboots

MySQL PID changesReplicate MySQL database with “non-permanent” writeMySQL restarted abruptlymysql variable resets after exitmysql changes the IP when connectingMySQL Workbench: Orphaned document changes detectedPowershell script to insert SQL Statement with a apostrophe errorReloading MySQL my.cnf changesMySQL Master migrationMySQL Error: Can't create thread to handle new connection(errno= 11) triggered by many Gunicorn API requests

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

7

2

I'm writing an application that attempts to configure several MySQL servers remotely. Part of this configuration involves setting global MySQL variables using SQL syntax like this:

SET GLOBAL VARIABLE foo=123;

This works well, but it only lasts until the server is restarted. What I would like is a way to make MySQL write these changes to an options (.ini) file, such that they are persistent across machine reboots.

I'm trying to edit the options files without actually opening them directly - I'd prefer to do everything through the MySQL connection.

Does anyone know if this can be done?

mysql

share|improve this question

edited Aug 31 '16 at 23:23

smonff

1982412

asked Sep 30 '10 at 1:52

ThomiThomi

166129

add a comment | 

7

2

I'm writing an application that attempts to configure several MySQL servers remotely. Part of this configuration involves setting global MySQL variables using SQL syntax like this:

SET GLOBAL VARIABLE foo=123;

This works well, but it only lasts until the server is restarted. What I would like is a way to make MySQL write these changes to an options (.ini) file, such that they are persistent across machine reboots.

I'm trying to edit the options files without actually opening them directly - I'd prefer to do everything through the MySQL connection.

Does anyone know if this can be done?

mysql

share|improve this question

edited Aug 31 '16 at 23:23

smonff

1982412

asked Sep 30 '10 at 1:52

ThomiThomi

166129

add a comment | 

I'm writing an application that attempts to configure several MySQL servers remotely. Part of this configuration involves setting global MySQL variables using SQL syntax like this:

SET GLOBAL VARIABLE foo=123;

This works well, but it only lasts until the server is restarted. What I would like is a way to make MySQL write these changes to an options (.ini) file, such that they are persistent across machine reboots.

I'm trying to edit the options files without actually opening them directly - I'd prefer to do everything through the MySQL connection.

Does anyone know if this can be done?

mysql

share|improve this question

edited Aug 31 '16 at 23:23

smonff

1982412

asked Sep 30 '10 at 1:52

ThomiThomi

166129

SET GLOBAL VARIABLE foo=123;

share|improve this question

edited Aug 31 '16 at 23:23

smonff

1982412

asked Sep 30 '10 at 1:52

ThomiThomi

166129

share|improve this question

edited Aug 31 '16 at 23:23

smonff

1982412

asked Sep 30 '10 at 1:52

ThomiThomi

166129

edited Aug 31 '16 at 23:23

smonff

1982412

edited Aug 31 '16 at 23:23

smonff

1982412

asked Sep 30 '10 at 1:52

ThomiThomi

166129

asked Sep 30 '10 at 1:52

ThomiThomi

166129

3 Answers
3

active

oldest

votes

3

set-variable=var_name=value is the classic method to do this in my.cnf. Also, you can specify using flags as --set-variable=var_name=value. Earlier than MySQL 4.0.2, most configuration options were set using this method.

This is depreciated and even removed in MySQL 5.5. Most options can be set using their actual names in the my.cnf. If you need further help, please be more specific.

share|improve this answer

answered Sep 30 '10 at 2:00

WarnerWarner

21.4k24866

add a comment | 

1

To make a global system variable setting permanent, you should set it in an option file: http://dev.mysql.com/doc/refman/5.0/en/option-files.html

share|improve this answer

answered Sep 30 '10 at 2:00

bindbnbindbn

4,66722023

add a comment | 

0

You just can add all the variables to /etc/mysql/conf.d/mysql.cnf file just after [mysqld].

[mysqld]
max_connections=1000
foo=bar

if you found [mysql] replace it with [mysqld]

share|improve this answer

answered May 22 at 0:37

Mahmoud AbdelhamidMahmoud Abdelhamid

1

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f186050%2fmake-changes-to-mysql-global-variables-permanent-across-reboots%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

3

set-variable=var_name=value is the classic method to do this in my.cnf. Also, you can specify using flags as --set-variable=var_name=value. Earlier than MySQL 4.0.2, most configuration options were set using this method.

This is depreciated and even removed in MySQL 5.5. Most options can be set using their actual names in the my.cnf. If you need further help, please be more specific.

share|improve this answer

answered Sep 30 '10 at 2:00

WarnerWarner

21.4k24866

add a comment | 

3

set-variable=var_name=value is the classic method to do this in my.cnf. Also, you can specify using flags as --set-variable=var_name=value. Earlier than MySQL 4.0.2, most configuration options were set using this method.

This is depreciated and even removed in MySQL 5.5. Most options can be set using their actual names in the my.cnf. If you need further help, please be more specific.

share|improve this answer

answered Sep 30 '10 at 2:00

WarnerWarner

21.4k24866

add a comment | 

set-variable=var_name=value is the classic method to do this in my.cnf. Also, you can specify using flags as --set-variable=var_name=value. Earlier than MySQL 4.0.2, most configuration options were set using this method.

This is depreciated and even removed in MySQL 5.5. Most options can be set using their actual names in the my.cnf. If you need further help, please be more specific.

share|improve this answer

answered Sep 30 '10 at 2:00

WarnerWarner

21.4k24866

share|improve this answer

answered Sep 30 '10 at 2:00

WarnerWarner

21.4k24866

answered Sep 30 '10 at 2:00

WarnerWarner

21.4k24866

answered Sep 30 '10 at 2:00

WarnerWarner

21.4k24866

1

To make a global system variable setting permanent, you should set it in an option file: http://dev.mysql.com/doc/refman/5.0/en/option-files.html

share|improve this answer

answered Sep 30 '10 at 2:00

bindbnbindbn

4,66722023

add a comment | 

1

To make a global system variable setting permanent, you should set it in an option file: http://dev.mysql.com/doc/refman/5.0/en/option-files.html

share|improve this answer

answered Sep 30 '10 at 2:00

bindbnbindbn

4,66722023

add a comment | 

To make a global system variable setting permanent, you should set it in an option file: http://dev.mysql.com/doc/refman/5.0/en/option-files.html

share|improve this answer

answered Sep 30 '10 at 2:00

bindbnbindbn

4,66722023

share|improve this answer

answered Sep 30 '10 at 2:00

bindbnbindbn

4,66722023

answered Sep 30 '10 at 2:00

bindbnbindbn

4,66722023

answered Sep 30 '10 at 2:00

bindbnbindbn

4,66722023

0

You just can add all the variables to /etc/mysql/conf.d/mysql.cnf file just after [mysqld].

[mysqld]
max_connections=1000
foo=bar

if you found [mysql] replace it with [mysqld]

share|improve this answer

answered May 22 at 0:37

Mahmoud AbdelhamidMahmoud Abdelhamid

1

add a comment | 

0

You just can add all the variables to /etc/mysql/conf.d/mysql.cnf file just after [mysqld].

[mysqld]
max_connections=1000
foo=bar

if you found [mysql] replace it with [mysqld]

share|improve this answer

answered May 22 at 0:37

Mahmoud AbdelhamidMahmoud Abdelhamid

1

add a comment | 

You just can add all the variables to /etc/mysql/conf.d/mysql.cnf file just after [mysqld].

[mysqld]
max_connections=1000
foo=bar

if you found [mysql] replace it with [mysqld]

share|improve this answer

answered May 22 at 0:37

Mahmoud AbdelhamidMahmoud Abdelhamid

1

[mysqld]
max_connections=1000
foo=bar

share|improve this answer

answered May 22 at 0:37

Mahmoud AbdelhamidMahmoud Abdelhamid

1

answered May 22 at 0:37

Mahmoud AbdelhamidMahmoud Abdelhamid

1

answered May 22 at 0:37

Mahmoud AbdelhamidMahmoud Abdelhamid

1