privileges table: interpretation of _ changed

2005-04-23 Thread Michael Hoennig
Dear mySQl community, In the following I do not only list a problem, others might also run in, but I also want to point out a stangeness of one of your fixes. Recently there was a change in 3.23.49 (on Debian/Woody): * Applied patch for a bug that wrongly interpreted '_' in conjunction with

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

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 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 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

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 ('