[opencms-dev] How to use user at localhost connect to mysql

[Arash Kaffamanesh]

Hi,

If your mysql server is on another mashine you shall give the
root at tomcat.server the right to connect to mysql mashine:

http://www.pomegranate.de:9000/cms/forum/viewthread?thread=18

HTH,

Arash

-----Original Message-----
From: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org] On Behalf Of rill
Sent: Freitag, 5. August 2005 04:01
To: The OpenCms mailing list
Subject: Re: Re: [opencms-dev] How to use user at localhost connect to
mysql


Alexander Wallace,您好！

	Maybe it's mysql host reason. In another pc-linux, I succeed use
user at localhost. But I don't know why failed in this host. my /etc/hosts
is:

# cat /etc/hosts
127.0.0.1       localhost


======= 2005-08-04 22:44:02 =======

>What is the error you get? I find it likely that user at localhost has no
>permissions to connect, but the error will tell you the actual problem,
can 
>you share it here?
>
>On Thursday 04 August 2005 12:18 am, rill wrote:
>> hello！
>> 
>> 	I install opencms6.0 use user@%, now I want to use
user at localhost to
>connect mysql, but connect always failed! Why, what I must do!
>>     I modify opencms.properties as:
>> 
>> # name of the JDBC driver 
>> db.pool.default.jdbcDriver=org.gjt.mm.mysql.Driver
>> 
>> # URL of the JDBC driver 
>> db.pool.default.jdbcUrl=jdbc:mysql://localhost:3306/opencms
>> 
>> # optional parameters for the URL of the JDBC driver 
>> db.pool.default.jdbcUrl.params=?useUnicode\=true&characterEncoding\=U
>> TF-8
>> 
>> # user name to connect to the database db.pool.default.user=user
>> 
>> # password to connect to the database 
>> db.pool.default.password=userpassword
>> 
>> # the URL to make the JDBC DriverManager return connections from the 
>> DBCP
>pool
>> db.pool.default.poolUrl=opencms:default
>> 
>> # the maximum number of objects that can be borrowed from the pool 
>> db.pool.default.maxActive=25
>> 
>> 　　　　　　　　
>> Best Regards			
>> 　　　　　　　　
>> 　　　　　　　　
>> -rill
>> 
>
>
>_______________________________________________
>This mail is send to you from the opencms-dev mailing list
>To change your list options, or to unsubscribe from the list, please 
>visit http://mail.opencms.org/mailman/listinfo/opencms-dev

= = = = = = = = = = = = = = = = = = = =
			

 
				 
　　　　　　　　rill
　　　　　　　　itjiang at 163.com
　　　　　　　　　　2005-08-05