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
