It worked .... Thanks
Vijay -----Original Message----- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 24, 2001 4:45 PM To: Vijayanand Sukumar; '[EMAIL PROTECTED]' Subject: Re: problem with permissions on solaris At 16:06 -0700 10/24/01, Vijayanand Sukumar wrote: >Hi, >I installed Mysql on solaris 8 as root. I am able to access the database on >the system.(Create tables ...access them etc). >but when do it from the JSP it complains > >javax.servlet.servletException: General Error : Access denied for user: >'@sunblade11' to database 'Messages' . > >The connection url I use is > >String connectionURL = >"jdbc:mysql://sunblade11:3306/Messages?user=root;password="; Don't know if this is your problem, but MM.MySQL only understands '&' as the parameter separator, not ';', so you might try this instead: String connectionURL ="jdbc:mysql://sunblade11:3306/Messages?user=root&password="; If you're using Tomcat, note that there's an example jdbc:mysql string in conf/server.xml that uses the ';' character, which is incorrect. The example looks like this: <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99" driverName="org.gjt.mm.mysql.Driver" connectionURL="jdbc:mysql://localhost/authority?user=test;password=test" userTable="users" userNameCol="user_name" userCredCol="user_pass" userRoleTable="user_roles" roleNameCol="role_name" /> > >Can anyone please help me fix this problem ???? > > >Thanks in Advance > >Vijay -- Paul DuBois, [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php