When do MySQL DBA need root accessHow do you gain access to embedded MySQL database via localhost command...
Is the percentage symbol a constant?
What is an efficient way to digitize a family photo collection?
Minimum Viable Product for RTS game?
Disk space full during insert, what happens?
Is the tritone (A4 / d5) still banned in Roman Catholic music?
filecontents: select rows of group to display
Words of Worship and Nefarious Lich
In the Lost in Space intro why was Dr. Smith actor listed as a special guest star?
Taking an academic pseudonym?
If I tried and failed to start my own business, how do I apply for a job without job experience?
Coworker is trying to get me to sign his petition to run for office. How to decline politely?
Is it possible to methodically find the total of ways to read a given phrase making a stack?
two subject complements in passive form?
If we can’t finish all tasks, does this mean we are doing Scrum wrong?
Including proofs of known theorems in master's thesis
How do I narratively explain how in-game circumstances do not mechanically allow a PC to instantly kill an NPC?
Does Plato's "Ring of Gyges" have a corrupting influence on its wearer?
Color of alien seas
In a post apocalypse world, with no power and few survivors, would Satnav still work?
Can you help me solve this algebra problem?
Expression for "unconsciously using words (or accents) used by a person you often talk with or listen to"?
How do I make my single-minded character more interested in the main story?
Crack the bank account's password!
When does a person lose diplomatic status?
When do MySQL DBA need root access
How do you gain access to embedded MySQL database via localhost command line?Cannot change root access in MySQL to %Recovering MySQL root password (XAMPP)Run MySQL client as user without user's password if have root accessDeleted MySQL “root” user (using phpMyAdmin)…how to restore?Setting root password in fresh mysql 5.7 installationAssign root user password after installationWhat is the proper way to assign the privileges when a MySQL instance has multi dba?Cannot reset MySQL default root password after initial installationpt-kill - how to securely allow access to mysql server when running as service
For a MySQL DBA, what operations require root access. I know that we need to be root for installation, starting and stopping services. With DBA’s not having root access, is there a way to perform majority of the operations?
mysql
edited May 16 '16 at 17:51
Andriy M
16.1k63373
asked May 16 '16 at 16:35
DJ1415DJ1415
161
bumped to the homepage by Community♦ 3 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
For a MySQL DBA, what operations require root access. I know that we need to be root for installation, starting and stopping services. With DBA’s not having root access, is there a way to perform majority of the operations?
mysql
edited May 16 '16 at 17:51
Andriy M
16.1k63373
asked May 16 '16 at 16:35
DJ1415DJ1415
161
bumped to the homepage by Community♦ 3 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
For a MySQL DBA, what operations require root access. I know that we need to be root for installation, starting and stopping services. With DBA’s not having root access, is there a way to perform majority of the operations?
mysql
edited May 16 '16 at 17:51
Andriy M
16.1k63373
asked May 16 '16 at 16:35
DJ1415DJ1415
161
For a MySQL DBA, what operations require root access. I know that we need to be root for installation, starting and stopping services. With DBA’s not having root access, is there a way to perform majority of the operations?
mysql
mysql
edited May 16 '16 at 17:51
Andriy M
16.1k63373
asked May 16 '16 at 16:35
DJ1415DJ1415
161
edited May 16 '16 at 17:51
Andriy M
16.1k63373
asked May 16 '16 at 16:35
DJ1415DJ1415
161
edited May 16 '16 at 17:51
Andriy M
16.1k63373
edited May 16 '16 at 17:51
Andriy M
16.1k63373
edited May 16 '16 at 17:51
Andriy M
16.1k63373
16.1k63373
asked May 16 '16 at 16:35
DJ1415DJ1415
161
asked May 16 '16 at 16:35
DJ1415DJ1415
161
asked May 16 '16 at 16:35
DJ1415DJ1415
161
161
bumped to the homepage by Community♦ 3 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 3 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Basically the mysqld is started as mysql user (in the init script is something like su mysql). Therefore there is no other option beside having access to this user.
But you can setup your system to run mysqld as a normal user.
answered Aug 24 '16 at 19:58
s.meissners.meissner
418
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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
});
}
});
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f138645%2fwhen-do-mysql-dba-need-root-access%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Basically the mysqld is started as mysql user (in the init script is something like su mysql). Therefore there is no other option beside having access to this user.
But you can setup your system to run mysqld as a normal user.
answered Aug 24 '16 at 19:58
s.meissners.meissner
418
add a comment |
Basically the mysqld is started as mysql user (in the init script is something like su mysql). Therefore there is no other option beside having access to this user.
But you can setup your system to run mysqld as a normal user.
answered Aug 24 '16 at 19:58
s.meissners.meissner
418
add a comment |
Basically the mysqld is started as mysql user (in the init script is something like su mysql). Therefore there is no other option beside having access to this user.
But you can setup your system to run mysqld as a normal user.
answered Aug 24 '16 at 19:58
s.meissners.meissner
418
Basically the mysqld is started as mysql user (in the init script is something like su mysql). Therefore there is no other option beside having access to this user.
But you can setup your system to run mysqld as a normal user.
answered Aug 24 '16 at 19:58
s.meissners.meissner
418
answered Aug 24 '16 at 19:58
s.meissners.meissner
418
answered Aug 24 '16 at 19:58
s.meissners.meissner
418
answered Aug 24 '16 at 19:58
s.meissners.meissner
418
418
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f138645%2fwhen-do-mysql-dba-need-root-access%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
