[opencms-dev] Setup-Wizard with fixed user fails to connect to MySQL

[Gabriel Garcia]

Why don't you tri to do it wit the defaul admin user?
I mean using login: admin , password: admin?

I suggest you reinstall mySQL using the default users ...


GABRIEL GARCIA O
Developer
e.mail : ggarcia at azurian.com
Azurian
Andean Region
Ph.(571)640-0020//Fax(571)601-9787


This e-mail and any files transmitted with it are for the sole use of the
intended recipient(s) and may contain confidential and privileged
information. If you are not the intended recipient, please contact the
sender by reply e-mail and destroy all copies of the original message. Any
unauthorised review, use, disclosure, dissemination, forwarding, printing or
copying of this email or any action taken in reliance on this e-mail is
strictly prohibited and may be unlawful.



-----Original Message-----
From: owner-opencms-dev at www.opencms.com
[mailto:owner-opencms-dev at www.opencms.com]On Behalf Of Andreas Urra
Sent: Jueves, 11 de Octubre de 2001 08:46 a.m.
To: opencms-dev at opencms.com
Subject: [opencms-dev] Setup-Wizard with fixed user fails to connect to
MySQL


Hello,

after serveral installations (of Java, Tomcat 3.3 rc1 and MySQL 3.23.43)
the Setup-Wizard is still not working.

In the Wizard (no matter if Standard or Advanced) I insert
------------------------------------
Resource Broker:    mysql
Database Server Connection: (user) root (password) (blank) [after all, I
deleted any passwords for testing)
OpenCms Connection: (user) root (password) (blank) [by the way: what
does that mean?]

Connetion String: jdbc:mysql://localhost:3306/
Database: opencms

Create database and tables Warning: Existing database will be dropped:
(checked)
-----------------------

-> no matter what users, passwords or connect-strings I enter, the
following screen stays the same:

-----------------------
Trying to drop database ... Failed

Creating database ... Ok

Creating tables ... Failed


java.sql.SQLException: Invalid authorization specification: Access
denied for user: 'root at localhost' (Using password: NO)
-------------------------------------------

One time an absolutely empty database was created. The next time not.
The user-table of MySQL looks like:
+------------------------+------+----------+
| Host                   | User | Password |
+------------------------+------+----------+
| localhost              | root |                             |
| feldberg               | root |                             |
| localhost              |        |                              |
| feldberg               |        |                              |
| %.ourcompany.com | root |                         |
+------------------------+------+----------+

Where do I have to look for the error?
Additional Info: I didn't create a .my.cnf File in /root - is that
really necessary? It is not very well documentated.

Greetings, and thanks for all kind of help,

Andreas


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com