Can someone explain the database creation via cpanel

[albaby]

The instructs in the install.txt are confusing, cpanel wants a database name, a user and pass. The install.txt (below) doesnt even mention a password?

3.  Create the cms database and grant a user rights to use it:
        - login to mysql: mysql -u root -p
            create database cms;
            grant all privileges on cms.* to cms_user@localhost identified by 'cms_pass';
            quit

[Hans]

I think this could be of help:
http://www.cmsmadesimple.org/quick_install.shtml
Hans

[Al Guevara]

Those were certianly better and clear instructions, thanks, but it still failed on Step 2


Warning: mysql_connect(): Access denied for user: 'cms_user@localhost' (Using password: YES) in /home/guevara/public_html/lib/adodb/drivers/adodb-mysql.inc.php on line 340
Connection failed

[Hans]

Are you sure you entered the databasename and the user correct? Sometimes cpanel adds a prefix before the names you entered (e.g. nameofsite_)
And : did you add the user to the database in question?
Hans

[Al Guevara]

Yes it seems Cpanel adds a PREFIX similar to the HOST username, to the database username, so thats my ACTUAL username? So its prefixa_cms_user, not cms_user?

[Hans]

Yes use the frefix in both the databasename and the user name.
Hans

[albaby]

It worked! Awesome, thanks much Hans!