Getting credentials from mysql db“Set Password” with a limited userImport csv data from localhost emacs...
What do the Banks children have against barley water?
Extreme, but not acceptable situation and I can't start the work tomorrow morning
Patience, young "Padovan"
Calculate Levenshtein distance between two strings in Python
Is there a familial term for apples and pears?
How could a lack of term limits lead to a "dictatorship?"
Why did the Germans forbid the possession of pet pigeons in Rostov-on-Don in 1941?
How would photo IDs work for shapeshifters?
Does a dangling wire really electrocute me if I'm standing in water?
How to manage monthly salary
Is a vector space a subspace?
Doomsday-clock for my fantasy planet
Email Account under attack (really) - anything I can do?
Can I legally use front facing blue light in the UK?
Is it wise to focus on putting odd beats on left when playing double bass drums?
Is there a name of the flying bionic bird?
Is there a way to make member function NOT callable from constructor?
What to wear for invited talk in Canada
Add an angle to a sphere
What is it called when one voice type sings a 'solo'?
What does 'script /dev/null' do?
Can the Produce Flame cantrip be used to grapple, or as an unarmed strike, in the right circumstances?
Finding files for which a command fails
Are objects structures and/or vice versa?
Getting credentials from mysql db
“Set Password” with a limited userImport csv data from localhost emacs SQLi error MySQLProblem with new MySQL Workbench connectionTo give a user all privileges except the 'Create user' privilegeInstall MySQL for Windows from .zip and reset root passwordcreate new MySQL database and user using OS root credentialsdummyuser creating usersMYSQL refuses to set password for new userDefault user Accounts in MysqlHow to log into a fresh mariaDB install?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
I have an odd request from a customer and I am quite sure the answer is no, but wondering if someone has a different answer.
Background
As you know MySQL installation create a database called "mysql" where it stores the databases we create and also the users.
In the user table, there is a field called "authentication_string" where the user password is saved.
Project
On this project each time a customer creates an account a new database user and database is created.
When a customer logs in through a web interface, the system calls an API to authenticate him/her. After that the root db user is used to connect to customer database, not their own database credentials, why? because they do not want to save user and password on database (This is a temporal solution).
They want to change the application so after authentication/authorization process and they would somehow only needed root credentials to somehow get user and password from "mysql db" and then use them to create the connection using customer db credentials.
Is this possible? Or is there some mysql parent - children configuration where this scenario is possible?
mysql
asked 9 mins ago
EduardoEduardo
1216
add a comment |
I have an odd request from a customer and I am quite sure the answer is no, but wondering if someone has a different answer.
Background
As you know MySQL installation create a database called "mysql" where it stores the databases we create and also the users.
In the user table, there is a field called "authentication_string" where the user password is saved.
Project
On this project each time a customer creates an account a new database user and database is created.
When a customer logs in through a web interface, the system calls an API to authenticate him/her. After that the root db user is used to connect to customer database, not their own database credentials, why? because they do not want to save user and password on database (This is a temporal solution).
They want to change the application so after authentication/authorization process and they would somehow only needed root credentials to somehow get user and password from "mysql db" and then use them to create the connection using customer db credentials.
Is this possible? Or is there some mysql parent - children configuration where this scenario is possible?
mysql
asked 9 mins ago
EduardoEduardo
1216
What MYSQL version? Different versions support multiple plugins, sometimes including some. It looks odd why are new database user is being created and for what benefit.
– danblack
1 min ago
add a comment |
I have an odd request from a customer and I am quite sure the answer is no, but wondering if someone has a different answer.
Background
As you know MySQL installation create a database called "mysql" where it stores the databases we create and also the users.
In the user table, there is a field called "authentication_string" where the user password is saved.
Project
On this project each time a customer creates an account a new database user and database is created.
When a customer logs in through a web interface, the system calls an API to authenticate him/her. After that the root db user is used to connect to customer database, not their own database credentials, why? because they do not want to save user and password on database (This is a temporal solution).
They want to change the application so after authentication/authorization process and they would somehow only needed root credentials to somehow get user and password from "mysql db" and then use them to create the connection using customer db credentials.
Is this possible? Or is there some mysql parent - children configuration where this scenario is possible?
mysql
asked 9 mins ago
EduardoEduardo
1216
I have an odd request from a customer and I am quite sure the answer is no, but wondering if someone has a different answer.
Background
As you know MySQL installation create a database called "mysql" where it stores the databases we create and also the users.
In the user table, there is a field called "authentication_string" where the user password is saved.
Project
On this project each time a customer creates an account a new database user and database is created.
When a customer logs in through a web interface, the system calls an API to authenticate him/her. After that the root db user is used to connect to customer database, not their own database credentials, why? because they do not want to save user and password on database (This is a temporal solution).
They want to change the application so after authentication/authorization process and they would somehow only needed root credentials to somehow get user and password from "mysql db" and then use them to create the connection using customer db credentials.
Is this possible? Or is there some mysql parent - children configuration where this scenario is possible?
mysql
mysql
asked 9 mins ago
EduardoEduardo
1216
asked 9 mins ago
EduardoEduardo
1216
edited 1 min ago
Eduardo
asked 9 mins ago
EduardoEduardo
1216
asked 9 mins ago
EduardoEduardo
1216
asked 9 mins ago
EduardoEduardo
1216
1216
What MYSQL version? Different versions support multiple plugins, sometimes including some. It looks odd why are new database user is being created and for what benefit.
– danblack
1 min ago
add a comment |
What MYSQL version? Different versions support multiple plugins, sometimes including some. It looks odd why are new database user is being created and for what benefit.
– danblack
1 min ago
What MYSQL version? Different versions support multiple plugins, sometimes including some. It looks odd why are new database user is being created and for what benefit.
– danblack
1 min ago
What MYSQL version? Different versions support multiple plugins, sometimes including some. It looks odd why are new database user is being created and for what benefit.
– danblack
1 min ago
add a comment |
0
active
oldest
votes
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%2f234260%2fgetting-credentials-from-mysql-db%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f234260%2fgetting-credentials-from-mysql-db%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
What MYSQL version? Different versions support multiple plugins, sometimes including some. It looks odd why are new database user is being created and for what benefit.
– danblack
1 min ago