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

[Douglas Villalobos]

You should also add a password for the root user

If you have a Win OS, the following example starts by removing the anonymous
user that can be used by anyone to access the test database, then sets a
root user password:

C:\> C:\mysql\bin\mysql mysql
mysql> DELETE FROM user WHERE Host='localhost' AND User='';
mysql> QUIT
C:\> C:\mysql\bin\mysqladmin reload
C:\> C:\mysql\bin\mysqladmin -u root password your_password

After you've set the password, if you want to take down the mysqld server,
you can do so using this command:

C:\> mysqladmin --user=root --password=your_password shutdown

and other ways


shell> mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('new_password')
           WHERE user='root';
mysql> FLUSH PRIVILEGES;

You can, in MySQL Version 3.22 and above, use the SET PASSWORD statement:

shell> mysql -u root mysql
mysql> SET PASSWORD FOR root=PASSWORD('new_password');

Another way to set the password is by using the mysqladmin command:

shell> mysqladmin -u root password new_password



-----Original Message-----
From: owner-opencms-dev at www.opencms.com
[mailto:owner-opencms-dev at www.opencms.com]On Behalf Of Gabriel Garcia
Sent: Thursday, October 11, 2001 8:18 AM
To: opencms-dev at www.opencms.com
Subject: RE: [opencms-dev] Setup-Wizard with fixed user fails to connect
to MySQL


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