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 help?
Thanks
Mike

AMP wrote:
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 (AT) attglobal (DOT) net
==================

Jerry Stuckle wrote:
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:
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 (AT) attglobal (DOT) net
==================

On Jan 6, 3:12*pm, Jerry Stuckle <jstuck... (AT) attglobal (DOT) net> wrote:
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:
What precisely do you mean by the above?

AMP wrote:
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 (AT) attglobal (DOT) net
==================

On Jan 6, 4:39*pm, Jerry Stuckle <jstuck... (AT) attglobal (DOT) net> wrote:
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:
You shouldn't need to add "Desktop" to your user table. However, you do
need to give permission to root (AT) something (DOT) 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 (AT) attglobal (DOT) net
==================

On Jan 6, 5:38*pm, Jerry Stuckle <jstuck... (AT) attglobal (DOT) net> wrote:
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