Michael Hoennig <[EMAIL PROTECTED]> wrote:
>> > But we can NOT connect locally by host:port:
>>
>> >local-system> mysql -h 66.70.34.150 -O 3307 -u xyz00 -p
>> >=> ERROR 1045: Access denied for user: 'xyz00@localhost' (Using
>> > password: YES)
>>
>> > On a mysqld which is accessible onl
Hi Ireneusz,
> Hi
> I see:
> local-system> mysql -h 66.70.34.150 -O 3307 -u xyz00 -p
> hmm.
> I always use:
> >mysql -u xyz -p -h ... -P 3306
>
> Is the -O option in the right place. Maybe it sould be -P like PORT.
> Isn't??
sorry, typo in my mail. -P of course.
Alles Gute wü
-
From: "Michael Hoennig" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 15, 2002 3:37 PM
Subject: Re: mysql from localhost vs. remote
> Hi Dimitry,
>
> > > But we can NOT connect locally by host:port:
> >
> > > local-s
Hi Dimitry,
> > But we can NOT connect locally by host:port:
>
> > local-system> mysql -h 66.70.34.150 -O 3307 -u xyz00 -p
> > => ERROR 1045: Access denied for user: 'xyz00@localhost' (Using
> > password: YES)
>
> > On a mysqld which is accessible only locally the both INSERT
> > statem
Michael Hoennig <[EMAIL PROTECTED]> wrote:
> Hi mysql list members,
> We use the following statements to setup users and rigts for a mysql
> server which is accessible locally and via internet:
> INSERT INTO mysql.user VALUES
> ('%','xyz00',PASSWORD('...'),
> 'N','N','N','N','N','N','N','N','N
