Re: connecting to mysql from different computer

2001-12-12 Thread Rodney Broom
Good morning Kamal, From: <[EMAIL PROTECTED]> > More so will i need to open MySQL server on my local machine before running > MySQL client to connect to the remote machine e.g. No. The service (mysqld) is strictly assigned to managing the local database(s) and to serve access to those databas

Re: connecting to mysql from different computer

2001-12-12 Thread Carl Troein
[EMAIL PROTECTED] writes: > More so will i need to open MySQL server on my local machine before running > MySQL client to connect to the remote machine e.g. A client is a client and a server is a server. The point of separating the two is that you can then run the client somewhere and and the s

Re: connecting to mysql from different computer

2001-12-12 Thread hamzatk
>I suspect that you need to add an entry at the MySQL host for the machine that you are connecting from. This can be done with a GRANT statement: > >- Format: >grant all privileges on databaseName.tableName >to 'userName'@'hostName' >identified by 'somePassword'; > > >- Example

Re: connecting to mysql from different computer

2001-12-11 Thread Rodney Broom
From: <[EMAIL PROTECTED]> > I have a similar problem... Just to be sure, it's helpful if you could send us the message that your getting when you see the connection problem, but this sounds like the same thing. > Can this sovle my sleeplessness problem? Probably. Anytime I can't sleep, I jus

Re: connecting to mysql from different computer

2001-12-11 Thread hamzatk
At 03:23 PM 12/10/01 -0700, you wrote: >From: Dan <[EMAIL PROTECTED]> > >> I can connect... on the same computer >> ...different machine it won't work. I have a similar problem but let explain better may be i don't get what Dan was talking about. From my local computer i can use LOAD command to s

Re: connecting to mysql from different computer

2001-12-10 Thread Rodney Broom
From: Dan <[EMAIL PROTECTED]> > I can connect... on the same computer > ...different machine it won't work. I suspect that you need to add an entry at the MySQL host for the machine that you are connecting from. This can be done with a GRANT statement: - Format: grant all privileges on