Hello,
I am trying to connect to a mysql db on a home WORKGROUP. I tried
ip(given out by router) and Computer name.
I get "Mysql is not a recognised.....Batch....
I tried setting a PATH envirement variable in the host but this isnt
working.
I can connect to the host webserver through the browser, but not the
mysql through the command line.
Any ?
Thanks
Mike

AMP wrote:
> Hello,
> I am trying to connect to a mysql db on a home WORKGROUP. I tried
> ip(given out by router) and Computer name.
> I get "Mysql is not a recognised.....Batch....
> I tried setting a PATH envirement variable in the host but this isnt
> working.
> I can connect to the host webserver through the browser, but not the
> mysql through the command line.
> Any ?
> Thanks
> Mike
>

It means you don't have the mysql client installed (or at least
available) on your client machine.

When you access MySQL via the browser, you're using the MySQL client on
the webserver. However, when you're using the command line, you're
using (or at least trying to use) the mysql client on your machine.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Jerry Stuckle wrote:
> AMP wrote:
>> Hello,
>> I am trying to connect to a mysql db on a home WORKGROUP. I tried
>> ip(given out by router) and Computer name.
>> I get "Mysql is not a recognised.....Batch....
>> I tried setting a PATH envirement variable in the host but this isnt
>> working.
>> I can connect to the host webserver through the browser, but not the
>> mysql through the command line.
>> Any ?
>> Thanks
>> Mike
>>
>
> It means you don't have the mysql client installed (or at least
> available) on your client machine.
>
> When you access MySQL via the browser, you're using the MySQL client
> on the webserver. However, when you're using the command line, you're
> using (or at least trying to use) the mysql client on your machine.

I don't think he's even accesing MySQL through the browser. All he says is
that he can connect to the host webserver.

Ate the very least ee needs to put mysql.exe on his client machine. But I
think he really needs a basic understanding of how computers work.

Paul Lautman wrote:
> Jerry Stuckle wrote:
>> AMP wrote:
>>> Hello,
>>> I am trying to connect to a mysql db on a home WORKGROUP. I tried
>>> ip(given out by router) and Computer name.
>>> I get "Mysql is not a recognised.....Batch....
>>> I tried setting a PATH envirement variable in the host but this isnt
>>> working.
>>> I can connect to the host webserver through the browser, but not the
>>> mysql through the command line.
>>> Any ?
>>> Thanks
>>> Mike
>>>
>> It means you don't have the mysql client installed (or at least
>> available) on your client machine.
>>
>> When you access MySQL via the browser, you're using the MySQL client
>> on the webserver. However, when you're using the command line, you're
>> using (or at least trying to use) the mysql client on your machine.
>
> I don't think he's even accesing MySQL through the browser. All he says is
> that he can connect to the host webserver.
>
> Ate the very least ee needs to put mysql.exe on his client machine. But I
> think he really needs a basic understanding of how computers work.
>
>
>

You could be correct, Paul. I just figured if he's connecting through
the webserver, he's connecting to MySQL (otherwise he wouldn't have
needed to mention it). And of course, if he's connecting to a
webserver, I figured he's using a browser.

But you're correct - I may be making too many assumptions.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

On Jan 6, 3:12pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> Paul Lautman wrote:
> > Jerry Stuckle wrote:
> >> AMP wrote:
> >>> Hello,
> >>> I am trying to connect to a mysql db on a home WORKGROUP. I tried
> >>> ip(given out by router) and Computer name.
> >>> I get "Mysql is not a recognised.....Batch....
> >>> I tried setting a PATH envirement variable in the host but this isnt
> >>> working.
> >>> I can connect to the host webserver through the browser, but not the
> >>> mysql through the command line.
> >>> Any ?
> >>> Thanks
> >>> Mike
>
> >> It means you don't have the mysql client installed (or at least
> >> available) on your client machine.
>
> >> When you access MySQL via the browser, you're using the MySQL client
> >> on the webserver. However, when you're using the command line, you're
> >> using (or at least trying to use) the mysql client on your machine.
>
> > I don't think he's even accesing MySQL through the browser. All he says is
> > that he can connect to the host webserver.
>
> > Ate the very least ee needs to put mysql.exe on his client machine. But I
> > think he really needs a basic understanding of how computers work.
>
> You could be correct, Paul. I just figured if he's connecting through
> the webserver, he's connecting to MySQL (otherwise he wouldn't have
> needed to mention it). And of course, if he's connecting to a
> webserver, I figured he's using a browser.
>
> But you're correct - I may be making too many assumptions.
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstuck...@attglobal.net
> ==================- Hide quoted text -
>
> - Show quoted text -

I have the mysql client installed
I get "Cant connect to mysql on 192.168.1.102"
I have root user with no password.
mysql -h 192.168.1.102 -u root
As far as the webserrver, I said that to show I can connect to my
apache just using an ip address, so I figure I should be able to
connect to mysql.
I can ping it.
I can connect to mysql from localhost.
I added % host.
Db table is empty
Host Table is empty
Anything else?

Thanks

AMP wrote:
> I added % host.

What precisely do you mean by the above?

AMP wrote:
> On Jan 6, 3:12 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>> Paul Lautman wrote:
>>> Jerry Stuckle wrote:
>>>> AMP wrote:
>>>>> Hello,
>>>>> I am trying to connect to a mysql db on a home WORKGROUP. I tried
>>>>> ip(given out by router) and Computer name.
>>>>> I get "Mysql is not a recognised.....Batch....
>>>>> I tried setting a PATH envirement variable in the host but this isnt
>>>>> working.
>>>>> I can connect to the host webserver through the browser, but not the
>>>>> mysql through the command line.
>>>>> Any ?
>>>>> Thanks
>>>>> Mike
>>>> It means you don't have the mysql client installed (or at least
>>>> available) on your client machine.
>>>> When you access MySQL via the browser, you're using the MySQL client
>>>> on the webserver. However, when you're using the command line, you're
>>>> using (or at least trying to use) the mysql client on your machine.
>>> I don't think he's even accesing MySQL through the browser. All he says is
>>> that he can connect to the host webserver.
>>> Ate the very least ee needs to put mysql.exe on his client machine. But I
>>> think he really needs a basic understanding of how computers work.
>> You could be correct, Paul. I just figured if he's connecting through
>> the webserver, he's connecting to MySQL (otherwise he wouldn't have
>> needed to mention it). And of course, if he's connecting to a
>> webserver, I figured he's using a browser.
>>
>> But you're correct - I may be making too many assumptions.
>>
>> --
>> ==================
>> Remove the "x" from my email address
>> Jerry Stuckle
>> JDS Computer Training Corp.
>> jstuck...@attglobal.net
>> ==================- Hide quoted text -
>>
>> - Show quoted text -
>
> I have the mysql client installed
> I get "Cant connect to mysql on 192.168.1.102"
> I have root user with no password.
> mysql -h 192.168.1.102 -u root
> As far as the webserrver, I said that to show I can connect to my
> apache just using an ip address, so I figure I should be able to
> connect to mysql.
> I can ping it.
> I can connect to mysql from localhost.
> I added % host.
> Db table is empty
> Host Table is empty
> Anything else?
>
> Thanks
>

Is networking disabled for MySQL? Are you using the default port (3306)?
Both can be found in the my.ini file.

Do you have a firewall blocking port 3306?

Any of these can cause a failure to connect message.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

On Jan 6, 4:39pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> AMP wrote:
> > On Jan 6, 3:12 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> >> Paul Lautman wrote:
> >>> Jerry Stuckle wrote:
> >>>> AMP wrote:
> >>>>> Hello,
> >>>>> I am trying to connect to a mysql db on a home WORKGROUP. I tried
> >>>>> ip(given out by router) and Computer name.
> >>>>> I get "Mysql is not a recognised.....Batch....
> >>>>> I tried setting a PATH envirement variable in the host but this isnt
> >>>>> working.
> >>>>> I can connect to the host webserver through the browser, but not the
> >>>>> mysql through the command line.
> >>>>> Any ?
> >>>>> Thanks
> >>>>> Mike
> >>>> It means you don't have the mysql client installed (or at least
> >>>> available) on your client machine.
> >>>> When you access MySQL via the browser, you're using the MySQL client
> >>>> on the webserver. However, when you're using the command line, you're
> >>>> using (or at least trying to use) the mysql client on your machine.
> >>> I don't think he's even accesing MySQL through the browser. All he says is
> >>> that he can connect to the host webserver.
> >>> Ate the very least ee needs to put mysql.exe on his client machine. But I
> >>> think he really needs a basic understanding of how computers work.
> >> You could be correct, Paul. I just figured if he's connecting through
> >> the webserver, he's connecting to MySQL (otherwise he wouldn't have
> >> needed to mention it). And of course, if he's connecting to a
> >> webserver, I figured he's using a browser.
>
> >> But you're correct - I may be making too many assumptions.
>
> >> --
> >> ==================
> >> Remove the "x" from my email address
> >> Jerry Stuckle
> >> JDS Computer Training Corp.
> >> jstuck...@attglobal.net
> >> ==================- Hide quoted text -
>
> >> - Show quoted text -
>
> > I have the mysql client installed
> > I get "Cant connect to mysql on 192.168.1.102"
> > I have root user with no password.
> > mysql -h 192.168.1.102 -u root
> > As far as the webserrver, I said that to show I can connect to my
> > apache just using an ip address, so I figure I should be able to
> > connect to mysql.
> > I can ping it.
> > I can connect to mysql from localhost.
> > I added % host.
> > Db table is empty
> > Host Table is empty
> > Anything else?
>
> > Thanks
>
> Is networking disabled for MySQL? Are you using the default port (3306)?
> Both can be found in the my.ini file.
>
> Do you have a firewall blocking port 3306?
>
> Any of these can cause a failure to connect message.
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstuck...@attglobal.net
> ==================- Hide quoted text -
>
> - Show quoted text -

I unblocked the port, now I have Host 'Desktop" is not allowed to
connect to this mysql server.
I did not see networking disabled in my ini file.
I added Desktop to the Host and User Tables
Thanks
Mike

AMP wrote:
> On Jan 6, 4:39 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>> AMP wrote:
>>> On Jan 6, 3:12 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>>>> Paul Lautman wrote:
>>>>> Jerry Stuckle wrote:
>>>>>> AMP wrote:
>>>>>>> Hello,
>>>>>>> I am trying to connect to a mysql db on a home WORKGROUP. I tried
>>>>>>> ip(given out by router) and Computer name.
>>>>>>> I get "Mysql is not a recognised.....Batch....
>>>>>>> I tried setting a PATH envirement variable in the host but this isnt
>>>>>>> working.
>>>>>>> I can connect to the host webserver through the browser, but not the
>>>>>>> mysql through the command line.
>>>>>>> Any ?
>>>>>>> Thanks
>>>>>>> Mike
>>>>>> It means you don't have the mysql client installed (or at least
>>>>>> available) on your client machine.
>>>>>> When you access MySQL via the browser, you're using the MySQL client
>>>>>> on the webserver. However, when you're using the command line, you're
>>>>>> using (or at least trying to use) the mysql client on your machine.
>>>>> I don't think he's even accesing MySQL through the browser. All he says is
>>>>> that he can connect to the host webserver.
>>>>> Ate the very least ee needs to put mysql.exe on his client machine. But I
>>>>> think he really needs a basic understanding of how computers work.
>>>> You could be correct, Paul. I just figured if he's connecting through
>>>> the webserver, he's connecting to MySQL (otherwise he wouldn't have
>>>> needed to mention it). And of course, if he's connecting to a
>>>> webserver, I figured he's using a browser.
>>>> But you're correct - I may be making too many assumptions.
>>>> --
>>>> ==================
>>>> Remove the "x" from my email address
>>>> Jerry Stuckle
>>>> JDS Computer Training Corp.
>>>> jstuck...@attglobal.net
>>>> ==================- Hide quoted text -
>>>> - Show quoted text -
>>> I have the mysql client installed
>>> I get "Cant connect to mysql on 192.168.1.102"
>>> I have root user with no password.
>>> mysql -h 192.168.1.102 -u root
>>> As far as the webserrver, I said that to show I can connect to my
>>> apache just using an ip address, so I figure I should be able to
>>> connect to mysql.
>>> I can ping it.
>>> I can connect to mysql from localhost.
>>> I added % host.
>>> Db table is empty
>>> Host Table is empty
>>> Anything else?
>>> Thanks
>> Is networking disabled for MySQL? Are you using the default port (3306)?
>> Both can be found in the my.ini file.
>>
>> Do you have a firewall blocking port 3306?
>>
>> Any of these can cause a failure to connect message.
>>
>> --
>> ==================
>> Remove the "x" from my email address
>> Jerry Stuckle
>> JDS Computer Training Corp.
>> jstuck...@attglobal.net
>> ==================- Hide quoted text -
>>
>> - Show quoted text -
>
> I unblocked the port, now I have Host 'Desktop" is not allowed to
> connect to this mysql server.
> I did not see networking disabled in my ini file.
> I added Desktop to the Host and User Tables
> Thanks
> Mike
>

You shouldn't need to add "Desktop" to your user table. However, you do
need to give permission to root@something. That something can be a host
name, ip address or '%' to indicate any (non-localhost) ip.

I don't recommend allowing root@% access - it's a big security problem.
But you could create another user and grant appropriate permissions.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

On Jan 6, 5:38pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> AMP wrote:
> > On Jan 6, 4:39 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> >> AMP wrote:
> >>> On Jan 6, 3:12 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> >>>> Paul Lautman wrote:
> >>>>> Jerry Stuckle wrote:
> >>>>>> AMP wrote:
> >>>>>>> Hello,
> >>>>>>> I am trying to connect to a mysql db on a home WORKGROUP. I tried
> >>>>>>> ip(given out by router) and Computer name.
> >>>>>>> I get "Mysql is not a recognised.....Batch....
> >>>>>>> I tried setting a PATH envirement variable in the host but this isnt
> >>>>>>> working.
> >>>>>>> I can connect to the host webserver through the browser, but not the
> >>>>>>> mysql through the command line.
> >>>>>>> Any ?
> >>>>>>> Thanks
> >>>>>>> Mike
> >>>>>> It means you don't have the mysql client installed (or at least
> >>>>>> available) on your client machine.
> >>>>>> When you access MySQL via the browser, you're using the MySQL client
> >>>>>> on the webserver. However, when you're using the command line, you're
> >>>>>> using (or at least trying to use) the mysql client on your machine.
> >>>>> I don't think he's even accesing MySQL through the browser. All he says is
> >>>>> that he can connect to the host webserver.
> >>>>> Ate the very least ee needs to put mysql.exe on his client machine. But I
> >>>>> think he really needs a basic understanding of how computers work.
> >>>> You could be correct, Paul. I just figured if he's connecting through
> >>>> the webserver, he's connecting to MySQL (otherwise he wouldn't have
> >>>> needed to mention it). And of course, if he's connecting to a
> >>>> webserver, I figured he's using a browser.
> >>>> But you're correct - I may be making too many assumptions.
> >>>> --
> >>>> ==================
> >>>> Remove the "x" from my email address
> >>>> Jerry Stuckle
> >>>> JDS Computer Training Corp.
> >>>> jstuck...@attglobal.net
> >>>> ==================- Hide quoted text -
> >>>> - Show quoted text -
> >>> I have the mysql client installed
> >>> I get "Cant connect to mysql on 192.168.1.102"
> >>> I have root user with no password.
> >>> mysql -h 192.168.1.102 -u root
> >>> As far as the webserrver, I said that to show I can connect to my
> >>> apache just using an ip address, so I figure I should be able to
> >>> connect to mysql.
> >>> I can ping it.
> >>> I can connect to mysql from localhost.
> >>> I added % host.
> >>> Db table is empty
> >>> Host Table is empty
> >>> Anything else?
> >>> Thanks
> >> Is networking disabled for MySQL? Are you using the default port (3306)?
> >> Both can be found in the my.ini file.
>
> >> Do you have a firewall blocking port 3306?
>
> >> Any of these can cause a failure to connect message.
>
> >> --
> >> ==================
> >> Remove the "x" from my email address
> >> Jerry Stuckle
> >> JDS Computer Training Corp.
> >> jstuck...@attglobal.net
> >> ==================- Hide quoted text -
>
> >> - Show quoted text -
>
> > I unblocked the port, now I have Host 'Desktop" is not allowed to
> > connect to this mysql server.
> > I did not see networking disabled in my ini file.
> > I added Desktop to the Host and User Tables
> > Thanks
> > Mike
>
> You shouldn't need to add "Desktop" to your user table. However, you do
> need to give permission to root@something. That something can be a host
> name, ip address or '%' to indicate any (non-localhost) ip.
>
> I don't recommend allowing root@% access - it's a big security problem.
> But you could create another user and grant appropriate permissions.
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstuck...@attglobal.net
> ==================- Hide quoted text -
>
> - Show quoted text -

The way this working is I am using the ip address in my connection
parameters and getting back "Host 'Desktop" is not allowed to
connect to this mysql server. "

I have 2 users with full priv. in the user table
User Host
root localhost
root 192.168.1.100

The above ip address is the client and the host is 192.168.1.102.
This is from my command line:
C:\Documents and Settings\Mike and Anna Marie>mysql -h 192.168.1.102 -
u root
ERROR 1130 (00000): Host 'DESKTOP' is not allowed to connect to this
MySQL server

Thanks
Mike

On Jan 6, 6:39pm, AMP <ampel...@gmail.com> wrote:
> On Jan 6, 5:38pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>
>
>
>
>
> > AMP wrote:
> > > On Jan 6, 4:39 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> > >> AMP wrote:
> > >>> On Jan 6, 3:12 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> > >>>> Paul Lautman wrote:
> > >>>>> Jerry Stuckle wrote:
> > >>>>>> AMP wrote:
> > >>>>>>> Hello,
> > >>>>>>> I am trying to connect to a mysql db on a home WORKGROUP. I tried
> > >>>>>>> ip(given out by router) and Computer name.
> > >>>>>>> I get "Mysql is not a recognised.....Batch....
> > >>>>>>> I tried setting a PATH envirement variable in the host but this isnt
> > >>>>>>> working.
> > >>>>>>> I can connect to the host webserver through the browser, but notthe
> > >>>>>>> mysql through the command line.
> > >>>>>>> Any ?
> > >>>>>>> Thanks
> > >>>>>>> Mike
> > >>>>>> It means you don't have the mysql client installed (or at least
> > >>>>>> available) on your client machine.
> > >>>>>> When you access MySQL via the browser, you're using the MySQL client
> > >>>>>> on the webserver. However, when you're using the command line,you're
> > >>>>>> using (or at least trying to use) the mysql client on your machine.
> > >>>>> I don't think he's even accesing MySQL through the browser. All hesays is
> > >>>>> that he can connect to the host webserver.
> > >>>>> Ate the very least ee needs to put mysql.exe on his client machine.. But I
> > >>>>> think he really needs a basic understanding of how computers work.
> > >>>> You could be correct, Paul. I just figured if he's connecting through
> > >>>> the webserver, he's connecting to MySQL (otherwise he wouldn't have
> > >>>> needed to mention it). And of course, if he's connecting to a
> > >>>> webserver, I figured he's using a browser.
> > >>>> But you're correct - I may be making too many assumptions.
> > >>>> --
> > >>>> ==================
> > >>>> Remove the "x" from my email address
> > >>>> Jerry Stuckle
> > >>>> JDS Computer Training Corp.
> > >>>> jstuck...@attglobal.net
> > >>>> ==================- Hide quotedtext -
> > >>>> - Show quoted text -
> > >>> I have the mysql client installed
> > >>> I get "Cant connect to mysql on 192.168.1.102"
> > >>> I have root user with no password.
> > >>> mysql -h 192.168.1.102 -u root
> > >>> As far as the webserrver, I said that to show I can connect to my
> > >>> apache just using an ip address, so I figure I should be able to
> > >>> connect to mysql.
> > >>> I can ping it.
> > >>> I can connect to mysql from localhost.
> > >>> I added % host.
> > >>> Db table is empty
> > >>> Host Table is empty
> > >>> Anything else?
> > >>> Thanks
> > >> Is networking disabled for MySQL? Are you using the default port (3306)?
> > >> Both can be found in the my.ini file.
>
> > >> Do you have a firewall blocking port 3306?
>
> > >> Any of these can cause a failure to connect message.
>
> > >> --
> > >> ==================
> > >> Remove the "x" from my email address
> > >> Jerry Stuckle
> > >> JDS Computer Training Corp.
> > >> jstuck...@attglobal.net
> > >> ==================- Hide quoted text -
>
> > >> - Show quoted text -
>
> > > I unblocked the port, now I have Host 'Desktop" is not allowed to
> > > connect to this mysql server.
> > > I did not see networking disabled in my ini file.
> > > I added Desktop to the Host and User Tables
> > > Thanks
> > > Mike
>
> > You shouldn't need to add "Desktop" to your user table. However, you do
> > need to give permission to root@something. That something can be a host
> > name, ip address or '%' to indicate any (non-localhost) ip.
>
> > I don't recommend allowing root@% access - it's a big security problem.
> > But you could create another user and grant appropriate permissions.
>
> > --
> > ==================
> > Remove the "x" from my email address
> > Jerry Stuckle
> > JDS Computer Training Corp.
> > jstuck...@attglobal.net
> > ==================- Hide quoted text-
>
> > - Show quoted text -
>
> The way this working is I am using the ip address in my connection
> parameters and getting back "Host 'Desktop" is not allowed to
> connect to this mysql server. "
>
> I have 2 users with full priv. in the user table
> User Host
> root localhost
> root 192.168.1.100
>
> The above ip address is the client and the host is 192.168.1.102.
> This is from my command line:
> C:\Documents and Settings\Mike and Anna Marie>mysql -h 192.168.1.102 -
> u root
> ERROR 1130 (00000): Host 'DESKTOP' is not allowed to connect to this
> MySQL server
>
> Thanks
> Mike- Hide quoted text -
>
> - Show quoted text -

I got it!!!

AMP wrote:
> On Jan 6, 5:38 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>> AMP wrote:
>>> On Jan 6, 4:39 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>>>> AMP wrote:
>>>>> On Jan 6, 3:12 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>>>>>> Paul Lautman wrote:
>>>>>>> Jerry Stuckle wrote:
>>>>>>>> AMP wrote:
>>>>>>>>> Hello,
>>>>>>>>> I am trying to connect to a mysql db on a home WORKGROUP. I tried
>>>>>>>>> ip(given out by router) and Computer name.
>>>>>>>>> I get "Mysql is not a recognised.....Batch....
>>>>>>>>> I tried setting a PATH envirement variable in the host but this isnt
>>>>>>>>> working.
>>>>>>>>> I can connect to the host webserver through the browser, but not the
>>>>>>>>> mysql through the command line.
>>>>>>>>> Any ?
>>>>>>>>> Thanks
>>>>>>>>> Mike
>>>>>>>> It means you don't have the mysql client installed (or at least
>>>>>>>> available) on your client machine.
>>>>>>>> When you access MySQL via the browser, you're using the MySQL client
>>>>>>>> on the webserver. However, when you're using the command line, you're
>>>>>>>> using (or at least trying to use) the mysql client on your machine.
>>>>>>> I don't think he's even accesing MySQL through the browser. All he says is
>>>>>>> that he can connect to the host webserver.
>>>>>>> Ate the very least ee needs to put mysql.exe on his client machine. But I
>>>>>>> think he really needs a basic understanding of how computers work.
>>>>>> You could be correct, Paul. I just figured if he's connecting through
>>>>>> the webserver, he's connecting to MySQL (otherwise he wouldn't have
>>>>>> needed to mention it). And of course, if he's connecting to a
>>>>>> webserver, I figured he's using a browser.
>>>>>> But you're correct - I may be making too many assumptions.
>>>>>> --
>>>>>> ==================
>>>>>> Remove the "x" from my email address
>>>>>> Jerry Stuckle
>>>>>> JDS Computer Training Corp.
>>>>>> jstuck...@attglobal.net
>>>>>> ==================- Hide quoted text -
>>>>>> - Show quoted text -
>>>>> I have the mysql client installed
>>>>> I get "Cant connect to mysql on 192.168.1.102"
>>>>> I have root user with no password.
>>>>> mysql -h 192.168.1.102 -u root
>>>>> As far as the webserrver, I said that to show I can connect to my
>>>>> apache just using an ip address, so I figure I should be able to
>>>>> connect to mysql.
>>>>> I can ping it.
>>>>> I can connect to mysql from localhost.
>>>>> I added % host.
>>>>> Db table is empty
>>>>> Host Table is empty
>>>>> Anything else?
>>>>> Thanks
>>>> Is networking disabled for MySQL? Are you using the default port (3306)?
>>>> Both can be found in the my.ini file.
>>>> Do you have a firewall blocking port 3306?
>>>> Any of these can cause a failure to connect message.
>>>> --
>>>> ==================
>>>> Remove the "x" from my email address
>>>> Jerry Stuckle
>>>> JDS Computer Training Corp.
>>>> jstuck...@attglobal.net
>>>> ==================- Hide quoted text -
>>>> - Show quoted text -
>>> I unblocked the port, now I have Host 'Desktop" is not allowed to
>>> connect to this mysql server.
>>> I did not see networking disabled in my ini file.
>>> I added Desktop to the Host and User Tables
>>> Thanks
>>> Mike
>> You shouldn't need to add "Desktop" to your user table. However, you do
>> need to give permission to root@something. That something can be a host
>> name, ip address or '%' to indicate any (non-localhost) ip.
>>
>> I don't recommend allowing root@% access - it's a big security problem.
>> But you could create another user and grant appropriate permissions.
>>
>> --
>> ==================
>> Remove the "x" from my email address
>> Jerry Stuckle
>> JDS Computer Training Corp.
>> jstuck...@attglobal.net
>> ==================- Hide quoted text -
>>
>> - Show quoted text -
>
> The way this working is I am using the ip address in my connection
> parameters and getting back "Host 'Desktop" is not allowed to
> connect to this mysql server. "
>
> I have 2 users with full priv. in the user table
> User Host
> root localhost
> root 192.168.1.100
>
> The above ip address is the client and the host is 192.168.1.102.
> This is from my command line:
> C:\Documents and Settings\Mike and Anna Marie>mysql -h 192.168.1.102 -
> u root
> ERROR 1130 (00000): Host 'DESKTOP' is not allowed to connect to this
> MySQL server
>
> Thanks
> Mike
>
>

Do you actually have a space between the '-' and the 'u'? And are you
not using any password?

Also - what privileges did you give root@192.168.1.100?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================