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