List:MySQL and Java« Previous MessageNext Message »
From:Samuel Noullier Date:July 22 1999 5:14am
Subject:need some help about MySQL installation and connection through java
View as plain text  
Hi everybody


I introduce myself, My name is Samuel Noullier, I'm a student who
actually develop a Java Program.
I want to use MySQL as a Database (of course).
But I have some problems with it.

I just  want to create some table in two databases. I would like that
all the people from all the host can log at this
database.
Of course I use the driver include in JDK-1.1.6, there is no problem
with it.
Only  when I want to log at the MySQL server with this command

String url = jdbc:mysql://192.168.0.13:3306/loc;
String userName = guest;
String passWord = ""; //No password

con = (Connection) DriverManager.getConnection(url, userName, passWord);

As you can see, the MySQL daemon runs on the 192.168.0.13 machine. I
would like to use the port number 3306
for the communication.

So My question is very simple, but I try to install this the last 3 days
without succes.

I would like that all the user with the userName : guest, could connect
to this MySQl database from any host
without password. The aim is to consult some tables in two directories
("mao" and "loc"). The users could write
and read in these tables. I have so many problems with the access.
Someone could explain me step by step the actions to install the MySQL
daemon (maybe my installation is
wrong),
and to allow these specifics users ("guest") to connect from anywhere
without password.

I'm not an idle, no I have readed a lot things about mysql installation,
jdbc....But now I'm lost with the database
mysql and the tables user, db....

Help !!!!!!!!!!!!!

Thanks guys

--

                          Shammy the Search Bis
                      University of New South Wales

Attachment: [text/html]
Attachment: [text/html]
Attachment: [text/html]
Thread
need some help about MySQL installation and connection through javaSamuel Noullier22 Jul
  • Re: need some help about MySQL installation and connection through javaSamuel Noullier22 Jul