mysql from localhost vs. remote

2002-02-16 Thread Victoria Reznichenko
Michael, Friday, February 15, 2002, 4:08:42 PM, you wrote: MH> Hi mysql list members, MH> We use the following statements to setup users and rigts for a mysql MH> server which is accessible locally and via internet: MH> INSERT INTO mysql.user VALUES MH> ('%','xyz00',PASSWORD('...'), MH> 'N',

Re: where to report a bug? (was: mysql from localhost vs. remote)

2002-02-16 Thread Michael Hoennig
Hi Benjamin, > > INSERT INTO mysql.db VALUES > > ('%','xyz00_%','xyz00','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'); > > Has the second line anything to do with the behaviour? It shouldn't as > you use "xyz00" below and user field will match only the user name > 'xyz00_%'. nope, has nothing to do

Re: where to report a bug? (was: mysql from localhost vs. remote)

2002-02-15 Thread Benjamin Pflugmann
Hi. On Sat, Feb 16, 2002 at 07:47:57AM +0100, [EMAIL PROTECTED] wrote: > Hi mysql list members, > > Meanwhile I am pretty sure that this strange behaviour is a bug. But > obviously I am blind. Where can mysql bugs be reportet? http://www.mysql.com/doc/B/u/Bug_reports.html > The strange behavio

where to report a bug? (was: mysql from localhost vs. remote)

2002-02-15 Thread Michael Hoennig
Hi mysql list members, Meanwhile I am pretty sure that this strange behaviour is a bug. But obviously I am blind. Where can mysql bugs be reportet? The strange behaviour is (I asked about it yestereday): We use the following statements to setup users and rigts for a mysql server which is access

Re: mysql from localhost vs. remote

2002-02-15 Thread Dimitry
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

Re: mysql from localhost vs. remote

2002-02-15 Thread Michael Hoennig
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ü

Re: mysql from localhost vs. remote

2002-02-15 Thread Ireneusz Piasecki
- 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

Re: mysql from localhost vs. remote

2002-02-15 Thread Michael Hoennig
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

Re: mysql from localhost vs. remote

2002-02-15 Thread Dimitry
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

mysql from localhost vs. remote

2002-02-15 Thread Michael Hoennig
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','N','N','N','N','N'); INSERT INTO mysql.db VALUES ('