[opencms-dev] Databse could not be created

[Barry]

And also, does the user 'root' have a Host value of either
'localhost.localdomain' or '%' (try "select Host, User from user" to check)

> Does user 'root' in your mysql database have a password at all? If not,
> give it one.
> Secondly, can user 'root' actually login to mysql using something like
> 'mysql -p password_here' ??
> 
> Frans
> 
> > -----Original Message-----
> > From: opencms-dev-bounces at opencms.org
> > [mailto:opencms-dev-bounces at opencms.org] On Behalf Of Giuliano Dessì
> > Sent: donderdag 14 april 2005 17:09
> > To: opencms-dev at opencms.org
> > Subject: [opencms-dev] Databse could not be created
> >
> > Hi all.
> > OpenCms version: 6.0 beta 2 Corrin with OpenCms Setup Wizard.
> > All component tests are ok, but no database is created.
> > In the section "OpenCms Setup Wizard - Create database & tables" is
> > generated an error.
> > How can I fix the problem??
> >
> > Database could not be created!
> >
> > Error connecting to database using: jdbc:mysql://localhost:3306/
> > -------------------------------------------
> > java.sql.SQLException: Access denied for user:
> > 'root at localhost.localdomain' (Using password: YES) at
> > com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2847) at
> > com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:750) at
> > com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1205) at
> > com.mysql.jdbc.Connection.createNewIO(Connection.java:1768) at
> > com.mysql.jdbc.Connection.(Connection.java:430) at
> > com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriv
> > er.java:268)
> > at java.sql.DriverManager.getConnection(DriverManager.java:512) at
> > java.sql.DriverManager.getConnection(DriverManager.java:171) at
> > org.opencms.setup.CmsSetupDb.setConnection(CmsSetupDb.java:99) at
> > org.apache.jsp.step_5_database_creation_jsp._jspService(step_5
> > _database_creation_jsp.java:111)
> > at
> > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:92) at
> > javax.servlet.http.HttpServlet.service(HttpServlet.java:809) at
> > org.apache.jasper.servlet.JspServletWrapper.service(JspServlet
> > Wrapper.java:162)
> > at
> > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet
> > .java:240)
> > at
> > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:187) at
> > javax.servlet.http.HttpServlet.service(HttpServlet.java:809) at
> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilt
> > er(ApplicationFilterChain.java:200)
> > at
> > org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli
> > cationFilterChain.java:146)
> > at
> > org.apache.catalina.core.StandardWrapperValve.invoke(StandardW
> > rapperValve.java:209)
> > at
> > org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invokeNext(StandardPipeline.java:596)
> > at
> > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> > ine.java:433)
> > at
> > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
> > at
> > org.apache.catalina.core.StandardContextValve.invoke(StandardC
> > ontextValve.java:144)
> > at
> > org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invokeNext(StandardPipeline.java:596)
> > at
> > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> > ine.java:433)
> > at
> > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
> > at
> > org.apache.catalina.core.StandardContext.invoke(StandardContex
> > t.java:2358)
> > at
> > org.apache.catalina.core.StandardHostValve.invoke(StandardHost
> > Valve.java:133)
> > at
> > org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invokeNext(StandardPipeline.java:596)
> > at
> > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDi
> > spatcherValve.java:118)
> > at
> > org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invokeNext(StandardPipeline.java:594)
> > at
> > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport
> > Valve.java:116)
> > at
> > org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invokeNext(StandardPipeline.java:594)
> > at
> > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> > ine.java:433)
> > at
> > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
> > at
> > org.apache.catalina.core.StandardEngineValve.invoke(StandardEn
> > gineValve.java:127)
> > at
> > org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invokeNext(StandardPipeline.java:596)
> > at
> > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> > ine.java:433)
> > at
> > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
> > at
> > org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.
> > java:152)
> > at
> > org.apache.coyote.http11.Http11Processor.process(Http11Process
> > or.java:799)
> > at
> > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandle
> r.processConnection(Http11Protocol.java:705)
> > at
> > org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoi
> > nt.java:577)
> > at
> > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
> > ThreadPool.java:683)
> > at java.lang.Thread.run(Thread.java:534)
> > -------------------------------------------
> > Error parsing database setup SQL script in line: CREATE DATABASE
> > ${database};
> > -------------------------------------------
> > java.lang.NullPointerException at
> > org.opencms.setup.CmsSetupDb.executeStatement(CmsSetupDb.java:407) at
> > org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:331) at
> > org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:266) at
> > org.opencms.setup.CmsSetupDb.createDatabase(CmsSetupDb.java:160) at
> > org.apache.jsp.step_5_database_creation_jsp._jspService(step_5
> > _database_creation_jsp.java:273)
> > at
> > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:92) at
> > javax.servlet.http.HttpServlet.service(HttpServlet.java:809) at
> > org.apache.jasper.servlet.JspServletWrapper.service(JspServlet
> > Wrapper.java:162)
> > at
> > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet
> > .java:240)
> > at
> > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:187) at
> > javax.servlet.http.HttpServlet.service(HttpServlet.java:809) at
> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilt
> > er(ApplicationFilterChain.java:200)
> > at
> > org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli
> > cationFilterChain.java:146)
> > at
> > org.apache.catalina.core.StandardWrapperValve.invoke(StandardW
> > rapperValve.java:209)
> > at
> > org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invokeNext(StandardPipeline.java:596)
> > at
> > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> > ine.java:433)
> > at
> > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
> > at
> > org.apache.catalina.core.StandardContextValve.invoke(StandardC
> > ontextValve.java:144)
> > at
> > org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invokeNext(StandardPipeline.java:596)
> > at
> > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> > ine.java:433)
> > at
> > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
> > at
> > org.apache.catalina.core.StandardContext.invoke(StandardContex
> > t.java:2358)
> > at
> > org.apache.catalina.core.StandardHostValve.invoke(StandardHost
> > Valve.java:133)
> > at
> > org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invokeNext(StandardPipeline.java:596)
> > at
> > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDi
> > spatcherValve.java:118)
> > at
> > org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invokeNext(StandardPipeline.java:594)
> > at
> > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport
> > Valve.java:116)
> > at
> > org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invokeNext(StandardPipeline.java:594)
> > at
> > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> > ine.java:433)
> > at
> > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
> > at
> > org.apache.catalina.core.StandardEngineValve.invoke(StandardEn
> > gineValve.java:127)
> > at
> > org.apache.catalina.core.StandardPipeline$StandardPipelineValv
> eContext.invokeNext(StandardPipeline.java:596)
> > at
> > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> > ine.java:433)
> > at
> > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
> > at
> > org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.
> > java:152)
> > at
> > org.apache.coyote.http11.Http11Processor.process(Http11Process
> > or.java:799)
> > at
> > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandle
> r.processConnection(Http11Protocol.java:705)
> > at
> > org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoi
> > nt.java:577)
> > at
> > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
> > ThreadPool.java:683)
> > at java.lang.Thread.run(Thread.java:534)
> >
> >
> > _______________________________________________
> > 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
> >
> 
> 
> 
> _______________________________________________
> 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