Can Someone explain this error message?

[hsuballer42]

CREATE TABLE phpbb_cash_log (
log_id int(11) NOT NULL auto_increment,
log_time int(11) NOT NULL default '0',
log_type smallint(6) NOT NULL default '0',
log_action varchar(255) NOT NULL default ' ',
log_text varchar(255) NOT NULL default ' ',
PRIMARY KEY (log_id)
);
+++ Error: Access denied for user: 'yscr_bbuwuB@localhost' to database 'phpbb'


im running a mod for my forum......my user name is 2003p.....i dont know where it is getting that?? can anyone explain this?

[DaiWelsh]

How are you running the query - phpmyadmin, mysql command line, via php?

[LiLcRaZyFuZzY]

what u could do, is to log in as the root user in mysql, then use the mysql database, and check the status of "yscr_bbuwuB" in the user table.

use mysql;


select * from user\G;


check what right this account has

[hsuballer42]

to answer daiwelsh i used i used the install.php file that came with the mode...i put it in my root directory and then ran it....all of the "INSERTO" lines ran fine...but when it came to running those tables i got the "access denied" error message.

i then ran the tables manually in phpmyadmin and the tables are there on the database

to answer fuzzy i did look at it and i dont know where it shows the rights.....everything is set on "no" though where as my "yroot" is set on yes....does that tell you anything??

thanks alot guys

[LiLcRaZyFuZzY]

well, u could try create a new user(a field) where u set them to YES) or maybe use ur root account to log to ur dB..?i dunno, give it a try

[hsuballer42]

ok...well i think i fixed it...that weird username was in the user ID's so went into it and changed everything to "yes" instead of "no" ...now everything is working fine..thanks...