Re: where to report a bug? (was: mysql from localhost vs. remote)
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 with the issue. But the second field is db, not
user. Thus, the statement is correct by itself.
local mysql -h192.168.121.34 -uxyz00 -p1234 -e 'select user()'
+--+
| user() |
+--+
| [EMAIL PROTECTED] |
+--+
It works fine for me, you see? And no, I have not any other entry in
the privilege tables, that would allow user xyz00@localhost to
connect.
Thanks for eveluating this issue so thorowly.
The interesting part is, why does it display for you xyz00@localhost,
whilst it displays an IP for me? Are you sure you copied the correct
error message? If so, my first guess would be that your hosts config
is mixed up a bit.
You might be right, because it works today for me too! I just wanted to
try it again to check the error message, and now it suddenly works. I will
do some more tests, but it seems, the problem was somewhere else.
We had another, similar, issue two days ago. FTP logfiles showed
localhost for the client when FTP was used via SSH tunnel. Not it is the
hostname. I will check with the other hostmasters, if somebody changed
something.
Anyhow, xyz00@localhost should match the first of the both lines
in the user table.
That was my point, it SHOULD have worked anyway, but it didn't.
Doubling the user entries is not a good solution, by my opionon,
because it means that we have to maintain double rights and
passwords.
But only in the user table. You can use the hosts table to tell MySQL
that two (or more) host should be viewed as a group and avoid doubling
entries in the other ones this way.
I have not understood this yet, but I will check up with my colleagues (I
am not the mysql expert as you can easily see, but our mysql expert is
unavailable these days).
Thanks for your help!
Michael
--
Hostsharing eG / c/o Michael Hönnig / Boytinstr. 10 / D-22143 Hamburg
phone:+49/40/67581419 / mobile:+49/177/3787491 / fax:++49/40/67581426
http://www.hostsharing.net --- Webhosting Spielregeln selbst gemacht
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql from localhost vs. remote
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','N','N','N','N','N','N','N','N','N','N','N','N','N');
MH INSERT INTO mysql.db VALUES
MH ('%','xyz00_%','xyz00','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
MH The server runs on 66.70.34.150:3307. We can connect via socket locally
MH and via Host:Port remote:
MH remote-system mysql -h 66.70.34.150 -P 3307 -u xyz00 -p
MH = works
MH local-system mysql -S /var/run/mysql-ext/mysql.sock -u yxz00 -p
MH = works
MH But we can NOT connect locally by host:port:
MH local-system mysql -h 66.70.34.150 -O 3307 -u xyz00 -p
MH = ERROR 1045: Access denied for user: 'xyz00@localhost' (Using
MH password: YES)
MH On a mysqld which is accessible only locally the both INSERT statements
MH above would have localhost instead of %. Why does localhost not
MH qualify for %? Do we have to double the entries, having separate ones
MH for localhost? It does not make sense, does it?
When you set '%' or '66.70.34.150' for entries in table 'user'
that means you can access via TCP/IP, if you set 'localhost' that
means you can connect to the database through unix socket.
Please, look in the manual:
http://www.mysql.com/doc/C/o/Connection_access.html
http://www.mysql.com/doc/A/c/Access_denied.html
http://www.mysql.com/doc/A/d/Adding_users.html
MH Thanks
MH Michael
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
___/ www.mysql.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql from localhost vs. remote
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
('%','xyz00_%','xyz00','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
The server runs on 66.70.34.150:3307. We can connect via socket locally
and via Host:Port remote:
remote-system mysql -h 66.70.34.150 -P 3307 -u xyz00 -p
= works
local-system mysql -S /var/run/mysql-ext/mysql.sock -u yxz00 -p
= works
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 statements
above would have localhost instead of %. Why does localhost not
qualify for %? Do we have to double the entries, having separate ones
for localhost? It does not make sense, does it?
Thanks
Michael
--
Hostsharing eG / c/o Michael Hönnig / Boytinstr. 10 / D-22143 Hamburg
phone:+49/40/67581419 / mobile:+49/177/3787491 / fax:++49/40/67581426
http://www.hostsharing.net --- Webhosting Spielregeln selbst gemacht
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql from localhost vs. remote
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','N','N','N','N','N');
INSERT INTO mysql.db VALUES
('%','xyz00_%','xyz00','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
The server runs on 66.70.34.150:3307. We can connect via socket locally
and via Host:Port remote:
remote-system mysql -h 66.70.34.150 -P 3307 -u xyz00 -p
= works
local-system mysql -S /var/run/mysql-ext/mysql.sock -u yxz00 -p
= works
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 statements
above would have localhost instead of %. Why does localhost not
qualify for %?
Probably because you already have entry for 'localhost','%' or something to
that effect.
--
Dimitry
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql from localhost vs. remote
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 statements above would have localhost instead of %. Why does localhost not qualify for %? Probably because you already have entry for 'localhost','%' or something to that effect. nope, there is not such an entry. But IF we add it, we can login. This just means that we have to insert two entries (% and localhost) each. It looks clumsy to me. Michael -- Hostsharing eG / c/o Michael Hönnig / Boytinstr. 10 / D-22143 Hamburg phone:+49/40/67581419 / mobile:+49/177/3787491 / fax:++49/40/67581426 http://www.hostsharing.net --- Webhosting Spielregeln selbst gemacht - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql from localhost vs. remote
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 ?? Regards. I. Piasecki - webmaster www.b-c.pl - Original Message - 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-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 statements above would have localhost instead of %. Why does localhost not qualify for %? Probably because you already have entry for 'localhost','%' or something to that effect. nope, there is not such an entry. But IF we add it, we can login. This just means that we have to insert two entries (% and localhost) each. It looks clumsy to me. Michael -- Hostsharing eG / c/o Michael Hönnig / Boytinstr. 10 / D-22143 Hamburg phone:+49/40/67581419 / mobile:+49/177/3787491 / fax:++49/40/67581426 http://www.hostsharing.net --- Webhosting Spielregeln selbst gemacht - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Okresl Swoje potrzeby - my znajdziemy oferte za Ciebie! [ http://oferty.onet.pl ] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql from localhost vs. remote
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ünscht Michael -- Hostsharing eG / c/o Michael Hönnig / Boytinstr. 10 / D-22143 Hamburg phone:+49/40/67581419 / mobile:+49/177/3787491 / fax:++49/40/67581426 http://www.hostsharing.net --- Webhosting Spielregeln selbst gemacht - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql from localhost vs. remote
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 only locally the both INSERT statements above would have localhost instead of %. Why does localhost not qualify for %? Probably because you already have entry for 'localhost','%' or something to that effect. nope, there is not such an entry. But IF we add it, we can login. This just means that we have to insert two entries (% and localhost) each. It looks clumsy to me. One question - are sure that you have wrote -O instead -P as listed ? local-system mysql -h 66.70.34.150 -O 3307 -u xyz00 -p -- Dimitry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
where to report a bug? (was: mysql from localhost vs. remote)
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 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
('%','xyz00_%','xyz00','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
The server runs on 66.70.34.150:3307. We can connect via socket locally
and via Host:Port remote:
remote-system mysql -h 66.70.34.150 -P 3307 -u xyz00 -p
= works
local-system mysql -S /var/run/mysql-ext/mysql.sock -u yxz00 -p
= works
But we can NOT connect locally by host:port:
local-system mysql -h 66.70.34.150 -P 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 statements
above would have localhost instead of %. The bug is, in my opionon,
that localhost does not qualify for %? Doubling the user entries is
not a good solution, by my opionon, because it means that we have to
maintain double rights and passwords.
Ok, is there a bugreport possibility for mysql?
Thanks
Michael
--
Hostsharing eG / c/o Michael Hönnig / Boytinstr. 10 / D-22143 Hamburg
phone:+49/40/67581419 / mobile:+49/177/3787491 / fax:++49/40/67581426
http://www.hostsharing.net --- Webhosting Spielregeln selbst gemacht
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: where to report a bug? (was: mysql from localhost vs. remote)
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 behaviour is (I asked about it yestereday):
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
('%','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_%'.
Note that '_' and '%' have no special meaning within the user field -
to mean any user, use an empty user field. But the line wouldn't affect
xyz00 even if '_%' had a special meaning. For further details, see
http://www.mysql.com/doc/C/o/Connection_access.html.
The server runs on 66.70.34.150:3307. We can connect via socket locally
and via Host:Port remote:
Well, I inserted both lines above into my system (not giving any
privileges, but that doesn't matter, because it fails for you, before
any privileges are evaluated):
local mysqldump -t mysql user -w user like 'xyz%'
# MySQL dump 8.16
#
# Host: localhostDatabase: mysql
#
# Server version3.23.46-log
#
# Dumping data for table 'user'
# WHERE: user like 'xyz%'
#
INSERT INTO user VALUES
('%','xyz00','446a12100c856ce9','N','N','N','N','N','N','N','N','N','N','N','N','N','N');
INSERT INTO user VALUES
('%','xyz00_%','446a12100c856ce9','N','N','N','N','N','N','N','N','N','N','N','N','N','N');
remote-system mysql -h 66.70.34.150 -P 3307 -u xyz00 -p
= works
remote mysql -h192.168.121.34 -uxyz00 -p1234 -e 'select user()'
+--+
| user() |
+--+
| [EMAIL PROTECTED] |
+--+
local-system mysql -S /var/run/mysql-ext/mysql.sock -u yxz00 -p
= works
local mysql -hlocalhost -uxyz00 -p1234 -e 'select user()'
+-+
| user() |
+-+
| xyz00@localhost |
+-+
But we can NOT connect locally by host:port:
local-system mysql -h 66.70.34.150 -P 3307 -u xyz00 -p
= ERROR 1045: Access denied for user: 'xyz00@localhost'
(Using password: YES)
local mysql -h192.168.121.34 -uxyz00 -p1234 -e 'select user()'
+--+
| user() |
+--+
| [EMAIL PROTECTED] |
+--+
It works fine for me, you see? And no, I have not any other entry in
the privilege tables, that would allow user xyz00@localhost to
connect. After I delete the two rows, I get:
local mysql -h192.168.121.34 -uxyz00 -p1234 -e 'select user()'
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
The interesting part is, why does it display for you xyz00@localhost,
whilst it displays an IP for me? Are you sure you copied the correct
error message? If so, my first guess would be that your hosts config
is mixed up a bit.
Anyhow, xyz00@localhost should match the first of the both lines
in the user table.
On a mysqld which is accessible only locally the both INSERT statements
above would have localhost instead of %. The bug is, in my opionon,
that localhost does not qualify for %?
It should qualify and it does for me.
Doubling the user entries is not a good solution, by my opionon,
because it means that we have to maintain double rights and
passwords.
But only in the user table. You can use the hosts table to tell MySQL
that two (or more) host should be viewed as a group and avoid doubling
entries in the other ones this way.
Ok, is there a bugreport possibility for mysql?
Normally, you would use mysqlbug for this, which should have come with
your MySQL installation.
Bye,
Benjamin.
--
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
