Unable to enable remote admin on MySQL 5.7 server on Ubuntu Server 16.04 using MySQL Workbench after system reinstallApache server A attempts conn to mysql server B. times outmysql server admin error from workbenchubuntu server 15.04: remote access mysqlMySQL Server not binding to external addressesUnhandled exception can't connect to mysql server on '127.0.0.1' (111) (code 2003)Using MS Access to import from mysqlUsing MySQL Workbench to connect to MySQL on Linux serverCan't contact my mysql from another serverCannot Connect to Database ServerIssue to connect the mysql from ubuntu server using database management tool
Splitting fasta file into smaller files based on header pattern
Homology of the fiber
Weird lines in Microsoft Word
How can I create URL shortcuts/redirects for task/diff IDs in Phabricator?
Do I need an EFI partition for each 18.04 ubuntu I have on my HD?
How can a new country break out from a developed country without war?
Why doesn't the chatan sign the ketubah?
Is there any common country to visit for uk and schengen visa?
Turning a hard to access nut?
How much propellant is used up until liftoff?
Would this string work as string?
How to test the sharpness of a knife?
Exit shell with shortcut (not typing exit) that closes session properly
pipe commands inside find -exec?
How can I query the supported timezones in Apex?
What is the difference between something being completely legal and being completely decriminalized?
Can other pieces capture a threatening piece and prevent a checkmate?
is this saw blade faulty?
Knife as defense against stray dogs
Why doesn't the fusion process of the sun speed up?
Is "inadequate referencing" a euphemism for plagiarism?
Why do I have a large white artefact on the rendered image?
What (if any) is the reason to buy in small local stores?
Someone scrambled my calling sign- who am I?
Unable to enable remote admin on MySQL 5.7 server on Ubuntu Server 16.04 using MySQL Workbench after system reinstall
Apache server A attempts conn to mysql server B. times outmysql server admin error from workbenchubuntu server 15.04: remote access mysqlMySQL Server not binding to external addressesUnhandled exception can't connect to mysql server on '127.0.0.1' (111) (code 2003)Using MS Access to import from mysqlUsing MySQL Workbench to connect to MySQL on Linux serverCan't contact my mysql from another serverCannot Connect to Database ServerIssue to connect the mysql from ubuntu server using database management tool
I had to reinstall my Ubuntu Server 16.04LTS. The original install allowed remote admin on MySQL server (5.7) using a remote connection from MySQL Workbench. I believe that the server has been configured as previously set up.
I have changed the bind-address in the mysqld.cnf in the /etc/mysql/mysql.conf.d/ directory to the local address, to 0.0.0.0, to *, to the remote address, and commented the line out completely. Nothing works. Any attempt to connect using the Workbench results in a "'' is not allowed to connect" message.
I can use a telnet session and run MySQL through that but cannot get the Workbench application to connect no matter what I do. Any suggestions of what to check or what I can do?
16.04 mysql mysql-workbench
asked 51 mins ago
DyanDyan
1
New contributor
Dyan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I had to reinstall my Ubuntu Server 16.04LTS. The original install allowed remote admin on MySQL server (5.7) using a remote connection from MySQL Workbench. I believe that the server has been configured as previously set up.
I have changed the bind-address in the mysqld.cnf in the /etc/mysql/mysql.conf.d/ directory to the local address, to 0.0.0.0, to *, to the remote address, and commented the line out completely. Nothing works. Any attempt to connect using the Workbench results in a "'' is not allowed to connect" message.
I can use a telnet session and run MySQL through that but cannot get the Workbench application to connect no matter what I do. Any suggestions of what to check or what I can do?
16.04 mysql mysql-workbench
asked 51 mins ago
DyanDyan
1
New contributor
Dyan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
mysql --version returns: mysql Ver 14.14 Distrib 5.7.25, for Linux (i686) using EditLine wrapper.
– Dyan
49 mins ago
add a comment |
I had to reinstall my Ubuntu Server 16.04LTS. The original install allowed remote admin on MySQL server (5.7) using a remote connection from MySQL Workbench. I believe that the server has been configured as previously set up.
I have changed the bind-address in the mysqld.cnf in the /etc/mysql/mysql.conf.d/ directory to the local address, to 0.0.0.0, to *, to the remote address, and commented the line out completely. Nothing works. Any attempt to connect using the Workbench results in a "'' is not allowed to connect" message.
I can use a telnet session and run MySQL through that but cannot get the Workbench application to connect no matter what I do. Any suggestions of what to check or what I can do?
16.04 mysql mysql-workbench
asked 51 mins ago
DyanDyan
1
New contributor
Dyan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I had to reinstall my Ubuntu Server 16.04LTS. The original install allowed remote admin on MySQL server (5.7) using a remote connection from MySQL Workbench. I believe that the server has been configured as previously set up.
I have changed the bind-address in the mysqld.cnf in the /etc/mysql/mysql.conf.d/ directory to the local address, to 0.0.0.0, to *, to the remote address, and commented the line out completely. Nothing works. Any attempt to connect using the Workbench results in a "'' is not allowed to connect" message.
I can use a telnet session and run MySQL through that but cannot get the Workbench application to connect no matter what I do. Any suggestions of what to check or what I can do?
16.04 mysql mysql-workbench
16.04 mysql mysql-workbench
asked 51 mins ago
DyanDyan
1
New contributor
Dyan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 51 mins ago
DyanDyan
1
New contributor
Dyan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 51 mins ago
DyanDyan
1
New contributor
Dyan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 51 mins ago
DyanDyan
1
asked 51 mins ago
DyanDyan
1
1
New contributor
Dyan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Dyan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Dyan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
mysql --version returns: mysql Ver 14.14 Distrib 5.7.25, for Linux (i686) using EditLine wrapper.
– Dyan
49 mins ago
add a comment |
mysql --version returns: mysql Ver 14.14 Distrib 5.7.25, for Linux (i686) using EditLine wrapper.
– Dyan
49 mins ago
mysql --version returns: mysql Ver 14.14 Distrib 5.7.25, for Linux (i686) using EditLine wrapper.
– Dyan
49 mins ago
mysql --version returns: mysql Ver 14.14 Distrib 5.7.25, for Linux (i686) using EditLine wrapper.
– Dyan
49 mins ago
add a comment |
1 Answer
1
active
oldest
votes
Ok, I found the problem. When I setup the user entry on the MySQL host, I apparently fat-fingered the IP address in the @hostname entry when granting privs. When I added a second user using the hostname, it worked. The final configuration in /etc/mysql/mysql.conf.d/mysqld.cnf was for the bind-address entry to be set to the IP of the host machine.
Let the snarky comments begin. :o)
answered 3 mins ago
DyanDyan
1
New contributor
Dyan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "89"
;
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
);
);
Dyan is a new contributor. Be nice, and check out our Code of Conduct.
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%2faskubuntu.com%2fquestions%2f1126762%2funable-to-enable-remote-admin-on-mysql-5-7-server-on-ubuntu-server-16-04-using-m%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
Ok, I found the problem. When I setup the user entry on the MySQL host, I apparently fat-fingered the IP address in the @hostname entry when granting privs. When I added a second user using the hostname, it worked. The final configuration in /etc/mysql/mysql.conf.d/mysqld.cnf was for the bind-address entry to be set to the IP of the host machine.
Let the snarky comments begin. :o)
answered 3 mins ago
DyanDyan
1
New contributor
Dyan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Ok, I found the problem. When I setup the user entry on the MySQL host, I apparently fat-fingered the IP address in the @hostname entry when granting privs. When I added a second user using the hostname, it worked. The final configuration in /etc/mysql/mysql.conf.d/mysqld.cnf was for the bind-address entry to be set to the IP of the host machine.
Let the snarky comments begin. :o)
answered 3 mins ago
DyanDyan
1
New contributor
Dyan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Ok, I found the problem. When I setup the user entry on the MySQL host, I apparently fat-fingered the IP address in the @hostname entry when granting privs. When I added a second user using the hostname, it worked. The final configuration in /etc/mysql/mysql.conf.d/mysqld.cnf was for the bind-address entry to be set to the IP of the host machine.
Let the snarky comments begin. :o)
answered 3 mins ago
DyanDyan
1
New contributor
Dyan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Ok, I found the problem. When I setup the user entry on the MySQL host, I apparently fat-fingered the IP address in the @hostname entry when granting privs. When I added a second user using the hostname, it worked. The final configuration in /etc/mysql/mysql.conf.d/mysqld.cnf was for the bind-address entry to be set to the IP of the host machine.
Let the snarky comments begin. :o)
answered 3 mins ago
DyanDyan
1
New contributor
Dyan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 3 mins ago
DyanDyan
1
New contributor
Dyan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 3 mins ago
DyanDyan
1
answered 3 mins ago
DyanDyan
1
1
New contributor
Dyan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Dyan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Dyan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
Dyan is a new contributor. Be nice, and check out our Code of Conduct.
Dyan is a new contributor. Be nice, and check out our Code of Conduct.
Dyan is a new contributor. Be nice, and check out our Code of Conduct.
Dyan is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Ask Ubuntu!
- 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%2faskubuntu.com%2fquestions%2f1126762%2funable-to-enable-remote-admin-on-mysql-5-7-server-on-ubuntu-server-16-04-using-m%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
mysql --version returns: mysql Ver 14.14 Distrib 5.7.25, for Linux (i686) using EditLine wrapper.
– Dyan
49 mins ago