Sorry, Sean, I think I forgot in the emails to you to mention that the MySQL server is running on a Solaris machine, I am trying to connect the database from a XP machine which is the one I am using.
I tried the same program in other Solaris machine, it works fine. I also noticed that the other Solaris machines are in the same subnet as the one in which Mysql server is running, all of them have 129.173.23.*, but the XP machine is different: 129.173.105.*, could it be possible the firewall on the Solaris system (I already turned off the firewall on the XP when I tried to connect to the mysql server.) block the connection from the XP to the port 3306 though I can use ssh or putty, winscp from the XP machine to remotely log in those Solaris machines. Again, thank you very much for your time and patience. I do appreciate it. Xiaobo > 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]
