AW: [opencms-dev] Database opencms created but not the tables..

[Jakob Lemler]

Hi,

you can check your root and password access first with the normal mysql
client in a dosshell:
Mysql -uroot -pxxxxx

When this works and you are logged in, you have the necessary entries
(root, xxxxx) for the root connection in opencms setup.
When it does not work you have to solve this problem with mysql first.

After that I usually create the opencms database as root manually within
the mysql client:
Create database opencms;

And create a user with the password you like with the mysql client:
Grant all privileges on opencms.* to username identified by 'password';

After that quit the mysql client, start the opencms setup in your
browser and use "opencms" as database name, "username" and "password"
for the cms connection in opencms setup... Should work.

Regards
      Jakob

-----Ursprüngliche Nachricht-----
Von: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org] Im Auftrag von laws
Gesendet: Mittwoch, 19. April 2006 23:18
An: The OpenCms mailing list
Betreff: [opencms-dev] Database opencms created but not the tables..


Hi
some steps made. Now I have the problem that the database is created but

not the tables. Somehow it disconnects.
I got mysql user =root with password ans opencms connection user=Admin  
password= admin. Is this right?
Judith
Comment by Opencms:
Tables could not be created!
Error connecting to database using:
"jdbc:mysql://localhost:3306/opencms".
-------------------------------------------
java.sql.SQLException: Access denied for user 'root'@'localhost' (using

password: YES) at  
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) at

and ...

Error executing SQL statement: CREATE TABLE CMS_USERS ( USER_ID
VARCHAR(36)

BINARY NOT NULL, USER_NAME VARCHAR(64) BINARY NOT NULL, USER_PASSWORD

VARCHAR(32) BINARY NOT NULL, USER_DESCRIPTION VARCHAR(255) NOT NULL,

USER_FIRSTNAME VARCHAR(50) NOT NULL, USER_LASTNAME VARCHAR(50) NOT NULL,

USER_EMAIL VARCHAR(100) NOT NULL, USER_LASTLOGIN BIGINT NOT NULL,  
USER_FLAGS INT

NOT NULL, USER_INFO BLOB, USER_ADDRESS VARCHAR(100) NOT NULL, USER_TYPE

INT NOT

NULL, PRIMARY KEY (USER_ID), UNIQUE (USER_NAME) ) ENGINE = MYISAM  
CHARACTER SET

utf8
-------------------------------------------
java.sql.SQLException: No operations allowed after connection closed. at








_______________________________________________
This mail is sent to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please
visit http://lists.opencms.org/mailman/listinfo/opencms-dev