Setting Up Remote Mysql Server

Discussion in 'Troubleshooting' started by PJ, Sep 14, 2003.

  1. PJ

    PJ Guest

    I'm running aMember Pro with 4images plugin. Recently, I setup a remote mysql server and wanted to connect aMember to it.

    I get the following error:

    MYSQL ERROR:
    select command denied to user: 'annsiang_3@64.5.51.158' for table '4images_groups'
    in query:
    SELECT group_id, group_name FROM sgboy_4images.4images_groups WHERE group_type=1

    Note: 64.5.51.158 is my existing server while annsiang_3 is a user I set in the remote server. The prefix should be annsiang_4images.4images_groups instead of sgboy_4images.4images_groups. I don't know how I got this error and I can't access anything. Please help.
  2. alex-adm

    alex-adm Guest

    Please go to aMember CP -> Setup -> 4Images and set correct database name and prefix.

Share This Page