RE: MySQL Connector/J 2.0.14 issue

2002-08-21 Thread Fred Tsang
I think you're missing a few things: 1) Does your user have a password set? If it does, u need to use the following line to pass your username and password: Connection connection = java.sql.DriverManager.getConnection( "jdbc:mysql://localhost:3306/test", "username", "password"); 2) You n

Connecting to another machine with myCC

2002-08-29 Thread Fred Tsang
Folks, I have a question about myCC. I can't connect to a local linux machine (ip 192.168.0.232) for the life of me from my win2k box (ip 192.168.0.232) using myCC. I've done the following: GRANT ALL ON test.* TO 'fred'@'192.168.0.230'; FLUSH PRIVILEGES; but, in my mysql.log I still get: 020

RE: Connecting to another machine with myCC

2002-08-29 Thread Fred Tsang
Sorry everyone, I must've forgotten to set the password with an 'identified by' clause, or I needed to grant to *.*: grant all on *.* to "fred"@"192.168.0.230" identified by 'fred'; it works now. thanks! Fred > -Original Message- > From: Alexander Burbello [mailto:[EMAIL PROTECTED]] >