Forum setup help :( PHPBB3

[DhanB]

I get this error when i am trying to setup my forum i've looked everywhre for a solution but since i'm a COMPLETE noob at PHP and mySql ( i didn't even know wtf it was until a few hours ago) i have no idea what to do about it... HALP


hers the error i get

A fatal and unrecoverable database error has occurred. This may be because the specified user does not have appropriate permissions to CREATE TABLES or INSERT data, etc. Further information may be given below. Please contact your hosting provider in the first instance or the support forums of phpBB for further assistance.

install_install.php [ 1193 ]
SQL : CREATE TABLE phpbb_attachments ( attach_id mediumint(8) UNSIGNED NOT NULL auto_increment, post_msg_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, in_message tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, is_orphan tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, physical_filename varchar(255) DEFAULT '' NOT NULL, real_filename varchar(255) DEFAULT '' NOT NULL, download_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, attach_comment text NOT NULL, extension varchar(100) DEFAULT '' NOT NULL, mimetype varchar(100) DEFAULT '' NOT NULL, filesize int(20) UNSIGNED DEFAULT '0' NOT NULL, filetime int(11) UNSIGNED DEFAULT '0' NOT NULL, thumbnail tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, PRIMARY KEY (attach_id), KEY filetime (filetime), KEY post_msg_id (post_msg_id), KEY topic_id (topic_id), KEY poster_id (poster_id), KEY is_orphan (is_orphan) ) CHARACTER SET `utf8` COLLATE `utf8_bin`
CREATE command denied to user 'Dhan'@'XX.XX.XXX' for table 'phpbb_attachments'

[iKron]

This just means that you don't have the permission to alter the database. Go into your cPanel, and go to your database, and create a new user. Then give him all of the permissions for the database you created for this phpBB setup.

[mohaas05]

Are you using a hosted server or your own?

If it was your own, you'd just log into the mysql console as admin and do:

grant all on 'table.*' to 'user@localhost' identified by 'password';

[George]

I agree with all of the above answers.
+ internets for you guys

[DhanB]

thanks guys i got it running

Join ;D

torontoliveboards.tk