You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Jan Behrens <Ja...@offis.de> on 2005/12/12 14:49:05 UTC
RE: Tomcat JDBC connection with MySQL
> String userName = "root";
> String password = "";
> String URL = "jdbc:mysql://l/AdressBook";
Are you sure this is correct? You are connecting to a MySQL server at URL
"1" and db "AdressBook" as root without a password...
you should:
- secure MySQL root with a password
- create a new user with rights limited to db "AdressBook" and allow this
user to connect from "%" for now
- set a password for that user
- reload user table!
- change your url to the correct server, e.g.
"jdbc:mysql//localhost:3306/AdressBook"
- try again
HTH, jan
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
RE: Tomcat JDBC connection with MySQL
Posted by marju jalloh <ja...@yahoo.com>.
I made it
Thanks everyone especially jan and Kirthik
Byfour
Jan Behrens <Ja...@offis.de> wrote: > String userName = "root";
> String password = "";
> String URL = "jdbc:mysql://l/AdressBook";
Are you sure this is correct? You are connecting to a MySQL server at URL
"1" and db "AdressBook" as root without a password...
you should:
- secure MySQL root with a password
- create a new user with rights limited to db "AdressBook" and allow this
user to connect from "%" for now
- set a password for that user
- reload user table!
- change your url to the correct server, e.g.
"jdbc:mysql//localhost:3306/AdressBook"
- try again
HTH, jan
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
---------------------------------
Yahoo! Shopping
Find Great Deals on Holiday Gifts at Yahoo! Shopping