<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style>
<!--
@font-face
{font-family:Calibri}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif"}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline}
span.EmailStyle17
{font-family:"Calibri","sans-serif";
color:windowtext}
.MsoChpDefault
{font-family:"Calibri","sans-serif"}
@page WordSection1
{margin:72.0pt 72.0pt 72.0pt 72.0pt}
div.WordSection1
{}
-->
</style>
</head>
<body lang="EN-GB" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Hi,</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Do you mean use “localhost” as the “bind-address in “my.cnf”?</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">If I do this, I get 111 errors when trying to access through a browser on remote workstation (we need to be able to access mysql from remote PCs). I am using “bind-address” “0.0.0.0” which seems to get me as far as the original error mentioned.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">If I login to mysql at the command line locally, then type this :-</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">“use mysql;”</p>
<p class="MsoNormal">“select user, host, super_priv from user;”</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">I get this response :-</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">+------------------+----------------+------------+-----------------------</p>
<p class="MsoNormal">| user | host | super_priv |</p>
<p class="MsoNormal">+------------------+----------------+------------+-----------------------</p>
<p class="MsoNormal">| root | localhost | Y |</p>
<p class="MsoNormal">| debian-sys-maint | localhost | Y |</p>
<p class="MsoNormal">| pma | localhost | N |</p>
<p class="MsoNormal">| root | % | Y |</p>
<p class="MsoNormal">| www-data | % | N |</p>
<p class="MsoNormal">| pma | 192.168.240.98 | N |</p>
<p class="MsoNormal">+------------------+----------------+------------+-----------------------</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Can you see an issue here? (I am using “root” at this point for xerte “proxy” mysql account – have tried changing it to another user with no success as far)</p>
<p class="MsoNormal">The file system permissions on the “xerte” directory under Apache root are all flagged 777 for global access.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Regards</p>
<p class="MsoNormal"> </p>
</div>
This email and any attachments are confidential and should not be used by anyone who is not the original intended recipient. If you receive this in error, please contact the sender and delete the material from your computer. You are not authorised to, and must
not, read, copy, distribute, use or retain this message or any part of it. Kirklees College cannot accept liability for any statements made which are clearly the sender's own and not expressly made on behalf of Kirklees College or one of its agents.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>KIRKLEES COLLEGE</title>
</head>
<body>
<br />
KIRKLEES COLLEGE<br />
YOUR SUCCESS IS OUR FOCUS <br />
<br />Please consider the environment. Don't print this e-mail unless necessary.
</body>
</html>
</body>
</html>