CREATE command denied error when installing phpbb 2

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • selvamcbe
    New Member
    • Mar 2007
    • 4

    #1

    CREATE command denied error when installing phpbb 2

    sir
    I have a problem with installtion of phpbb 2 Forum in my website...
    I am having a website named http://www.clickonlinejobs.com Also i plan to include forum with it.So i have added my forum in my sub domain named
    http://www.forum.click onlinejobs.com. ..

    Here is the steps what i done for installation

    1.Based on Flash video tutorial which available in http://www.phpbb.com i copied my extracted phpbb files into my sub domain which located in my server
    /public html/forum and copied files succesfully into the server using Filezilla uploader.

    2.The next step I changed the file attributes for config.php to 666
    By earlier the file size is 0 Bytes.After changed the value into 666 still config.php
    is 0 Bytes..

    3.I created my database named selvam_db in my SQL server version 4.1.21-
    standard in my control panel. Then Databased password is password

    4.Then i create a username and password for database as follows...
    USER NAME : selvam_admin
    PASSWORD : password
    then i linked the corressponding databased with their user name and password.

    5.Now i am ready for installation.
    Now i am ready with my database name and USER ID and password for installation as follows.
    Database name : selvam_db
    USER NAME : selvam_admin
    PASSWORD : password

    Now i started my installation by typing in the browser window as http://www.forum.click onlinejobs.com
    Surprised the installation was started....

    As per Procedure i entered the following details for installation...

    Default board language: English
    Database Type: MySQL 4.x /5.x
    Choose your installation method: Install

    Database Configuration

    Database Server Hostname / DSN: localhost
    Your Database Name: selvam_db
    Database Username: selvam_admin
    Database Password: password
    Prefix for tables in database: phpbb_

    Admin Configuration
    Admin Email Address: skdivyaa@gmail. com (This is my Email address)
    Domain Name: http://www.forum.click onlinejobs.com
    Server Port: 80
    Script path: /
    Administrator Username: clickonlinejobs
    Administrator Password: *mypreferred securedpassword *
    Administrator Password [ Confirm ]: *mypreferred secured password*

    After Entering start install i got following error message.

    An error has occurred during installation
    An error occurred trying to update the database
    CREATE command denied to user 'selvam_admin'@ 'localhost' for table 'phpbb_auth_acc ess'

    What is the Problem now ? Can You guide me to install phpbb in my website ??
    I am a complete begginer Expecting Your Earlier reply in this regard

    Thanks in advance

    Selvam
  • pbmods
    Recognized Expert Expert
    • Apr 2007
    • 5821

    #2
    Originally posted by selvamcbe
    An error has occurred during installation
    An error occurred trying to update the database
    CREATE command denied to user 'selvam_admin'@ 'localhost' for table 'phpbb_auth_acc ess'
    This means that your admin login doesn't have permission to create the table. You might have to manually log into your mysql server and create the database / set up permissions for your User account:

    [code=sql]
    CREATE DATABASE IF NOT EXISTS selvam_db;
    GRANT ALL ON selvam_db.* TO 'selvam_admin'@ 'localhost';
    FLUSH PRIVILEGES;
    [/code]

    [EDIT: I went to the site (http://forum.clickonlinejobs.com), and it looks like it's working....]

    Comment

    Working...