Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Location
    /home/dislexik
    Posts
    820

    MySQL problem with 11 domains, but works with one :S

    Hey all, I have the following MySQL error:

    Warning: mysql_connect(): Access denied for user: [email protected]' (Using password: YES) in /home/ipbfree/public_html/conf_global/multiforums.config.inc.php on line 7

    Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/ipbfree/public_html/conf_global/multiforums.config.inc.php on line 8

    Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/ipbfree/public_html/conf_global/multiforums.config.inc.php on line 27

    Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/ipbfree/public_html/directory.php on line 152

    Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/ipbfree/public_html/directory.php on line 156

    This occurs on 11 domains that poiunt to a server, and another domain that points to the same server/webspace does not have this error.

    The situation:
    Pentium 4 3.0
    1024 DDR RAM
    80GB HDD

    - Web Server, currently

    Dual Xeon 2.4
    1024 DDR RAM
    73GB SCSI
    80GB - Backup etc

    - For MySQL

    Everything on the P4 will be moved over to the Dual Xeon soon, but thats not the point, why would:

    www.ipbfree.com not get MySQL errors, but domains pointing to the same thing such as:

    bb2.org
    ipbfree.org
    ipbfree.net
    vxs.org
    xpt.net
    tm7.org
    zud.org
    vnk.org
    yix.org
    freeforumhost.net
    t3.cc

    Get MySQL errors?

    Regards

    DislexiK
    "You donít learn to hack, you hack to learn"

  2. #2
    Join Date
    Jul 2002
    Location
    Kolding, Denmark
    Posts
    292
    Sounds like MySQL-permissions are wrong somewhere. Try connecting to the MySQL-service and check the settings in the MySQL-database. I'm pretty sure that you'll find a difference in either host, db or user that explains why one user is allowed access while the rest isn't.

    You could try making a backup of the entire mysql-database, replace it with a fresh copy from a newly installed mysql and then add the databases and users again. If you simply stop mysql and replace the files in /var/lib/mysql/mysql (or whereever your mysql-database resides) before starting it again you're not affecting the contents of the existing databases.
    Best regards,

    Anders C. Madsen
    Golden Planet Support - http://www.goldenplanet.com

  3. #3
    Join Date
    Aug 2003
    Posts
    2,734
    Do you use "localhost" as the hostname?

  4. #4
    Join Date
    Jan 2004
    Location
    /home/dislexik
    Posts
    820
    Markjut: host name is not localhost no

    gold, I will get my friend to have bash at that

    Regards

    DislexiK
    "You donít learn to hack, you hack to learn"

  5. #5
    Join Date
    Feb 2004
    Posts
    772
    Hi,

    The problem is you might have assigned only user on localhost have grant permission. you can give group permissions for group of hosts as following

    You can specify wildcards in the hostname. For example, user@'%.loc.gov' applies to user for any host in the loc.gov domain, and user@'144.155.166.%' applies to user for any host in the 144.155.166 class C subnet.

    For further details please refer this link

    http://dev.mysql.com/doc/mysql/en/GRANT.html

    Regards,

    Bright
    24 / 7 Technical Support
    Bright Info Solutions

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •