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

[Alexander Wallace]

have you granted permissions to that user at localhost and did flush privileges?

On Thursday 04 August 2005 09:00 pm, rill wrote:
> 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\=UTF-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
> 
>