MySQL & jdbc -Got it !
Anselme
anselme at netcourrier.com
Tue May 13 06:44:27 PDT 2003
> On Tue, 2003-05-13 at 08:26, Tom Samplonius wrote:
>
> >
> > And "user" isn't the only access table. There is a table for hosts, and
> > as well as databases. The MySQL permissions system is very complicated.
> >
>
You were right !!
I kept
127.0.0.1 localhost.mydomain.com localhost
in /etc/hosts.
BUT in the database mysql I've change like this :
mysql> select host, user from user where user="anselme" ;
+-----------------------+-----------+
| host | user |
+-----------------------+-----------+
| localhost.mydomain.com | anselme |
+-----------------------+-----------+
1 row in set (0.01 sec)
AND (very important)
mysql> select host, user from tables_priv where user="anselme" ;
+-----------------------+-----------+
| host | user |
+-----------------------+-----------+
| localhost.mydomain.com| anselme |
+-----------------------+-----------+
1 rows in set (0.00 sec)
Now, it works !!
I don't think there is any problem doing like this ?
Thank you very much everybody for your help
:))
--
Anselme <anselme at netcourrier.com>
More information about the freebsd-database
mailing list