Mysql Troubles

Discussion in 'Installation' started by BIGPimpShet, Apr 28, 2003.

  1. BIGPimpShet

    BIGPimpShet Guest

    :blink:
    I was wondering... im stuck on step 2 of the setup... what do i fill in for the "mysql database"? When i try an existing database, i get the error

    * cannot select database 'databasename'(access denied for user: 'username@localhost' to database 'databasename')

    I'm stuck at that stage... no matter what i do, it seems to deny me... my webhost assures me that my password/login info is correct though...

    Also, just as a precaution, ill ask this question too... "MYSQL Tables prefix"... should i use the default one given by your program?

    Thanks for your help :rolleyes:
  2. alex-adm

    alex-adm Guest

    Login into your webhosting CPanel, go to "MySQL databases" and add access for user "username" to database "database".

    Just use "amember_" prefix.
  3. rabie

    rabie Guest

    hi all ,
    i tried to install amember script . but i got a mysql syntax ERROR :

    in this block : CREATE TABLE @DB_MYSQL_PREFIX@access_log(
    log_id int(11) NOT NULL auto_increment,
    member_id int(11) default '0',
    time timestamp(14) NOT NULL,
    url varchar(255) default NULL,
    remote_addr varchar(15) default NULL,
    referrer varchar(255) default NULL,
    PRIMARY KEY (log_id),
    INDEX (member_id, `time`, remote_addr),
    INDEX (`time`)
    )
    ;
    at the line 9 well if i ll use INDEX syntax also the member_id and time remot_addr must be NOT NULL defined
    i tried to do not use the UNIQUE INDEX everything was OK but when i go to signup to test i can t see the Field of Membership Type , can any member here help ? ??
    with Thanks
    Rabie
  4. alex-adm

    alex-adm Guest

Share This Page