Re: Connect to mysql on home network
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
|