4 messages in com.mysql.lists.javaRe: Java with MySQL
FromSent OnAttachments
RODEL MAYO26 Nov 2002 22:59 
Shamit Verma26 Nov 2002 23:24 
Peter T. Abplanalp27 Nov 2002 07:44 
mike markovich27 Nov 2002 09:05 
Subject:Re: Java with MySQL
From:Shamit Verma (mys@vshamit.com)
Date:11/26/2002 11:24:08 PM
List:com.mysql.lists.java

An easy way out would be to use some Administrative tool that would automate creation and maintenance of users.

I have used "MySQL Manager 1.7.6" it helped a lot.

It can ensure that this is not a User Config problem.

Regards, Shamit

----- Original Message ----- From: "RODEL MAYO" <mayo@hotmail.com> To: <ja@lists.mysql.com> Sent: Wednesday, November 27, 2002 12:30 PM Subject: Java with MySQL

Please help me, please, please please.....

Here is my situation:

1. I have a Linux server running mysql

host name: linuxserver ip address: 192.168.100.2

2. I have created a database named mydb

3. I have another computer running windows xp where I want to connect from.

host name: ws01-xp ip address: 192.168.100.4

Now, I want to learn how to do the following

1. create a user for the database 2. connect to mydb using java 3. display on the screen the records in the employees table

I have tried doing this myself but I encountered the following error:

SQLException: Server configuration denies access to data source

I also tried troobleshooting it by adding ws01-xp with its ip in the hosts file in my linux box but still won't run.

Almighty!

_________________________________________________________________ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail

--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/doc/ (the manual) http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <java@lists.mysql.com> To unsubscribe, e-mail <java-unsubscribe-mysql=vsha@lists.mysql.com>