Its been a while since i've dealt much with MySQL permissions, but do you need to explicitly state 'localhost' as the machine in some circumstances.
The other thing i thought of is a guess, as i don't program Java, but have had an analogous problem using Perl. It it possible that Java is dealing with the passwords using the old password scheme and the server has the passwords in the new scheme (or the other way around)? Just a couple guesses that are probably incorrect. On Thursday 03 November 2005 16:02, [EMAIL PROTECTED] wrote: > 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> -- Sean Peters Senior Programmer, WIREData Inc. [EMAIL PROTECTED] "The software required Windows 2000 or better, so i Downloaded Linux" -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
