Sfrgttk

How to not forget my phone in the bathroom?

How to use the viewer node?

Why is it a problem for Freddie if the guys from Munich did what he wanted?

Would life expectancy increase if we replaced healthy organs with artificial ones?

Why are recumbent bicycles and velomobiles illegal in UCI bicycle racing?

Badly designed reimbursement form. What does that say about the company?

Which was the first story to feature space elevators?

Does human life have innate value over that of other animals?

Would Refreshing a Sandbox Wipe Out Certain Metadata?

What happens if you declare more than $10,000 at the US border?

How to know if I am a 'Real Developer'

Simple Question About Conservation of Angular Momentum

Ethernet cable only works in certain positions

What happens when the last remaining players refuse to kill each other?

Is there a technology capable of disabling the whole of Earth's satellitle network?

Coworker is trying to get me to sign his petition to run for office. How to decline politely?

Negotiating 1-year delay to my Assistant Professor Offer

Why does RAM (any type) access time decrease so slowly?

Can you make a Spell Glyph of a spell that has the potential to target more than one creature?

Does a star need to be inside a galaxy?

Suggestions on how to improve logo

multiple price sets?

Copy the content of an environment

Does an increasing sequence of reals converge if the difference of consecutive terms approaches zero?

Grant is set to NO after running GRANT ALL PRIVILEGES ON *.* TO 'root'@'ip_address'

Grant table privileges to a user connecting from any hostAnnonymous user has no privileges, but still able to show databases?XML dump of MySQL database don't include foreign key constraints. What can be the reason? sqldump(.sql) file list itMySQL - Is it possible to assign permission to count the number of tables in a database without permissions on individual tables?phpMyAdmin and mysql not showing the same databaseKilling a process without login to MySQLHost not Allowed Connectivity to MySQL ServerSlaveThreadCount at 0 for non-root user, should be 2How do I set MySQL's “character_set_server” and “collation_server” variables when creating a database?pt-table-sync usage

0

I'm trying to grant all privileges to a root user when accessing from external IP using the following command:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'ip_address';

However the GRANT permission is sill set to NO.

update
I can update GRANT permission manually by running the command below, but I'd still like to know why it's not set when using
GRANT ALL PRIVILEGES

UPDATE `mysql`.`user` SET `Grant_priv`='Y' WHERE `Host`='ip_address' and`User`='root';

mysql-5.5

share|improve this question

edited Aug 3 '16 at 5:00

user1525248

asked Aug 3 '16 at 4:38

user1525248user1525248

184

bumped to the homepage by Community♦ 24 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 | 

0

I'm trying to grant all privileges to a root user when accessing from external IP using the following command:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'ip_address';

However the GRANT permission is sill set to NO.

update
I can update GRANT permission manually by running the command below, but I'd still like to know why it's not set when using
GRANT ALL PRIVILEGES

UPDATE `mysql`.`user` SET `Grant_priv`='Y' WHERE `Host`='ip_address' and`User`='root';

mysql-5.5

share|improve this question

edited Aug 3 '16 at 5:00

user1525248

asked Aug 3 '16 at 4:38

user1525248user1525248

184

bumped to the homepage by Community♦ 24 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 | 

I'm trying to grant all privileges to a root user when accessing from external IP using the following command:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'ip_address';

However the GRANT permission is sill set to NO.

update
I can update GRANT permission manually by running the command below, but I'd still like to know why it's not set when using
GRANT ALL PRIVILEGES

UPDATE `mysql`.`user` SET `Grant_priv`='Y' WHERE `Host`='ip_address' and`User`='root';

mysql-5.5

share|improve this question

edited Aug 3 '16 at 5:00

user1525248

asked Aug 3 '16 at 4:38

user1525248user1525248

184

GRANT ALL PRIVILEGES ON *.* TO 'root'@'ip_address';

UPDATE `mysql`.`user` SET `Grant_priv`='Y' WHERE `Host`='ip_address' and`User`='root';

share|improve this question

edited Aug 3 '16 at 5:00

user1525248

asked Aug 3 '16 at 4:38

user1525248user1525248

184

share|improve this question

edited Aug 3 '16 at 5:00

user1525248

asked Aug 3 '16 at 4:38

user1525248user1525248

184

asked Aug 3 '16 at 4:38

user1525248user1525248

184

asked Aug 3 '16 at 4:38

user1525248user1525248

184

1 Answer
1

active

oldest

votes

0

Try Below command:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'ip_address' identified by 'password' WITH GRANT OPTION;

and don't forget to :

Flush privileges;

share|improve this answer

answered Aug 3 '16 at 5:12

Sachin SinghSachin Singh

1585

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
});


}
});

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%2fdba.stackexchange.com%2fquestions%2f145705%2fgrant-is-set-to-no-after-running-grant-all-privileges-on-to-rootip-addre%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

Try Below command:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'ip_address' identified by 'password' WITH GRANT OPTION;

and don't forget to :

Flush privileges;

share|improve this answer

answered Aug 3 '16 at 5:12

Sachin SinghSachin Singh

1585

add a comment | 

0

Try Below command:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'ip_address' identified by 'password' WITH GRANT OPTION;

and don't forget to :

Flush privileges;

share|improve this answer

answered Aug 3 '16 at 5:12

Sachin SinghSachin Singh

1585

add a comment | 

Try Below command:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'ip_address' identified by 'password' WITH GRANT OPTION;

and don't forget to :

Flush privileges;

share|improve this answer

answered Aug 3 '16 at 5:12

Sachin SinghSachin Singh

1585

GRANT ALL PRIVILEGES ON *.* TO 'root'@'ip_address' identified by 'password' WITH GRANT OPTION;

Flush privileges;

share|improve this answer

answered Aug 3 '16 at 5:12

Sachin SinghSachin Singh

1585

answered Aug 3 '16 at 5:12

Sachin SinghSachin Singh

1585

answered Aug 3 '16 at 5:12

Sachin SinghSachin Singh

1585