Hey all, I have the following MySQL error:

Warning: mysql_connect(): Access denied for user: 'ipbfree1_ipbf@69.93.81.171' (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

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.

Do you use "localhost" as the hostname?

Markjut: host name is not localhost no

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

Regards

DislexiK

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