Thanks for your speedy reply. I already turn off the firewall in the XP machine. I have no idea about the system sonfiguration on the Solaris machine.
I did this experiment as well: I installed Mysql 4.1.5 on XP machine, then use the same java program to connect to the 'test' data base from the installation. It works because I didn't network to anywhere I guess. Maybe, I should bring this to the system administrtor. It looking like a networking issue. Again, thank you very much for your patience and help. Xiaobo > Answers intermixed. See below.... > > "Xiaobo Chen" <[EMAIL PROTECTED]> wrote on 11/03/2005 04:28:08 PM: > >> Thank so much for the detailed explaination. I do appreciate it. >> >> It's more clear now. But I still have a question: >> >> I do see 'root' after: select user,host from mysql.user; >> >> Then I did this as you said: >> >> GRANT SELECT ON mydatabase.* TO [EMAIL PROTECTED] IDENTIFIED BY > 'mypassword'; >> >> then I issue: >> >> select * from mysql.user where user='root'; >> >> I found the select previlege is still 'N'. >> >> Besided this, how do I know 'mydatabase' from those tables in 'mysql' >> database that 'mydatabase' is allowed to be connected by 'root' from the >> IP. I am confusing here because the 'user' table only give the > association >> betweem 'host' and user 'root' in the Mysql server. But where is the >> database association? >> >> wait a minute, yes, I see. When I issue: >> >> select * from mysql.db where user='root'; >> >> I did see the association and the SELECT_priv is 'Y' there. >> > > That's correct, the `user` table controls GLOBAL permissions. The `db` > table controls database-specific permissions (there can be multiple > databases on any server). > > >> But, in the java program running in the local XP machine still can NOT >> connect to the database existing in the other Solaris machine!!!!!! >> >> I tried in the local XP machine: >> >> telnet theserver 3306 >> >> I failed. >> >> I guess this is why I can not connect to the server. Could be it > possible >> that the Solaris machine deny any request from the PC to the port 3306? > I >> can ssh to the server, or using winscp. > > There are several possibilities here: > XP is denying outbound connections to your Solaris machine (quite likely) > Solaris is denying connections from your XP machine (not likely) > Firewalls, routers, or proxy servers between the XP and Solaris machines > are blocking the connection attempt. > > If you were able to connect to the MySQL server, your MySQL error would > say that you "could not authenticate" not "could not connect" > > >> >> I am really confused here. Is it a mysql issue or the system > configuration >> issue on the server? > > I think it's a system configuration issue on the XP machine. I believe the > XP firewall is getting in your way. > >> >> Btw, I can run the same java program from other machine in Solaris > system >> to connect the database as the user 'root'. Does this imply that it's >> administration issue? > > Network administration, not MySQL administration (yet). > >> >> Thanks for your kind help and patience. >> >> Xiaobo >> >> > > > My pleasure! > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > <previous responses snipped> > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
