Grant all privileges to all users on a host in mysql
How to grant all privileges to all users in mySQL ?
GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'1.2.3.4' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;
What do I replace username with in order to allow it for every user on the given IP?Even if it is '' i.e no username at all in input ?
I tried * and % in username but that did not help.
mysql
edited May 11 '16 at 5:40
Rahul Tripathi
126k21162233
asked May 11 '16 at 5:37
Simran kaur
89551444
add a comment |
How to grant all privileges to all users in mySQL ?
GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'1.2.3.4' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;
What do I replace username with in order to allow it for every user on the given IP?Even if it is '' i.e no username at all in input ?
I tried * and % in username but that did not help.
mysql
edited May 11 '16 at 5:40
Rahul Tripathi
126k21162233
asked May 11 '16 at 5:37
Simran kaur
89551444
add a comment |
How to grant all privileges to all users in mySQL ?
GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'1.2.3.4' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;
What do I replace username with in order to allow it for every user on the given IP?Even if it is '' i.e no username at all in input ?
I tried * and % in username but that did not help.
mysql
edited May 11 '16 at 5:40
Rahul Tripathi
126k21162233
asked May 11 '16 at 5:37
Simran kaur
89551444
How to grant all privileges to all users in mySQL ?
GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'1.2.3.4' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;
What do I replace username with in order to allow it for every user on the given IP?Even if it is '' i.e no username at all in input ?
I tried * and % in username but that did not help.
mysql
mysql
edited May 11 '16 at 5:40
Rahul Tripathi
126k21162233
asked May 11 '16 at 5:37
Simran kaur
89551444
edited May 11 '16 at 5:40
Rahul Tripathi
126k21162233
asked May 11 '16 at 5:37
Simran kaur
89551444
edited May 11 '16 at 5:40
Rahul Tripathi
126k21162233
edited May 11 '16 at 5:40
Rahul Tripathi
126k21162233
edited May 11 '16 at 5:40
Rahul Tripathi
126k21162233
126k21162233
asked May 11 '16 at 5:37
Simran kaur
89551444
asked May 11 '16 at 5:37
Simran kaur
89551444
asked May 11 '16 at 5:37
Simran kaur
89551444
89551444
add a comment |
add a comment |
4 Answers
4
active
oldest
votes
You can try like this:
GRANT ALL PRIVILEGES ON *.* TO ''@'localhost' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;
The manual says:
In this case, any user who connects from the local host with the
correct password for the anonymous user will be permitted access, with
the privileges associated with the anonymous-user account.
answered May 11 '16 at 5:44
Rahul Tripathi
126k21162233
I saw this and thought that this means that user who does not enter a username will be granted access. Do you know for certain that this would allow, for example,rahul@localhostto connect?
– Tim Biegeleisen
May 11 '16 at 5:45
add a comment |
This should work:
GRANT ALL PRIVILEGES ON 'database'.'table' TO '%'@'1.2.3.4' WITH GRANT OPTION;
answered May 11 '16 at 5:44
Adrian
9310
MySQL does not allow wildcards for the username.
– Tim Biegeleisen
May 11 '16 at 5:45
add a comment |
Wild card does not work for user in mysql grant privilege command.
If you know list of users then yOU can try :-
GRANT ALL PRIVILEGES ON *.* TO 'user1'@'1.2.3.4',
'user2'@'1.2.3.4',
'user3'@'1.2.3.4',
'user4'@'1.2.3.4',
'user5'@'1.2.3.4',
'user6'@'1.2.3.4';
edited May 11 '16 at 6:20
1000111
11.2k21726
answered May 11 '16 at 5:57
Atul Rai
154110
add a comment |
This is working for all my MySQL users irrespective of their hostname and Ips.
GRANT ALL ON <yourdbname>.* TO ''@'%' IDENTIFIED BY 'yourdbpassword';
FLUSH PRIVILEGES;
answered Nov 20 '18 at 10:00
milind bhavsar
417
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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
});
}
});
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%2fstackoverflow.com%2fquestions%2f37153877%2fgrant-all-privileges-to-all-users-on-a-host-in-mysql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
4 Answers
4
active
oldest
votes
4 Answers
4
active
oldest
votes
active
oldest
votes
active
oldest
votes
You can try like this:
GRANT ALL PRIVILEGES ON *.* TO ''@'localhost' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;
The manual says:
In this case, any user who connects from the local host with the
correct password for the anonymous user will be permitted access, with
the privileges associated with the anonymous-user account.
answered May 11 '16 at 5:44
Rahul Tripathi
126k21162233
I saw this and thought that this means that user who does not enter a username will be granted access. Do you know for certain that this would allow, for example,rahul@localhostto connect?
– Tim Biegeleisen
May 11 '16 at 5:45
add a comment |
You can try like this:
GRANT ALL PRIVILEGES ON *.* TO ''@'localhost' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;
The manual says:
In this case, any user who connects from the local host with the
correct password for the anonymous user will be permitted access, with
the privileges associated with the anonymous-user account.
answered May 11 '16 at 5:44
Rahul Tripathi
126k21162233
I saw this and thought that this means that user who does not enter a username will be granted access. Do you know for certain that this would allow, for example,rahul@localhostto connect?
– Tim Biegeleisen
May 11 '16 at 5:45
add a comment |
You can try like this:
GRANT ALL PRIVILEGES ON *.* TO ''@'localhost' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;
The manual says:
In this case, any user who connects from the local host with the
correct password for the anonymous user will be permitted access, with
the privileges associated with the anonymous-user account.
answered May 11 '16 at 5:44
Rahul Tripathi
126k21162233
You can try like this:
GRANT ALL PRIVILEGES ON *.* TO ''@'localhost' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;
The manual says:
In this case, any user who connects from the local host with the
correct password for the anonymous user will be permitted access, with
the privileges associated with the anonymous-user account.
answered May 11 '16 at 5:44
Rahul Tripathi
126k21162233
answered May 11 '16 at 5:44
Rahul Tripathi
126k21162233
answered May 11 '16 at 5:44
Rahul Tripathi
126k21162233
answered May 11 '16 at 5:44
Rahul Tripathi
126k21162233
126k21162233
I saw this and thought that this means that user who does not enter a username will be granted access. Do you know for certain that this would allow, for example,rahul@localhostto connect?
– Tim Biegeleisen
May 11 '16 at 5:45
add a comment |
I saw this and thought that this means that user who does not enter a username will be granted access. Do you know for certain that this would allow, for example,rahul@localhostto connect?
– Tim Biegeleisen
May 11 '16 at 5:45
I saw this and thought that this means that user who does not enter a username will be granted access. Do you know for certain that this would allow, for example,
rahul@localhost to connect?– Tim Biegeleisen
May 11 '16 at 5:45
I saw this and thought that this means that user who does not enter a username will be granted access. Do you know for certain that this would allow, for example,
rahul@localhost to connect?– Tim Biegeleisen
May 11 '16 at 5:45
add a comment |
This should work:
GRANT ALL PRIVILEGES ON 'database'.'table' TO '%'@'1.2.3.4' WITH GRANT OPTION;
answered May 11 '16 at 5:44
Adrian
9310
MySQL does not allow wildcards for the username.
– Tim Biegeleisen
May 11 '16 at 5:45
add a comment |
This should work:
GRANT ALL PRIVILEGES ON 'database'.'table' TO '%'@'1.2.3.4' WITH GRANT OPTION;
answered May 11 '16 at 5:44
Adrian
9310
MySQL does not allow wildcards for the username.
– Tim Biegeleisen
May 11 '16 at 5:45
add a comment |
This should work:
GRANT ALL PRIVILEGES ON 'database'.'table' TO '%'@'1.2.3.4' WITH GRANT OPTION;
answered May 11 '16 at 5:44
Adrian
9310
This should work:
GRANT ALL PRIVILEGES ON 'database'.'table' TO '%'@'1.2.3.4' WITH GRANT OPTION;
answered May 11 '16 at 5:44
Adrian
9310
answered May 11 '16 at 5:44
Adrian
9310
answered May 11 '16 at 5:44
Adrian
9310
answered May 11 '16 at 5:44
Adrian
9310
9310
MySQL does not allow wildcards for the username.
– Tim Biegeleisen
May 11 '16 at 5:45
add a comment |
MySQL does not allow wildcards for the username.
– Tim Biegeleisen
May 11 '16 at 5:45
MySQL does not allow wildcards for the username.
– Tim Biegeleisen
May 11 '16 at 5:45
MySQL does not allow wildcards for the username.
– Tim Biegeleisen
May 11 '16 at 5:45
add a comment |
Wild card does not work for user in mysql grant privilege command.
If you know list of users then yOU can try :-
GRANT ALL PRIVILEGES ON *.* TO 'user1'@'1.2.3.4',
'user2'@'1.2.3.4',
'user3'@'1.2.3.4',
'user4'@'1.2.3.4',
'user5'@'1.2.3.4',
'user6'@'1.2.3.4';
edited May 11 '16 at 6:20
1000111
11.2k21726
answered May 11 '16 at 5:57
Atul Rai
154110
add a comment |
Wild card does not work for user in mysql grant privilege command.
If you know list of users then yOU can try :-
GRANT ALL PRIVILEGES ON *.* TO 'user1'@'1.2.3.4',
'user2'@'1.2.3.4',
'user3'@'1.2.3.4',
'user4'@'1.2.3.4',
'user5'@'1.2.3.4',
'user6'@'1.2.3.4';
edited May 11 '16 at 6:20
1000111
11.2k21726
answered May 11 '16 at 5:57
Atul Rai
154110
add a comment |
Wild card does not work for user in mysql grant privilege command.
If you know list of users then yOU can try :-
GRANT ALL PRIVILEGES ON *.* TO 'user1'@'1.2.3.4',
'user2'@'1.2.3.4',
'user3'@'1.2.3.4',
'user4'@'1.2.3.4',
'user5'@'1.2.3.4',
'user6'@'1.2.3.4';
edited May 11 '16 at 6:20
1000111
11.2k21726
answered May 11 '16 at 5:57
Atul Rai
154110
Wild card does not work for user in mysql grant privilege command.
If you know list of users then yOU can try :-
GRANT ALL PRIVILEGES ON *.* TO 'user1'@'1.2.3.4',
'user2'@'1.2.3.4',
'user3'@'1.2.3.4',
'user4'@'1.2.3.4',
'user5'@'1.2.3.4',
'user6'@'1.2.3.4';
edited May 11 '16 at 6:20
1000111
11.2k21726
answered May 11 '16 at 5:57
Atul Rai
154110
edited May 11 '16 at 6:20
1000111
11.2k21726
edited May 11 '16 at 6:20
1000111
11.2k21726
edited May 11 '16 at 6:20
1000111
11.2k21726
11.2k21726
answered May 11 '16 at 5:57
Atul Rai
154110
answered May 11 '16 at 5:57
Atul Rai
154110
answered May 11 '16 at 5:57
Atul Rai
154110
154110
add a comment |
add a comment |
This is working for all my MySQL users irrespective of their hostname and Ips.
GRANT ALL ON <yourdbname>.* TO ''@'%' IDENTIFIED BY 'yourdbpassword';
FLUSH PRIVILEGES;
answered Nov 20 '18 at 10:00
milind bhavsar
417
add a comment |
This is working for all my MySQL users irrespective of their hostname and Ips.
GRANT ALL ON <yourdbname>.* TO ''@'%' IDENTIFIED BY 'yourdbpassword';
FLUSH PRIVILEGES;
answered Nov 20 '18 at 10:00
milind bhavsar
417
add a comment |
This is working for all my MySQL users irrespective of their hostname and Ips.
GRANT ALL ON <yourdbname>.* TO ''@'%' IDENTIFIED BY 'yourdbpassword';
FLUSH PRIVILEGES;
answered Nov 20 '18 at 10:00
milind bhavsar
417
This is working for all my MySQL users irrespective of their hostname and Ips.
GRANT ALL ON <yourdbname>.* TO ''@'%' IDENTIFIED BY 'yourdbpassword';
FLUSH PRIVILEGES;
answered Nov 20 '18 at 10:00
milind bhavsar
417
answered Nov 20 '18 at 10:00
milind bhavsar
417
answered Nov 20 '18 at 10:00
milind bhavsar
417
answered Nov 20 '18 at 10:00
milind bhavsar
417
417
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- 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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2fstackoverflow.com%2fquestions%2f37153877%2fgrant-all-privileges-to-all-users-on-a-host-in-mysql%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
