Stage 3 of install

I am at stage 3 of the install and get errors and can not get past this.

I assume that when I enter the info the system will automatically create a database for me.
( I even tryed creating one myself and it didnt work either.)

first error

Error while trying to connect to the database server:
SQLSTATE[28000] [1045] Access denied for user ‘admin’@‘localhost’ (using password: YES)

that was using the PDO_MYSQL
and using the MYSQLI i get

Error while trying to connect to the database server:
Access denied for user ‘admin’@‘localhost’ (using password: YES)

in the information required fields I put

database server local
login admin
password password
database name piwik
table prefix piwik_ ( and tried domain_piwik, domain_ and piwik_piwik (domain is using my cpanel username)
adapter PDO_MYSQL and MYSQLI

any help would be appreciated

P.S. I did try looking for an answer but couldnt see one…

On this screen, this would be an existing database user ID and password.

Thanks. Finally got it to work

the instructions are a bit misleading

Once the fields are filled in, Piwik will create a database if needed, as well as all the necessary Piwik tables.

the words being “will create” threw me off