MySQL Installer Console Creating New User
up vote
0
down vote
favorite
I am installing and deploying MySQL via the installer console (quiet mode) and have everything working except for the creation of a new user. I can create the new user successfully, but it defaults to a location of localhost where as I would like to to make the account usable from other locations so a "%".
type=user;username=username;password=password;role=DBA;auth_plugin=mysql_native_password
I have searched the MySQL documentation but cant find anything related to changing the Limit to hosts matching value.
i was wondering if anyone had successfully done a similar setup.
Thanks,
Daniel.
mysql
add a comment |
up vote
0
down vote
favorite
I am installing and deploying MySQL via the installer console (quiet mode) and have everything working except for the creation of a new user. I can create the new user successfully, but it defaults to a location of localhost where as I would like to to make the account usable from other locations so a "%".
type=user;username=username;password=password;role=DBA;auth_plugin=mysql_native_password
I have searched the MySQL documentation but cant find anything related to changing the Limit to hosts matching value.
i was wondering if anyone had successfully done a similar setup.
Thanks,
Daniel.
mysql
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I am installing and deploying MySQL via the installer console (quiet mode) and have everything working except for the creation of a new user. I can create the new user successfully, but it defaults to a location of localhost where as I would like to to make the account usable from other locations so a "%".
type=user;username=username;password=password;role=DBA;auth_plugin=mysql_native_password
I have searched the MySQL documentation but cant find anything related to changing the Limit to hosts matching value.
i was wondering if anyone had successfully done a similar setup.
Thanks,
Daniel.
mysql
I am installing and deploying MySQL via the installer console (quiet mode) and have everything working except for the creation of a new user. I can create the new user successfully, but it defaults to a location of localhost where as I would like to to make the account usable from other locations so a "%".
type=user;username=username;password=password;role=DBA;auth_plugin=mysql_native_password
I have searched the MySQL documentation but cant find anything related to changing the Limit to hosts matching value.
i was wondering if anyone had successfully done a similar setup.
Thanks,
Daniel.
mysql
mysql
asked Nov 10 at 21:47
Daniel Kelly
114
114
add a comment |
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f53243736%2fmysql-installer-console-creating-new-user%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