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
