newbie gets access denied/invalid authorization

[Ray Tayek]

hi, trying out opnecms. so i installed mysql on slak 8.0. added a root 
password (something like ... root password opencms) like the doc says, so i 
can do a: use mysql and create databases and tables if am root on the slak 
box. but only if i am root. trying to create a database (db2) as a  normal 
use gets a:

ERROR 1044: Access denied for user:
@localhost' to database db2
trying to use java to connect through the mysql connector java 3.0.8 stable 
(using user=root and password=opencms from the same box or a windoze box) 
gives me an sql exception:

     [java] testing com.mysql.jdbc.Driver
     [java] SQLException:
     [java]  SQLState: 08001
     [java]  Message: Server configuration denies access to data source
     [java]  Vendor: 0
running the setup wizard for open cms (as root on the same box) wants a 
password for the database connection and the opencms connection as user 
root in both cases. entering opencms in both locations results in a:

Could no connect to database via: jdbc:mysql://localhost:3306/
java.sql.SQLException: Invalid authorization specification: Access denied 
for user: '[EMAIL PROTECTED]' (Using password: YES)

the whole idea was to get opencms up, but i need to get mysql up in a 
usable state. i do not care about security at this point.

does anyone have any clues about how to fix this? or should i reinstall and 
not supply a root password?

any pointers would be appreciated.

thanks

---
ray tayek http://tayek.com/ actively seeking mentoring or telecommuting work
vice chair orange county java users group http://www.ocjug.org/
hate spam? http://samspade.org/ssw/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]