<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2876" name=GENERATOR>
<STYLE>@page Section1 {size: 612.0pt 792.0pt; margin: 72.0pt 90.0pt 72.0pt 90.0pt; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: Arial; mso-style-type: personal-compose
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV dir=ltr align=left><SPAN class=086583213-02062006><FONT face=Arial
color=#0000ff size=2>You need to grant the privs to allow the connection. They
mysql homepage has a set of docs at <A
href="http://dev.mysql.com/doc/">http://dev.mysql.com/doc/</A>. More
specifically this link which talks about setting up the grant
tables</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=086583213-02062006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=086583213-02062006><FONT face=Arial
color=#0000ff size=2><A
href="http://dev.mysql.com/doc/refman/4.1/en/post-installation.html">http://dev.mysql.com/doc/refman/4.1/en/post-installation.html</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=086583213-02062006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=086583213-02062006><FONT face=Arial
color=#0000ff size=2>You could also use phpmyadmin to have a nice frontend to
the mysql server system (<A
href="http://www.phpmyadmin.net/home_page/index.php">http://www.phpmyadmin.net/home_page/index.php</A>).
</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=086583213-02062006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=086583213-02062006><FONT face=Arial
color=#0000ff size=2>Some things to consider: (since you said you were a
newbie)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=086583213-02062006><FONT face=Arial
color=#0000ff size=2>1. If no remote apps are going to be connecting the sql
server port (ie only local programs relative to the system), do not open
iptables for the sql server port.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=086583213-02062006><FONT face=Arial
color=#0000ff size=2>1b. configure the /etc/my.cnf file to tell mysql to use
local sockets and not listen on a port (skip-networking
option).</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=086583213-02062006><FONT face=Arial
color=#0000ff size=2>2. When adding users, never grant a user profile in the
mysql table any privs (excluding the default root which
you should also rename to something else) as doing so would allow the user
those rights across all databases. Instead grant users access via the mysql::db
table.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=086583213-02062006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=086583213-02062006><FONT face=Arial
color=#0000ff size=2>Also there is alot of good how-to docs at <A
href="http://www.hughesjr.com/">http://www.hughesjr.com/</A> for centos,
specifically <A
href="http://www.hughesjr.com/content/view/13/30/Guides">http://www.hughesjr.com/content/view/13/30/Guides</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=086583213-02062006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=086583213-02062006><FONT face=Arial
color=#0000ff size=2>-greg</FONT></SPAN></DIV><BR>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> centos-bounces@centos.org
[mailto:centos-bounces@centos.org] <B>On Behalf Of </B>Stephen A.
Wright<BR><B>Sent:</B> Friday, June 02, 2006 4:47 AM<BR><B>To:</B>
centos@centos.org<BR><B>Subject:</B> [CentOS] centos &
mysql<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hi everyone, as a newbie to linux
Im having a but of a problem getting up and running. Hopefully one of
you you can point me in the right direction. I have installed Centos4 on
an old server here at work as a dev box, installation went well, and I have
mysql up and running. However when I try and connect from my laptop
using mysql administrator I get an error saying “the host is not allowed to
connect to this server” I tried disabling the firewall to see if that helped
and it made no difference. I also tried pinging the server and that was
fine.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I tried connecting using the
servers ip, name localhost and password as blank.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">When im logged in a root on the
server this allows be to login ok.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Any
ideas?<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Thanks in
advance<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Steve<o:p></o:p></SPAN></FONT></P></DIV></BLOCKQUOTE></BODY></HTML>