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